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 220.127.116.11 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).