Does SQL substitute float = 0 with DBNull.Value?

Hi
I have only been coding in .Net for about six months, and am not sure if this is a C# problem or an SQL one. I use the Data Access Application Block in my program.

I have two optional fields on my form (RangeFrom and RangeTo). If the user chooses not to enter data into these textboxes(textbox = ""), an entry on the db is created with null values. It works.

But sometimes the user wants to enter 0 as either an upper or lower end of a range. This is where my problem comes in. My program saves 0 as null too.

In my program I do a test on the textboxes and populate two float values in a business object (objQuestion) accordingly, like this:

if (txtrangefrom.Text != "") {
objQuestion.RangeFrom=float.Parse(txtrangefrom.Text);
objQuestion.RangeTo=float.Parse(txtrangeto.Text);
}
else {
objQuestion.RangeFrom=Convert.ToSingle(null);
objQuestion.RangeTo=Convert.ToSingle(null);
}

And this is what my Business object look like. It sets up the parameters and calls the Data Access Application Block to create an entry in my table:

// fieldslist
float cvintRangeFrom;
float cvintRangeTo;
//properties
public float RangeFrom {
get {
return cvintRangeFrom;
}
set {
cvintRangeFrom = value;
}
}
public float RangeTo {
get {
return cvintRangeTo;
}
set {
cvintRangeTo = value;
}
}
// some code deleted for readability...
public int AddOption() {
string cvstrSpName = "addOption";
SqlParameter [] cvstrStoredParams = SqlHelperParameterCache.GetSpParameterSet(gcstrConnectionString, cvstrSpName, true);
//lines deleted for readability...
//check if the optional fields have a value associated with them. if not, assign dbnull.value.
cvstrStoredParams[4].Value=(cvintRangeFrom != Convert.ToSingle(null) ? cvintRangeFrom : (object)DBNull.Value);
cvstrStoredParams[5].Value=(cvintRangeTo != Convert.ToSingle(null) ? cvintRangeTo : (object)DBNull.Value);
//lines deleted for readability...
SqlHelper.ExecuteNonQuery(gcstrConnectionString, CommandType.StoredProcedure, cvstrSpName, cvstrStoredParams);
return(cvintOptionID = Convert.ToInt32(cvstrStoredParams[0].Value));
}

I use Convert.ToSingle when working with nulls (or possible nulls) because I get an error when I use float.parse for this.

The thing is, after this method AddOption has been executed, I test the value if the business object's rangefrom (that is where I entered 0) and display it on my form. I still shows a 0, but on my database table it is null!

objQuestion.AddOption();
//txtrangefrom.Text=""; on the next line I test the value in the business object...
txtrangefrom.Text=objQuestion.RangeFrom.ToString(); // and this displays 0!!!
//txtrangeto.Text="";
txtrangeto.Text=objQuestion.RangeTo.ToString();

So to me it seems the problem seems to be either the DAAB or on the SQL side, but hopefully somebody can prove me wrong! I was thinking that it could also be float.parse/Convert.ToSingle methods and have done various tests, but I am none the wiser...
Any help or ideas will be greatly appreciated...I had this same problem with a VB project.

Just change the value of the floats to something that is not within the valid range (-1 or something) instead of null. It's not pretty or elegant, but it's better than fiddling with nulls ;)

SQLServer (I think) does implicitly convert 0 to null in some occasions, but I don't know the full details.

HTH|||You're right, it's not pretty, but I'll give it a go.
Thanks.

Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.

Does Sql Ce 3.5 beta version support remote access in Intranet

I need to connect to a sql ce data file via Intranet .
Does sql ce support that ?
When I attempt to connect that remote file, it show me the error message
"There is a file sharing violation .A different process migth be using this file".

Does this mean , I can not do this .

This means that SQL Compact is a single user, in-process database, so when opening a file on a network share it will acquire an exclusive lock to the database file. For more information, see these blog entries from Jim Wilson:

http://www.pluralsight.com/blogs/jimw/archive/2007/02/19/46151.aspx

|||Good answer .

Thank you ErikEJ

I like this forum.

Does SQL 2005 purchase come with access to SQL 2000 media?

My company is planning to purchase a SQL2005 standard Processor license (unlimited users - about $5000)

Does anyone know if we can obtain SQL2000 media along with the purchase. Because of the app we are running and its stage of development, we have to install and run SQL2000 for about 6 months before we can run Sql2005. We dont want to purchase SQL2000 for such a short term use.

I asked a DELL rep to help me with this over a month ago and he still has no answers for me.

Any help with this would be greatly appreciated.

Already answered this question ton the setup & upgrade forum:

My previous response:

SQL Server 2000 is not provided with SQL Server 2005. Some components that ship with SQL Server 2005 will update existing SQL Server 2000 components to address any compatibility issues.

You have a couple of options:

* Use the SQL Server 2000 eval for the time being. Not sure if it is still available

* Use SQL Server 2000 MSDE, as it is a free download. Not sure if it is still available

* Use SQL Server 2005 but run the database(s) in SQL Server 2000 (version 8) compatibility mode.

Thanks,

Peter Saddow

|||

I believe that the SQL 2005 license covers using a downlevel version. However, for definitive answers to licensing questions, call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

You will have to contact Microsoft Fullfillment to obtain the media, or if you have access to your MSDN subscription...

Does RS process sleep?

I tried both SQL2000 & SQL2005.
But both servers RS processes sleep if no users access to them over an hour.
Once it sleeps, the user has to wait 20 seconds to start responding the
request.
Is this normal? Is there anyway to prevent this waiting time?
Please help!!What I do is have a very simple report that auto-refreshes every 5 minutes.
That keeps it alive. There is also an IIS configuration that can be set but
I haven't used it and I don't remember it off the top of my head. The
auto-refresh is pretty easy hack though.
Instead of 5 minutes you could set it longer than than (30 minutes?).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aki Nomura" <anomura@.jtb.com> wrote in message
news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>I tried both SQL2000 & SQL2005.
> But both servers RS processes sleep if no users access to them over an
> hour.
> Once it sleeps, the user has to wait 20 seconds to start responding the
> request.
> Is this normal? Is there anyway to prevent this waiting time?
> Please help!!
>
>|||Auto-refreshes means scheduling report?
Actually I tried an every 3 minutes schedule report.
But it didn't work for my case.
Anyway, I will try the IIS configuration.
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OXDxAt6%23FHA.328@.TK2MSFTNGP14.phx.gbl...
> What I do is have a very simple report that auto-refreshes every 5
> minutes. That keeps it alive. There is also an IIS configuration that can
> be set but I haven't used it and I don't remember it off the top of my
> head. The auto-refresh is pretty easy hack though.
> Instead of 5 minutes you could set it longer than than (30 minutes?).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Aki Nomura" <anomura@.jtb.com> wrote in message
> news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>>I tried both SQL2000 & SQL2005.
>> But both servers RS processes sleep if no users access to them over an
>> hour.
>> Once it sleeps, the user has to wait 20 seconds to start responding the
>> request.
>> Is this normal? Is there anyway to prevent this waiting time?
>> Please help!!
>>
>|||Layout, report tab, autorefreshes checkbox. Once you have a report that
autorefreshes then open it and leave it up. This has worked for me both with
RS 2000 and RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aki Nomura" <anomura@.jtb.com> wrote in message
news:OzI$fDD$FHA.504@.TK2MSFTNGP09.phx.gbl...
> Auto-refreshes means scheduling report?
> Actually I tried an every 3 minutes schedule report.
> But it didn't work for my case.
> Anyway, I will try the IIS configuration.
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OXDxAt6%23FHA.328@.TK2MSFTNGP14.phx.gbl...
>> What I do is have a very simple report that auto-refreshes every 5
>> minutes. That keeps it alive. There is also an IIS configuration that can
>> be set but I haven't used it and I don't remember it off the top of my
>> head. The auto-refresh is pretty easy hack though.
>> Instead of 5 minutes you could set it longer than than (30 minutes?).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Aki Nomura" <anomura@.jtb.com> wrote in message
>> news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>>I tried both SQL2000 & SQL2005.
>> But both servers RS processes sleep if no users access to them over an
>> hour.
>> Once it sleeps, the user has to wait 20 seconds to start responding the
>> request.
>> Is this normal? Is there anyway to prevent this waiting time?
>> Please help!!
>>
>>
>|||Yes, it works.
Thanks again.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:egpp%23KE$FHA.2036@.TK2MSFTNGP14.phx.gbl...
> Layout, report tab, autorefreshes checkbox. Once you have a report that
> autorefreshes then open it and leave it up. This has worked for me both
> with RS 2000 and RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Aki Nomura" <anomura@.jtb.com> wrote in message
> news:OzI$fDD$FHA.504@.TK2MSFTNGP09.phx.gbl...
>> Auto-refreshes means scheduling report?
>> Actually I tried an every 3 minutes schedule report.
>> But it didn't work for my case.
>> Anyway, I will try the IIS configuration.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:OXDxAt6%23FHA.328@.TK2MSFTNGP14.phx.gbl...
>> What I do is have a very simple report that auto-refreshes every 5
>> minutes. That keeps it alive. There is also an IIS configuration that
>> can be set but I haven't used it and I don't remember it off the top of
>> my head. The auto-refresh is pretty easy hack though.
>> Instead of 5 minutes you could set it longer than than (30 minutes?).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Aki Nomura" <anomura@.jtb.com> wrote in message
>> news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>>I tried both SQL2000 & SQL2005.
>> But both servers RS processes sleep if no users access to them over an
>> hour.
>> Once it sleeps, the user has to wait 20 seconds to start responding the
>> request.
>> Is this normal? Is there anyway to prevent this waiting time?
>> Please help!!
>>
>>
>>
>|||That is called Application Pool in IIS. Go to IIS Manager, under Applocation
Pools node, right click "DefaultAppPool" in which the Reporting Server work
process is running, select properties. On "Performace" tag, you will see, by
default, the app pool will shut down if being idle for 20 min. You can
extend this time to 8x60min 480min, so that the app pool will not shut down
for a regular working day. However, the first report reader of the day, will
hit the delay. You may schedule a dummy report at beginning of a work day
for this.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OXDxAt6%23FHA.328@.TK2MSFTNGP14.phx.gbl...
> What I do is have a very simple report that auto-refreshes every 5
> minutes. That keeps it alive. There is also an IIS configuration that can
> be set but I haven't used it and I don't remember it off the top of my
> head. The auto-refresh is pretty easy hack though.
> Instead of 5 minutes you could set it longer than than (30 minutes?).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Aki Nomura" <anomura@.jtb.com> wrote in message
> news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>>I tried both SQL2000 & SQL2005.
>> But both servers RS processes sleep if no users access to them over an
>> hour.
>> Once it sleeps, the user has to wait 20 seconds to start responding the
>> request.
>> Is this normal? Is there anyway to prevent this waiting time?
>> Please help!!
>>
>|||Wow, This is what I was looking for.
Thank you.
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:uSWtdkQ$FHA.532@.TK2MSFTNGP15.phx.gbl...
> That is called Application Pool in IIS. Go to IIS Manager, under
> Applocation Pools node, right click "DefaultAppPool" in which the
> Reporting Server work process is running, select properties. On
> "Performace" tag, you will see, by default, the app pool will shut down if
> being idle for 20 min. You can extend this time to 8x60min 480min, so that
> the app pool will not shut down for a regular working day. However, the
> first report reader of the day, will hit the delay. You may schedule a
> dummy report at beginning of a work day for this.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OXDxAt6%23FHA.328@.TK2MSFTNGP14.phx.gbl...
>> What I do is have a very simple report that auto-refreshes every 5
>> minutes. That keeps it alive. There is also an IIS configuration that can
>> be set but I haven't used it and I don't remember it off the top of my
>> head. The auto-refresh is pretty easy hack though.
>> Instead of 5 minutes you could set it longer than than (30 minutes?).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Aki Nomura" <anomura@.jtb.com> wrote in message
>> news:%23TPmKK1%23FHA.3104@.TK2MSFTNGP15.phx.gbl...
>>I tried both SQL2000 & SQL2005.
>> But both servers RS processes sleep if no users access to them over an
>> hour.
>> Once it sleeps, the user has to wait 20 seconds to start responding the
>> request.
>> Is this normal? Is there anyway to prevent this waiting time?
>> Please help!!
>>
>>
>

Does report support this parameters: ...&rs:Format=HTML4.0&rc:Parameters=false&ChainID:isN

hi,
I am working on some report page which will be access via URL.
And I found some old reports URL look like this:
...&rs:Format=HTML4.0&rc:Parameters=false&UserID:isNull=True...
What does the UserID:IsNull=True means? Is this right format for
SSRS2005?
ThanksIt means you have a parameter defined for your report called UserID and
you're setting its value to null via the URL.
Andy Potter|||Oh, ic, Thanks

Does report support this parameters: ...&rs:Format=HTML4.0&rc:Parameters=false&Chain

hi,
I am working on some report page which will be access via URL.
And I found some old reports URL look like this:
....&rs:Format=HTML4.0&rc:Parameters=false&UserID:isNull=True....

What does the UserID:IsNull=True means? Is this right format for SSRS2005?

Thanks

The UserID:IsNull=True notation is special syntax that allows you to pass null values as report parameters. In this case, you're passing null to the UserID parameter. For more info, see Books Online here:

http://msdn2.microsoft.com/en-us/library/ms155391.aspx

Here's all the info about URL access with Reporting Services:

http://msdn2.microsoft.com/en-us/library/ms153586(en-us,SQL.90).aspx

Best,
Chris

Does not have access to the Analysis Services Project1 database

I am trying to deploye but I have a mistake

TITLE: Microsoft SQL Server 2005 Analysis Services

Either the user, myCompter\Administrator, does not have access to the Analysis Services Project1 database, or the database does not exist.

Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty. 0 0

Did you figure it out. I am faced with the same issue.

Please help.

Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...
> Newbie thing here. When you get the message (maybe not verbatim) "SQL
Server
> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name
(Server
> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>

Does not exist or access denied

Newbie thing here. When you get the message (maybe not verbatim) "SQL Server
does not exist or access denied", is there a way to tell which one it is?
Problem is, client may type in the server name wrong, or may have wrong
password. It'd be nice to know if they had the correct instance name (Server
does not exist) or the wrong credentials (access denied).
Can I differentiate between the two?
TIA,
MikeMike,
That one means the machine was not found by that name.
If it was a login failure, you'd get "Login failed for user '%ls'"
%ls will be substituted by the login you supplied.
James Hokes
"Mike Hildner" <mhildner@.afweb.com> wrote in message
news:e7ZtDK01DHA.4060@.TK2MSFTNGP11.phx.gbl...

quote:

---

> Newbie thing here. When you get the message (maybe not verbatim) "SQL

---

Server

quote:

---

> does not exist or access denied", is there a way to tell which one it is?
> Problem is, client may type in the server name wrong, or may have wrong
> password. It'd be nice to know if they had the correct instance name

---

(Server

quote:

---

> does not exist) or the wrong credentials (access denied).
> Can I differentiate between the two?
> TIA,
> Mike
>

---

Does MS Access installation is required for running application that uses Access mdb file

Hi,

I am developing an application that uses Access database (mdb file) to store the user data. The user of this application is not interested in the database file (to view in MS Access Environment). Does the user machine requires MS Access installation to run my application or just some couple of dlls (OleDB driver, Access DB Engine,..) should be enough to run my application?

Thanks,

Rao

No, they don't need Access. They will simply need to have MDAC installed, and chances are it will already be there. If not get it here

http://msdn.microsoft.com/data/ref/mdac/

|||

The Information is helpful.

Thanks

Does Linked Server for MS Access support transaction?

Dear all,

We have connected a Access to a MS SQL Server 2005 as a Linked Server with the followoing settings:

1) Provider: Microsoft Jet 4.0 OLE DB Provider

2) Product Name: Access

3) Data source: X:\XXXXX.mdb

4) Provider string: ;pwd=YYYYYY;

5) Collation Compatible: False

6) Data Access: True

7) Rpc: False

8) Rpc Out: False

9) Use Remote Collation: True

10) Collation Name:

11) Connection Timeout: 0

12) Query Timeout: 0

We found that when cannot have any insert/update/delete statement for this linked server if transaction is began. Otherwise, we will have the following exception.

============

Msg 7390, Level 16, State 2, Line 1
The requested operation could not be performed because OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ZZZZZZ" does not support the required transaction interface.

===========

We wonder whether the problem is because Access does not support distributed transaction. If so, do you know any workaround will work for us?

Thanks and regards,
William

Hi William,

I have come across your post related to Transaction Interface. Now i had a similar problem while connectiong the the Paradox database using linked server. Can you please suggest me on this Please. Thanks in advance.

Rakesh

|||

You can use pass-through openquery().

e.g.

update openquery(your_access_linkedserver,'select * from tb')

set col1 = 123

...

|||

Access does not provide any transactional support. No Rollbacks or Commits. Period.

Other than eliminating Access, or resort to not making transaction calls in ANY transaction involving Access, I can think of no workaround.

Does Linked Server for MS Access support transaction?

Dear all,

We have connected a Access to a MS SQL Server 2005 as a Linked Server with the followoing settings:

1) Provider: Microsoft Jet 4.0 OLE DB Provider

2) Product Name: Access

3) Data source: X:\XXXXX.mdb

4) Provider string: ;pwd=YYYYYY;

5) Collation Compatible: False

6) Data Access: True

7) Rpc: False

8) Rpc Out: False

9) Use Remote Collation: True

10) Collation Name:

11) Connection Timeout: 0

12) Query Timeout: 0

We found that when cannot have any insert/update/delete statement for this linked server if transaction is began. Otherwise, we will have the following exception.

============

Msg 7390, Level 16, State 2, Line 1
The requested operation could not be performed because OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ZZZZZZ" does not support the required transaction interface.

===========

We wonder whether the problem is because Access does not support distributed transaction. If so, do you know any workaround will work for us?

Thanks and regards,
William

Hi William,

I have come across your post related to Transaction Interface. Now i had a similar problem while connectiong the the Paradox database using linked server. Can you please suggest me on this Please. Thanks in advance.

Rakesh

|||

You can use pass-through openquery().

e.g.

update openquery(your_access_linkedserver,'select * from tb')

set col1 = 123

...

|||

Access does not provide any transactional support. No Rollbacks or Commits. Period.

Other than eliminating Access, or resort to not making transaction calls in ANY transaction involving Access, I can think of no workaround.

Does Linked Server for MS Access support transaction?

Dear all,

We have connected a Access to a MS SQL Server 2005 as a Linked Server with the followoing settings:

1) Provider: Microsoft Jet 4.0 OLE DB Provider

2) Product Name: Access

3) Data source: X:\XXXXX.mdb

4) Provider string: ;pwd=YYYYYY;

5) Collation Compatible: False

6) Data Access: True

7) Rpc: False

8) Rpc Out: False

9) Use Remote Collation: True

10) Collation Name:

11) Connection Timeout: 0

12) Query Timeout: 0

We found that when cannot have any insert/update/delete statement for this linked server if transaction is began. Otherwise, we will have the following exception.

============

Msg 7390, Level 16, State 2, Line 1
The requested operation could not be performed because OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "ZZZZZZ" does not support the required transaction interface.

===========

We wonder whether the problem is because Access does not support distributed transaction. If so, do you know any workaround will work for us?

Thanks and regards,
William

Hi William,

I have come across your post related to Transaction Interface. Now i had a similar problem while connectiong the the Paradox database using linked server. Can you please suggest me on this Please. Thanks in advance.

Rakesh

|||

You can use pass-through openquery().

e.g.

update openquery(your_access_linkedserver,'select * from tb')

set col1 = 123

...

|||

Access does not provide any transactional support. No Rollbacks or Commits. Period.

Other than eliminating Access, or resort to not making transaction calls in ANY transaction involving Access, I can think of no workaround.

Does have as protecting the data of a bank SQL-SERVER?

Does have as protecting the data of a bank SQL-SERVER?
-no, because if the user has access to the files ' * .mdf ', he will simply
be able to enclose them in a server where the user ' sa' doesn't have
password and ready, will have access to the data.
does Sql_Server have safety?
-has, inside of the server of your company, because there ' Administrador'
can protect the accesses and the files, but if somebody has access the this
machine (server), this everything finish (for the safety);
After this chat, was I thinking (?), because it will be then that cannot use
MSACCESS for the database (due to safety), since Sql_server leaves me in the
same position.
I hope sincerely, the result of this chat, be not 100% correct!, because it
reduces like this my deception in relation to the " ALL POWERFUL * "
Sql-Server.Assuming the situation of a bank,
- physical security is just as important as application security. You
should already take the appropriate steps to protect your server physically.
- I do not think you can ever fit a bank's entire database into a removable
storage device for you to attach to another server (which would need just as
large a storage device as the source server)
Do tell, which mainstream database server protects its data files? At the
minimum, you would need to encrypt the contents lest you use a hex editor to
view the data directly, and encryption eats up cpu cycles.
--
Regards
Ray Mond
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:e994$ARHEHA.3128@.TK2MSFTNGP12.phx.gbl...
> Does have as protecting the data of a bank SQL-SERVER?
> -no, because if the user has access to the files ' * .mdf ', he will
simply
> be able to enclose them in a server where the user ' sa' doesn't have
> password and ready, will have access to the data.
> does Sql_Server have safety?
> -has, inside of the server of your company, because there ' Administrador'
> can protect the accesses and the files, but if somebody has access the
this
> machine (server), this everything finish (for the safety);
>
> After this chat, was I thinking (?), because it will be then that cannot
use
> MSACCESS for the database (due to safety), since Sql_server leaves me in
the
> same position.
> I hope sincerely, the result of this chat, be not 100% correct!, because
it
> reduces like this my deception in relation to the " ALL POWERFUL * "
> Sql-Server.
>
>

Does have as protecting the data of a bank SQL-SERVER?

Does have as protecting the data of a bank SQL-SERVER?
-no, because if the user has access to the files ' * .mdf ', he will simply
be able to enclose them in a server where the user ' sa' doesn't have
password and ready, will have access to the data.
does Sql_Server have safety?
-has, inside of the server of your company, because there ' Administrador'
can protect the accesses and the files, but if somebody has access the this
machine (server), this everything finish (for the safety);
After this chat, was I thinking (?), because it will be then that cannot use
MSACCESS for the database (due to safety), since Sql_server leaves me in the
same position.
I hope sincerely, the result of this chat, be not 100% correct!, because it
reduces like this my deception in relation to the " ALL POWERFUL * "
Sql-Server.
Assuming the situation of a bank,
- physical security is just as important as application security. You
should already take the appropriate steps to protect your server physically.
- I do not think you can ever fit a bank's entire database into a removable
storage device for you to attach to another server (which would need just as
large a storage device as the source server)
Do tell, which mainstream database server protects its data files? At the
minimum, you would need to encrypt the contents lest you use a hex editor to
view the data directly, and encryption eats up cpu cycles.
Regards
Ray Mond
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:e994$ARHEHA.3128@.TK2MSFTNGP12.phx.gbl...
> Does have as protecting the data of a bank SQL-SERVER?
> -no, because if the user has access to the files ' * .mdf ', he will
simply
> be able to enclose them in a server where the user ' sa' doesn't have
> password and ready, will have access to the data.
> does Sql_Server have safety?
> -has, inside of the server of your company, because there ' Administrador'
> can protect the accesses and the files, but if somebody has access the
this
> machine (server), this everything finish (for the safety);
>
> After this chat, was I thinking (?), because it will be then that cannot
use
> MSACCESS for the database (due to safety), since Sql_server leaves me in
the
> same position.
> I hope sincerely, the result of this chat, be not 100% correct!, because
it
> reduces like this my deception in relation to the " ALL POWERFUL * "
> Sql-Server.
>
>

Does have as protecting the data of a bank SQL-SERVER?

Does have as protecting the data of a bank SQL-SERVER?
-no, because if the user has access to the files ' * .mdf ', he will simply
be able to enclose them in a server where the user ' sa' doesn't have
password and ready, will have access to the data.
does Sql_Server have safety?
-has, inside of the server of your company, because there ' Administrador'
can protect the accesses and the files, but if somebody has access the this
machine (server), this everything finish (for the safety);
After this chat, was I thinking (?), because it will be then that cannot use
MSACCESS for the database (due to safety), since Sql_server leaves me in the
same position.
I hope sincerely, the result of this chat, be not 100% correct!, because it
reduces like this my deception in relation to the " ALL POWERFUL * "
Sql-Server.Assuming the situation of a bank,
- physical security is just as important as application security. You
should already take the appropriate steps to protect your server physically.
- I do not think you can ever fit a bank's entire database into a removable
storage device for you to attach to another server (which would need just as
large a storage device as the source server)
Do tell, which mainstream database server protects its data files? At the
minimum, you would need to encrypt the contents lest you use a hex editor to
view the data directly, and encryption eats up cpu cycles.
Regards
Ray Mond
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:e994$ARHEHA.3128@.TK2MSFTNGP12.phx.gbl...
> Does have as protecting the data of a bank SQL-SERVER?
> -no, because if the user has access to the files ' * .mdf ', he will
simply
> be able to enclose them in a server where the user ' sa' doesn't have
> password and ready, will have access to the data.
> does Sql_Server have safety?
> -has, inside of the server of your company, because there ' Administrador'
> can protect the accesses and the files, but if somebody has access the
this
> machine (server), this everything finish (for the safety);
>
> After this chat, was I thinking (?), because it will be then that cannot
use
> MSACCESS for the database (due to safety), since Sql_server leaves me in
the
> same position.
> I hope sincerely, the result of this chat, be not 100% correct!, because
it
> reduces like this my deception in relation to the " ALL POWERFUL * "
> Sql-Server.
>
>

Does format file for bulk insert allow mix of native and character format?

I tried to place this question to the .Net framework Data Access and Storage forum and got no answer, so I am trying to move it on this forum.

So I have a module which require me to import big amount of data. I believe that the native format data files with format files will be the most efficient way of implementation. I am trying to programmatically produce a BCP like exported files of native format(it means without type conversion) from tables with nullable and nonnullable values.I prefere to be able to not produce computed or identity or rowguid fields,so I need format files.

I don't have problems producing different kinds of int or float( which are the majority of fields) or char or nchar fields.

Problems are emerging with the datetime or smalldatetime or decimal fields because I don't know how to convert to them from the strings or from the CLR types.

So I trying to find a way to find a native format of those fields or to find if a bulk insert will accept mixed format files with some of the fields in the native format without field terminators and some with field terminators or to use char format with field terminators only plus maybe format files.

So if the answer to above question is positive I can partially resolve the problem, if negative I will have to use the character format.

Unless you can educate me on the convertion to the SQL server internal formats of datetimes and decimals from the CLR types.

See SQL Server 2005 Books Online topics:

SQL Server Data Types and Their .NET Framework Equivalents
http://msdn2.microsoft.com/en-us/library/ms131092.aspx
Specifying File Storage Type by Using bcp
http://msdn2.microsoft.com/en-US/library/ms189110.aspx

Data Type Conversion (Database Engine)
http://msdn2.microsoft.com/en-us/library/ms191530.aspx

Does anyone know where I can connect to a test SQL box?

I recently lost my job and wanted to do some test development to keep my skills up to date. The problem is I don't have access to any data sources. Is there such a thing around? I tried installing microsoft's trial of SQL 2005 but can't get it to run on my laptop and SQL 2000 trial no longer exists. I simply need to create a SQL db/tables etc. Thanks in advance.

You probably want SQL 2005 Express.

Jeff

|||

jeff@.zina.com:

You probably want SQL 2005 Express.

Jeff

Thanks. I'll take a look at it.|||

wescosoft:

I recently lost my job and wanted to do some test development to keep my skills up to date. The problem is I don't have access to any data sources. Is there such a thing around? I tried installing microsoft's trial of SQL 2005 but can't get it to run on my laptop and SQL 2000 trial no longer exists. I simply need to create a SQL db/tables etc. Thanks in advance.

An employer will not give you Express for development so it is better to download the eval version which is good for 180 days to use for your development. The product almost self install after you choose components Hope this helps.

http://www.microsoft.com/sql/downloads/trial-software.mspx

|||Odd, my employer gave me Express for development. But we also have production, test, and staging sql servers as well.|||

Motley:

Odd, my employer gave me Express for development. But we also have production, test, and staging sql servers as well.

Most employers give personnal edition which is complete SQL Server for development. Express installs with VS, that does not mean employers give Express for development.

|||

SQL Personal Edition, SQL Desktop, and MSDE are what SQL Express is in 2005. And I've found that employers don't normally give anything, development teams and shops have different methods of development. Most that I deal with use development servers, which are full SQL Server editions that match the deployment servers.

There are limitations to SQL Express, but most shouldn't impede using it for web development.

Jeff

|||

jeff@.zina.com:

SQL Personal Edition, SQL Desktop, and MSDE are what SQL Express is in 2005. And I've found that employers don't normally give anything, development teams and shops have different methods of development. Most that I deal with use development servers, which are full SQL Server editions that match the deployment servers.

There are limitations to SQL Express, but most shouldn't impede using it for web development.

Jeff

Personnal is not MSDE so it is not Express, MSDE is Express and it is not a way to learn data driven web application development because a lot of what you need to run your application are SQL Server Agent dependent and there is no Agent in Express.

|||There is no 2005 Personal Edition, atleast not that I am aware of. Enterprise, Standard, Workgroup, Express, Developer, and I believe there is a Mobile Edition as well. You may be thinking of the Developer Edition which is similiar in fuctionality to Enterprise with some licensing restrictions.|||I did not say there is personnal in SQL Server 2005 but Express is not a replacement for personnal because it was a complete SQL Server. That is the reason I gave the user the eval version.

Does anyone know of a web based SQL Query tool?

Hi

I want to be able t give my users access to our SQL server database via a eb application published o our web server. I have found one freeware tool but it only supports SQL Server 2000 and the developer doesn't returns any emails.

Has anyone come across a web ui SQL query tool either freeware or one that can be purhcase

thanks for your help

Marcus

Do you just want to have a tool sending out a query from a textbox and getting the results back in a grid or something ? Or do you want tome graphical designer for your users ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

search for

SQL Server Web Data Administrator

on microsoft website

|||

Here is the link to SQL Server Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||ASP Enterprise Manager http://sourceforge.net/projects/asp-ent-man/