PRB: SQL Server Error 911: Invalid Database Name

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

SYMPTOMS

When you are trying to connect to a server in FoxPro for MS-DOS using the Connectivity Kit, the error below is received:

   SQL Server error 911: Invalid database name

CAUSE

The DBConnect() documentation on page 32 of the FoxPro Connectivity Kit "User's Guide" says the following:

   In FoxPro for MS-DOS, specify a database name on SQL Server with
   <expC4>.

   DBConnect(<expC1>,<expC2>,<expC3>,<expC4>)

   <expC1>  Data source name
   <expC2>  User Identifier
   <expC3>  Password
   <expC4>  Database name (in FoxPro for MS-DOS only)

For example, the code below will cause the error to occur because the database named "JUNK" does not exist. REDDFOXX is a valid server name, sa is a valid user name, and "" is a valid password.

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

RESOLUTION

Change the fourth parameter in the DBConnect() function to a valid database name.