Microsoft KB Archive/115992

{|
 * width="100%"|

-

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 query words: FoxDos ck dblibrary errmsg err msg

Keywords         : Version          : Platform         : Issue type       :
 * }