sqlConnection not working in VS.net IDE

[J. Muenchbourg]

Inside VS.net, I'm using the Data Form wizard to creat a DataSet and a
Data Connection to my sql database on my network. VS.net creates this
code after I point it to the correct database:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=xx;Initial Catalog=Northwind;Data
Source=TAURUSSQL;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=PROG1;Use Encryption for Data=False;Tag with
column collation when possible=False

...but after i finish the data form and try to bring up records when i
run the project, i get a prompt/error: "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection." ..when the
same userid has no problem on my other sql connection scripts. I even
tried inserting the password in the above string and i still get the
same exact error.

muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mary Chipman]

Take the user id and password out of the connection string if you're
using integrated security.

--Mary

On Tue, 13 Apr 2004 13:48:52 -0700, J. Muenchbourg <an*******@dex.com>
wrote:

Inside VS.net, I'm using the Data Form wizard to creat a DataSet and a
Data Connection to my sql database on my network. VS.net creates this
code after I point it to the correct database:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=xx;Initial Catalog=Northwind;Data
Source=TAURUSSQL;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=PROG1;Use Encryption for Data=False;Tag with
column collation when possible=False

..but after i finish the data form and try to bring up records when i
run the project, i get a prompt/error: "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection." ..when the
same userid has no problem on my other sql connection scripts. I even
tried inserting the password in the above string and i still get the
same exact error.

muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mary Chipman]

Take the user id and password out of the connection string if you're
using integrated security.

--Mary

On Tue, 13 Apr 2004 13:48:52 -0700, J. Muenchbourg <an*******@dex.com>
wrote:

Inside VS.net, I'm using the Data Form wizard to creat a DataSet and a
Data Connection to my sql database on my network. VS.net creates this
code after I point it to the correct database:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;User ID=xx;Initial Catalog=Northwind;Data
Source=TAURUSSQL;Use Procedure for Prepare=1;Auto Translate=True;Packet
Size=4096;Workstation ID=PROG1;Use Encryption for Data=False;Tag with
column collation when possible=False

..but after i finish the data form and try to bring up records when i
run the project, i get a prompt/error: "Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection." ..when the
same userid has no problem on my other sql connection scripts. I even
tried inserting the password in the above string and i still get the
same exact error.

muench

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[J. Muenchbourg]

Thanks Mary for reply. Yes, I started a new connection and made it
Windows Integrated Security, without a User or password designation, and
it still gave me the same error

???????????

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[J. Muenchbourg]

Thanks Mary for reply. Yes, I started a new connection and made it
Windows Integrated Security, without a User or password designation, and
it still gave me the same error

???????????

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mary Chipman]

Have you set up a connection in the Server Explorer using these
credentials? That may be a good way to troubleshoot this thing. Null
user means the server is not seeing a valid user.

--Mary

On Wed, 14 Apr 2004 14:52:23 -0700, J. Muenchbourg <an*******@dex.com>
wrote:

Thanks Mary for reply. Yes, I started a new connection and made it
Windows Integrated Security, without a User or password designation, and
it still gave me the same error

???????????

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mary Chipman]

Have you set up a connection in the Server Explorer using these
credentials? That may be a good way to troubleshoot this thing. Null
user means the server is not seeing a valid user.

--Mary

On Wed, 14 Apr 2004 14:52:23 -0700, J. Muenchbourg <an*******@dex.com>
wrote:

Thanks Mary for reply. Yes, I started a new connection and made it
Windows Integrated Security, without a User or password designation, and
it still gave me the same error

???????????

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!