Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC version problem???
Message
 
 
To
17/09/2001 13:05:42
Scott Barker
Barker Systems Consulting Ltd.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00557359
Message ID:
00557587
Views:
11
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform