|
 |
asp_web_howto thread: Invalid connection string attribute
Message #1 by dirosky@h... on Mon, 11 Nov 2002 13:21:11
|
|
My connection string to MSDE:
"Provider=SQLOLEDB;Persistent Security Info=False;" & _
"User ID=sa;Initial Catalaog=UserdataSQL;"& _
"Initial File Name:C:\Program Files\Microsoft SQL
Server\MSSQL\Data\userdatasql.mdf"
I cannot figure out what I am doing wrong? Any ideas?
Message #2 by Tom Achtenberg <toma@f...> on Mon, 11 Nov 2002 07:08:20 -0700
|
|
I do not see a "Data Source=servername" attribute for the server the database "UserDataSQL" is on. (I'm
assuming that that is the name of a database on a SQL Server. I have also never needed or used an "Initial File" attribute.
-----Original Message-----
From: dirosky@h... [mailto:dirosky@h...]
Sent: Monday, November 11, 2002 6:21 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Invalid connection string attribute
My connection string to MSDE:
"Provider=SQLOLEDB;Persistent Security Info=False;" & _
"User ID=sa;Initial Catalaog=UserdataSQL;"& _
"Initial File Name:C:\Program Files\Microsoft SQL
Server\MSSQL\Data\userdatasql.mdf"
I cannot figure out what I am doing wrong? Any ideas?
Message #3 by "Ken Schaefer" <ken@a...> on Tue, 12 Nov 2002 12:16:05 +1100
|
|
It should be:
Persist Security Info=False
(not Persistant). Also, set a password on your sa account! :-)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <dirosky@h...>
Subject: [asp_web_howto] Invalid connection string attribute
: My connection string to MSDE:
:
: "Provider=SQLOLEDB;Persistent Security Info=False;" & _
: "User ID=sa;Initial Catalaog=UserdataSQL;"& _
: "Initial File Name:C:\Program Files\Microsoft SQL
: Server\MSSQL\Data\userdatasql.mdf"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #4 by "Ken Schaefer" <ken@a...> on Tue, 12 Nov 2002 12:18:35 +1100
|
|
Initial File=...
can be used to create a new database by add an .mdf file to the default SQL
Server instance. Requires SQL Server SysAdmin rights (I think...)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tom Achtenberg" <toma@f...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Tuesday, November 12, 2002 1:08 AM
Subject: [asp_web_howto] RE: Invalid connection string attribute
: I do not see a "Data Source=servername" attribute for the server the
database "UserDataSQL" is on. (I'm assuming that that is the name of a
database on a SQL Server. I have also never needed or used an "Initial
File" attribute.
:
: -----Original Message-----
: From: dirosky@h... [mailto:dirosky@h...]
: Sent: Monday, November 11, 2002 6:21 AM
: To: ASP Web HowTo
: Subject: [asp_web_howto] Invalid connection string attribute
:
:
: My connection string to MSDE:
:
: "Provider=SQLOLEDB;Persistent Security Info=False;" & _
: "User ID=sa;Initial Catalaog=UserdataSQL;"& _
: "Initial File Name:C:\Program Files\Microsoft SQL
: Server\MSSQL\Data\userdatasql.mdf"
:
: I cannot figure out what I am doing wrong? Any ideas?
:
:
Message #5 by "phil griffiths" <pgtips@m...> on Tue, 12 Nov 2002 10:06:52
|
|
Also its "Initial Catalog", not Catalaog. Dirosky, I think you should
give up typing connection strings :-) use a udl file to build them instead
rgds
Phil
>--------------------------------------
> It should be:
Persist Security Info=False
(not Persistant). Also, set a password on your sa account! :-)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <dirosky@h...>
Subject: [asp_web_howto] Invalid connection string attribute
: My connection string to MSDE:
:
: "Provider=SQLOLEDB;Persistent Security Info=False;" & _
: "User ID=sa;Initial Catalaog=UserdataSQL;"& _
: "Initial File Name:C:\Program Files\Microsoft SQL
: Server\MSSQL\Data\userdatasql.mdf"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #6 by dirosky@h... on Tue, 12 Nov 2002 14:49:20
|
|
Thanks all, got it!!!!!!
> It should be:
Persist Security Info=False
(not Persistant). Also, set a password on your sa account! :-)
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <dirosky@h...>
Subject: [asp_web_howto] Invalid connection string attribute
: My connection string to MSDE:
:
: "Provider=SQLOLEDB;Persistent Security Info=False;" & _
: "User ID=sa;Initial Catalaog=UserdataSQL;"& _
: "Initial File Name:C:\Program Files\Microsoft SQL
: Server\MSSQL\Data\userdatasql.mdf"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
