February 1, 2007 at 6:56 am
Does anyone know if how to change the localsqlserver connection string to use an odbc connection? If I use the connection string that works for a gridview, I get the following error:
|
<
remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Dsn=ASPNETDB;uid=LOGIN;pwd=PASSWORD" providerName="System.Data.Odbc" />
<add name="Test" connectionString="Dsn=Test;uid=LOGIN;pwd=PASSWORD" providerName="System.Data.Odbc" />
The "Test" dataconnection works with the GridView.
February 1, 2007 at 7:38 am
try to create a UDL fiel and use the information from the UDL file to create a connectionstring
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply