Re: unable to connect to sql 6.5


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" <foxh@xxxxxxxx> wrote in message news:487EB67C.7619DD0@xxxxxxxxxxx
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)
____________________________________________________________________________________________



--
__________________________________________________________________________
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: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Any help here???
    ... SQL 200 Server is not local - it's on separate server all by itself. ... trust me - all that's been done here was to install SP2 or upgrade of XP from ... I've completed the install of Visual Studio.NET like I've ...
    (microsoft.public.dotnet.framework.aspnet)