PRB: DB-Library Error 10004: Unable to Connect...

• Microsoft FoxPro for MS-DOS, versions 2.5, 2.5a, 2.5b
• Microsoft FoxPro Connectivity Kit, version 2.5

SYMPTOMS

When you are trying to connect to a server in FoxPro for MS-DOS using the FoxPro Connectivity Kit, the following error message appears:

DB-Library error 10004: Unable to connect:SQL Server is unavailable or does not exist.

CAUSE

You have specified an invalid server name. For example, if there is not a server called TEST, the following code will cause the error to occur:

   errmsg=""
   errval=""
   handle=DBConnect("TEST","sa","")
   =DBError(0,@errmsg,@errval)
   ?errmsg
   ?errval 

RESOLUTION

Change the first parameter in the DBConnect() function from "TEST" to a valid SQL Server machine name.

Additional query words: FoxDos ck dblibrary errmsg err msg

Keywords          : 
Version           : 
Platform          : 
Issue type        :