Background ========== We are moving from SQL 2000 DB to a SQL 2008 DB. The 2008 database is a named instance listening on a port 1449, not the standard 1433. On my Desktop PC I am running XP/SP3. This has MDAC2.8 With ODBC Admin I can connect to the SQL 2008 using the SQL SERVER driver version 2000.85.1132.00 dated 14-Apr-2008. I did not load the SQL 2008 client or any drivers on my desktop. Problem ========= On our web server OS=MS2000; we have Classic ASP pages that read/write to the SQL database. The server has and unknown MDAC version; the version of the SQL SERVER driver is 18.104.22.168 dated 10/28/2003.
(A) I cannot connect to the 2008 SQL database using the ODBC manager.
(B) I cannot connect to the 2008 SQL DB using a connect string: Provider=sqloledb;Data Source=myServer\myInstance;Initial Catalog=myDB;User ID=me;Password=secret;Network Library=DBSSOCN; Questions ============ 1) Will upgrading the MDAC on the web server solve the issues ?
2) Do we need to load the SQL/2008 client on the web server?
3) If after (1 or2) Is there something wrong with the connect string (it worked OK for connecting to the SQL/2000 DB).
1) Hard to know for absolute certain, but probably, yes. You frequently will have trouble with old drivers connecting to new versions of SQL Server. I'm never surprised when it happens. 2) Yes, again, probably. 3) Not sure. I'll leave that one for someone with some code savy & some time to validate it.