FAQ: ODBC Connection String changes for SQL 2005

If you are getting errors connecting to the database from your code.

If your ODBC connection string looks somthing like this:

sConn = "driver={SQL Server};server=MYDATABASESERVER;uid=MyUserName;pwd=MyPassword;database=MyDataBase"

Try to changing it to the SQL Native Client for SQL 2008

sConn = "driver={SQL Native Client};server=MYDATABASESERVER;uid=MyUserName;pwd=MyPassword;database=MyDataBase"

  • 90 Users Found This Useful
Was this answer helpful?

Related Articles

FAQ: Why is the design feature greyed out in Enterprise Manager?

The reason why you would not be able to use the design feature (greyed out), is because some...

FAQ: My database transaction log is too large

If your database is getting too large, it is most likely because of the transaction log file.If...

FAQ: What can I use to connect to my MS-SQL database?

You can use any third party MS-SQL client like:-SQL Server Management Studio express (microsoft...

PRB: Cannot connect to SQL 2008 or 2012 using Enterprise Manager

Enterprise Manager is not compatible with SQL 2008 or 2012 and will therefore not allow you to...