Re: unable to connect to sql 6.5

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)" wrote:

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" <foxh@xxxxxxxx> wrote in message
news:487E25D5.841C125C@xxxxxxxxxxx
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 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)
____________________________________________________________________________________________


.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: DCOM Error - Event 10009
    ... using SQL Server Management Studio 2005. ... Whenever we first launch SQL ... when connecting to a different registered server, it will hang again for 5 - ... I have checked DCOM Config using dcomcnfg, ...
    (microsoft.public.sqlserver.clients)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Heres a weird one for all of you...
    ... SQL: SQL 2005 Demo ... SQL 2005 Processor Licensed (connecting via port 14330) ... Additional Major S/W on that server: ... logs showed was an operation timeout error, ...
    (microsoft.public.sqlserver.connect)
Loading