I developed a project in VB.net with SQL Server as the backend using ODBC Data source. I converted the DB to SQL Server 2005 and tried to change the ODBC Data source connection with a SQL Server native client. The ODBC USER DSN connection is not obtaining the SQL Server 2005 database I created. How do I solve this problem?
Software/Hardware used:
ASKED:
April 8, 2010 4:00 PM
UPDATED:
January 20, 2012 4:11 AM
Why are you connectint via ODBC ?
You could use the classes from the SqlClient namespace to connect directly to the SQL Server database.