Connectivity Kit Enhancement from 2.5x to 2.6

ID: Q125045

2.5x 2.6x 3.00 WINDOWS kbtool kbprg kbprb

The information in this article applies to:

SUMMARY

When you log on to a server using the FoxPro 2.5x Connectivity Kit (CK), the information in the Database Name section of the Open Database Connectivity (ODBC) manager is ignored and FoxPro automatically uses the database assigned to the user by the Server Administrator.

MORE INFORMATION

The Master Database is the default database for a Structured Query Language (SQL) Server System Administrator. If the System Administrator used the CK to connect to a SQL Server Database and tried to view data without explicitly opening a database through the CK, the retrieved data comes from the Master Database. This happens in spite the fact that another database was specified in the ODBC Manager.

This behavior was by design in the 2.5x CK, but has been enhanced in the 2.6x and 3.00 Connectivity Kits. The information provided by the user in the Database Name section of the ODBC Manager is used and is no longer ignored.

Note: If the 2.5x version of FPSQL.FLL is installed with later versions of FoxPro for Windows, this same problem occurs.

Additional reference words: VFoxWin 3.00 2.50 2.50a 2.50b 2.60 2.60a FoxWin KBCategory: kbtool kbprg kbprb KBSubcategory: FxtoolCk

Keywords          : FxtoolCk 
Version           : 2.5x 2.6x 3.00
Platform          : WINDOWS

Last Reviewed: May 1, 1996