VB.Net, Using ODBC Data Sources in Connection String

Using ODBC Data Sources in Connection String

Author	Message
Doug Hathawa #1 / 3	Using ODBC Data Sources in Connection String How can I make VB.Net recognize the ODBC Data Source Name I have created for my SQL 2000 databases? I need to have a user db on each machine and a master DB on the server. Crystal Reports allows me to refer to the Data Source naem in design, and it finds the data OK. Now, as a final step before deployment, I need to be able to do the same for the VB code. I've searched counless books and MS documents, but now luck. Anya nd all suggestions are appreciated. Thanks in advance. Doug
Fri, 29 Jul 2005 02:26:24 GMT

Richard T. Edward #2 / 3	Using ODBC Data Sources in Connection String MyCn = "DSN=NAMEOFDSN;UID=;PWD=;" or MyCn = "Provider=MSDASQL;Driver=SQL Server;Server=nameofyourserver;Database=nameofyourdatabsae;UID=;pwd=;" hth Quote: > How can I make VB.Net recognize the ODBC Data Source Name > I have created for my SQL 2000 databases? I need to have > a user db on each machine and a master DB on the server. > Crystal Reports allows me to refer to the Data Source naem > in design, and it finds the data OK. Now, as a final step > before deployment, I need to be able to do the same for > the VB code. I've searched counless books and MS > documents, but now luck. Anya nd all suggestions are > appreciated. Thanks in advance. Doug
Fri, 29 Jul 2005 05:57:34 GMT

Doug Hathawa #3 / 3	Using ODBC Data Sources in Connection String Thanks alot -- I'll give it a try tomorrow * Sent via Developersdex http://www.developersdex.com * Don't just participate in USENET...get rewarded for it!
Sat, 30 Jul 2005 09:51:50 GMT

Page 1 of 1

[ 3 post ]