unable to connect to sql 6.5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FoxHill - 16 Jul 2008 17:46 GMT

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.

Reply to this Message

William Vaughn (MVP) - 16 Jul 2008 17:56 GMT

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.

> I've got a problem with connecting to sql 6.5.
>
[quoted text clipped - 19 lines]
>
> Thx.

Signature

__________________________________________________________________________
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)
____________________________________________________________________________________________

Reply to this Message

FoxHill - 17 Jul 2008 04:03 GMT

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?

> 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
[quoted text clipped - 36 lines]
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> ____________________________________________________________________________________________

Reply to this Message

William Vaughn (MVP) - 17 Jul 2008 17:29 GMT

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

> Thanks William
>
[quoted text clipped - 53 lines]
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> ____________________________________________________________________________________________

Signature

Reply to this Message

FoxHill - 19 Jul 2008 04:57 GMT

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?

> 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
[quoted text clipped - 70 lines]
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> ____________________________________________________________________________________________

Reply to this Message