Scott,

Looks like the driver you had is in MDAC 2.5 SP 1.

See http://www.microsoft.com/data/MDAC25info/MDAC25SP1Manifest.htm

Perhaps someone else can help you with the problem of how to get the old drivers and the new ones on the machine at the same time.



>Thank you for the response...
>Is it safe?
>
>ODBC isn't something that you uninstal .. and it is a production sql server
>
>Please comment.
>
>thx Scott
>
>>Try to install MDAC 2.6 SP1 from http://www.microsoft.com/data/download.htm#26sp1info
>>It has ODBC driver version 2000.80.380.0, Sep 2000
>>
>>>Hi there.
>>>
>>>I have now updated my pc to VFP7. But now I cannot access a client's SQL server (sql6.5) using my odbc.
>>>
>>>Access to it was working fine previous to the install of VFP ... which seems to have updated my ODBC..
>>>
>>>Here are the odbc version numbers from before and after the VFP7 install...on my pc ...
>>>
>>>About\Administrator: Old - 3.520.4403.2 New - 3.520.6526.0
>>>Drivers\SQL Server: Old - 3.70.08.20 New - 2000.80.194.00
>>>
>>>Now when I try to connect odbc (control panel) to the sql server ... I just timeout. And on the sql server there is an event that indicates that it cannot read the login packets.
>>>
>>>My ODBC connection to the sql server is configured to use TCPIP.
>>>
>>>Interestingly enough, this particular server has multiprotocol installed, and if I change my pc to use multiprotocol ... I can access that server.
>>>
>>>I need to use TCPIP as not all servers have Multiprotocol installed.
>>>
>>>Can someone with more experience in this area please explain to me what is wrong and how I can correct this situation?
>>>
>>>TIA, Scott Barker