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

ID: Q115992

The information in this article applies to:

• 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 reference words: FoxDos 2.50 2.50a 2.50b ck dblibrary errmsg err msg KBCategory: kbprg kberrmsg kbprb KBSubcategory:

Last Reviewed: April 18, 1995