up vote 0 down vote favorite
share [g+] share [fb]

I have an application that I am migrating from SQL 2000 to 2008. This has gone mostly smoothly. The local machines running Win XP and the VB6 application are working. One machine (only one I can get to directly) runs Win Server 2003 and it works OK. However, the workstations at the remote location are running the VB6 app on Windows 2000. Those do not work.

My question is: what might be missing or out-of-date on the Win 2000 machines, if anything, that would prevent them from working with SQL Server 2008.

link|improve this question
56% accept rate
feedback

3 Answers

up vote 5 down vote accepted

Without knowing which error message(s) you're getting, or what methods you are using to connect to the SQL server I'd say your first bet is to ensure the Win 2000 machine(s) have updated Microsoft Data Access Components (MDAC) installed. You can get MDAC 2.8 SP1 from MS here.

link|improve this answer
I will get remote tech to check MDAC and update in the morning. – Jim R Jan 18 '10 at 23:16
Thanks, I did have the remote tech update MDAC as you suggest (also thanks to squillman). But the problem turned out to be that all of the workstations at the remote location had an entry in the hosts file explicitly pointing to the IP address of the legacy server and, of course I shut that down when I started the upgraded server and put in a DNS entry to redirect the old server name to the new one. Of course the hosts file entries made all that moot. – Jim R Jan 19 '10 at 18:23
Good ol' HOSTS. ;) Glad to hear you got it figured out. – techie007 Jan 19 '10 at 20:30
feedback
up vote 0 down vote

Can you give a little more information about any errors?

What are you using to connect to the server? If you're using the SQL 2008 Native Client in your app, it requires XP SP2 or newer.

System Requirements for SQL Server 2008 Native Client

Can you post your connection string?

link|improve this answer
Definately not using SQL 2008 Native Client. Using MDAC that was installed with app 10 years ago. Do not have access to machines. However, do know that machines at local installation are Win XP also using MDAC KB870669. Connection string is: Driver=SQL Server;Server=z;Database=yy;App=XXXX;UID=me;PWD=sa; With names changed to protect the innocent. – Jim R Jan 18 '10 at 23:14
Also, VB program is using ADO and MDAC – Jim R Jan 18 '10 at 23:16
Ok, then definitely start with updating MDAC like techie007 suggested. – squillman Jan 18 '10 at 23:18
feedback
up vote 0 down vote

Great.Does it also work the same way from Win 2000 32 bit client to SQL server 2008 64-bit on Windows 2008 64 bit?

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.