Re: Using Widows Authentication and accesssing SQL with SQL Authentication

From: "Valar" <vmanickamus@xxxxxxxxx>
Date: 6 Mar 2006 15:41:29 -0800

ok.. I worked on this the problem is that I gave the provider detail
also in my connection string.

<connectionStrings>
<add name="DevDBConnection"
connectionString="Server=MyServer;database=MyDB;uid=MyUser;pwd=MyPwd;"
providerName="System.Data.SqlClient" />
</connectionStrings>
the culprit is providerName="System.Data.SqlClient"

I tried the same User Id and pwd in a UDL file, Visual studio 2005 etc
everthing worked. so I started playing around the conn.string. When I
tried without the Provide Name attribute it worked :).

Thanks for your support and reply.

.

References:
- Using Widows Authentication and accesssing SQL with SQL Authentication
  - From: Valar

Prev by Date: Re: Problem with ADO.NET and dao pia in the same project
Next by Date: Re: Could someone answer a stupid dgv question?
Previous by thread: Re: Using Widows Authentication and accesssing SQL with SQL Authentication
Next by thread: Bypass ADO
Index(es):
- Date
- Thread

Relevant Pages

Send rows from MSSQL to iSeries using SSIS having slow inserts
... I have also posted this on the ibm newserver. ... I know this might have been covered in the past, but I just started playing ... with SSIS and DTS and have just noticed this problem. ... is it a connection string problem or what. ...
(microsoft.public.data.oledb)
Re: Getting data from Access into Excel
... I've been playing around ... with the code, but I'm not hugely experienced using VBA, and it won't ... accept my connection string, ... "Invalid string in pass-through query" ...
(microsoft.public.excel.misc)