How to update ODBC driver for SQL 2000 (none database)?

[amira1344]

Hi Guys,
i have a windows 2000 server (lets name it X) with SQL 2000 ODBC driver which am experiencing problem accessing SQL server database on another server (lets take it as Y).
The test connection is successfull when i try it from my desktop to Y server but when i try it from that X to Y server no luck.
What i noticed was the the SQL ODBC driver version differences.
The SQL ODBC driver version on my PC is 2000.85.1117.00 where the version on X server is 3.70.11.46.
Anybody has any idea how to upgrade this driver?
By the way, is this some thing to do with MDAC? If i install MDAC 2.8 (Microsoft Data Access Component) will resolve my problem.
X= Win 2k SP4
Y= SQL server 2000

Thanks for your input.

[Jerry Winston]

I'm feeling lucky so I'll guess you're using windows authentication. The connection fails because X doesn't have login credentials on Y the same way you have login credentials Y. Either enable SQL authentication and add a login specifically for this connection or add login credentials for X on Y through computer management.

If I didn't guess the solution right off let's do this methodically. There's a lot of connectivity software layers here. Let's start at the bottom.

• Can you ping X from Y?
• Can you ping Y from X?
• Can you connect with DN?
• Can you connect with IP #?
• What kind of authentication (Win/SQL) are you using to connect?

Can you provide some additional information:

• Server X OS + SP's
• Server Y OS + SP's
• Server X SQL 2000 Edition + version # + SP's
• Server Y SQL 2000 Edition + version # + SP's
• MDAC Checker Report from X
• MDAC Checker Report from Y
• MDAC Checker Report from your computer

MDAC Checker link

[amira1344]

Hi Jerry,
thanks for your reply however, there is no connection problem as I can connect it from my PC with the same DSN account.
To answere your first question, no I do not connect through windows authentication but SQL authentication. I also made the X local admin to Y where the SQL DB is residing.
I can ping X from Y no problem.
I can ping Y from X no problem.
I can connect with DN from my PC no problem.
I can connect with IP from my PC no problem.

X server = There is no SQL server on X but only tries to connect to Y through SQL ODBC driver. This server though is win 2000 SP 4. SQL ODBC version: 3.70.11.46

Y server = Win 2003 SP2. MS SQL server 2000 version 8.0

How do I run MDAC Checker Report?
Can I run MDAC report on X where I don't have SQL DB?

[Jerry Winston]

Yes, you can run the MDAC checker report on a server X by downloading running the executable.

Ok. Let's check SQL Server SP's next.

• What's the highest SQL SP applied to SQL 2000 Server on Y?
• What error is the ODBC driver throwing?

I'm asking all this because I'm trying to coordinate your software versions with the right MDAC version(s).

[amira1344]

Highest SP on Y: MS 2000 - 8.00.2055 (Intel X86).
I am getting connection error when I try to create connection from X to Y.