INFO: Visual FoxPro ODBC Driver Connect String Attributes (167405)

The information in this article applies to:

Microsoft Visual FoxPro for Windows 5.0
Microsoft Visual FoxPro for Windows 6.0

This article was previously published under Q167405

SUMMARY

Many ODBC client applications enable the user to establish an ODBC connection without setting up an ODBC data source. The exact implementation of this varies from client to client, but it typically involves using an ODBC driver connect string.

The ODBC connect string that is used to establish the connection is specific to a given ODBC driver. The connect string generally contains the ODBC driver name and a number of driver-specific attributes.

MORE INFORMATION

The following table lists all of the Visual FoxPro ODBC driver connect string attributes:

   Attribute                 Value
   ---------                 -----
   BackgroundFetch           "Yes" or "No"

   Collate                   Any supported collating sequence

   Description               Description text

   Exclusive                 "Yes" or "No"

   SourceDB                  A fully qualified path to a directory
                             containing zero or more free tables, or the
                             absolute path and file name for a database.

   SourceType                "DBC" or "DBF"

REFERENCES

The Help file for the Visual FoxPro ODBC driver, Drvvfp.hlp, offers more information on the driver. To access this Help file, activate the ODBC Control Panel, highlight the Microsoft Visual FoxPro Driver, press the Setup button and click the Help button.

Modification Type:	Major	Last Reviewed:	10/15/2003
Keywords:	kbAutomation kbinfo kbinterop KB167405