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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy