• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 903
  • Last Modified:

error 08S01 - link failure

I am using foxpro 2.6b for windows conected to sql server 7.0 with odbc 16 bits . Sometimes I receive the error message: error 08S01 - Communication link failure
I think that the problem is with my ODBC 16 bits Driver !
0
soares
Asked:
soares
1 Solution
 
Jon_RaymondCommented:
0
 
shirazcCommented:
Check the following:
1. SQL Server has sp5a
2. Update MDAC from following
link http://www.microsoft.com/data/

3. check SQL Client Config for mathcing protocol at client and server end.


regards

Shiraz
0
 
soaresAuthor Commented:
The latest version of MDAC is only for 32 bits odbc driver.

I installed 16 bits ODBC driver from Access 2.0 , but my foxpro application showed this error: odbc error 2 : invalid FPSQL connection handle , only when I try to connect to MS SQL Server 7.0 . I connect the same aplication to Sybase SQL Server 10 with the same ODBC driver without any problem

0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now