I need to know how to setup and use an ODBC connection to SQL Server
through the web.config file.
I have done a connection using OLEDB but not with ODBC. Here's what I
have with the OLEDB.
Web.Config
<add key="connectionString" value="data source=Testdb1; initial
Catalog=Test; user=tester; password=test"/>
In the code
Dim conn As SqlConnection = New
SqlConnection(ConfigurationManager.AppSettings("connectionString"))
Conn.open
I have an ODBC datasource setup already called TestDS. So how would
I setup my web.config file to use TestDS and what would my code look
like to open it.
Thanks
Ray Costanzo - 20 Mar 2008 17:06 GMT
Why on earth are you using ODBC? Is this on a Windows for Workgroups
machine or something?
Check out this site: http://www.connectionstrings.com/
Ray Costanzo
>I need to know how to setup and use an ODBC connection to SQL Server
> through the web.config file.
[quoted text clipped - 15 lines]
>
> Thanks
Mark Rae [MVP] - 20 Mar 2008 20:47 GMT
> I need to know how to setup and use an ODBC connection to SQL Server
> through the web.config file.
ODBC to SQL Server...??? Is there any reason why you can't use the native
.NET data provider...?

Signature
Mark Rae
ASP.NET MVP
http://www.markrae.net