SQLDriverConnect (Visual FoxPro ODBC Driver)
Note
This article contains Visual FoxPro ODBC Driver-specific information. For general information about this function, see the appropriate article under ODBC API Reference.
Support
Full.
ODBC API conformance
Level 1.
Remarks
Connects to an existing data source, which can be either a database or a directory of free tables. The ODBC attribute keywords UID and PWD are ignored. The following table lists the additional supported attribute keywords.
| ODBC attribute keyword | Attribute value |
|---|---|
DSN |
|
UID |
Ignored by the Visual FoxPro ODBC Driver, but doesn't generate an error. |
PWD |
Ignored by the Visual FoxPro ODBC Driver, but doesn't generate an error. |
Driver |
The name and location of the Visual FoxPro ODBC Driver; implemented by the Driver Manager. |
| Visual FoxPro ODBC Driver attribute keyword | Attribute value |
|---|---|
BackgroundFetch |
Yes or No |
Collate |
"Machine" or other collating sequence. For a list of supported collating sequences, see SET COLLATE Command. |
Description |
|
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 |
Version |
If the data source name isn't specified, the Driver Manager prompts the user for the information (depending on the setting of the fDriverCompletion argument) and then continues. If more information is required, the Visual FoxPro ODBC Driver displays the prompt dialog.
For more information, see SQLDriverConnect Function in the ODBC Programmer's Reference.