question

jlint3024 avatar image
jlint3024 asked

SQL 2000 -> SQL 2008 connection

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 3.70.11.46 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).
sql-server-2008odbcconnection-string
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image David Wimbush commented ·
Here's the place to go for connection strings: http://www.connectionstrings.com/
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.