unable to connect to sql 6.5

FoxHill

unread,

Jul 16, 2008, 12:46:13 PM7/16/08

to

I've got a problem with connecting to sql 6.5.

There's an old application running on sql 6.5 with windows 2000 server.

Some new applications running on another server (sql 2000 sp4, windows
2003 server sp1) need to connect to the sql 6.5 by Data Transformation
Service.

It was fine. However, there was an accidential reboot today. After
that, the scheduled DTS package couldn't run. From the job history it
shows that one of the steps in the package failed. The step was to draw
data from sql 6.5.

I tried to create an ODBC connection by MS OLE Data provider but still
failed. However, I could do that in other machines running Win XP or
Win server 2003 (without any sp installed).
I also tried the same action with other Win Server 2003 sp1 or sp2 and
all failed.

Does it mean that Win server 2003 sp 1 or above doesn't support sql 6.5
any more?

Thx.

William Vaughn (MVP)

unread,

Jul 16, 2008, 12:56:47 PM7/16/08

to

While I haven't tried to connect to SQL Server 6.5 in some time (a long
time) it's not the OS that would prevent connecting--it would be the
driver/data access interface. IIRC there was a point in time when the older
servers were no longer supported by the current drivers. That should not
stop you from using ODBC to get to it--assuming you have the older drivers
installed.

"FoxHill" <fo...@foxh.com> wrote in message
news:487E25D5...@foxh.com...

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

FoxHill

unread,

Jul 16, 2008, 11:03:24 PM7/16/08

to

Thanks William

I agree that the OS wouldn't prevent me from connecting to sql 6.5, but
the driver came with the new sp did.

Today I went to another office with similar set up. I got the same
result. Only win 2003 server without sp installed can connect to sql
6.5.

Actually I those server with sp installed, i also installed MDAC from
2.1 to 2.8. But it still didn't work.

Is there any work-around?

William Vaughn (MVP)

unread,

Jul 17, 2008, 12:29:55 PM7/17/08

to

This was a problem from the second version of the ODBC/DBLib drivers on. It
seems that the OS or other applications would install one part of the
driver/LAN interface pair but not the other. I expect that's what has
happened in your case. I have an idea though. Setup a VPC with Windows X (a
version that works) and access it from there. I would also plan to upgrade
the server ASAP... ;)

"FoxHill" <fo...@foxh.com> wrote in message news:487EB67C...@foxh.com...

FoxHill

unread,

Jul 18, 2008, 11:57:01 PM7/18/08

to

Hi William

For my situation, upgrading is not an option for me.

Anyway, I found out something and don't know if it can help:

1. On those 2003 servers unable to connect to sql 6.5, I checked the
network library version of TCP/IP is
"SSNETLIB.dll, 8.0.2039, 3/5/2005"

2. On those 2003 server able to connect to sql 6.5, the version info is:
"SSNETLIB.dll, 8.0.311, 5/8/2003"

I'm just wondering if there're some ways to restore the old driver.

Any idea?