This ODBC Driver is provided by Microsoft.
![]() Coding
Info, examples and downloads for 'Microsoft Visual FoxPro ODBC Driver'. Connection string options and links to more detailed resources. May 16, 2008 Important download details: Installing the Microsoft OLE DB Provider for Visual FoxPro 9.0 on a computer that has a previous version of the Provider causes.
Include 'Driver={Microsoft Visual FoxPro Driver}' in the connection string to use this driver.
Description
The Visual Fox Pro ODBC driver ships with Microsoft Visual FoxPro, Microsoft Windows 2000, Microsoft Office 2000, and MDAC version 2.5 and earlier.
Download
ODBC Driver (Microsoft Visual FoxPro ODBC Driver) can be downloaded here.
Connection Strings
The Microsoft Visual FoxPro ODBC Driver driver can be used to connect to the following data sources:
To see available connection options, navigate to the connection strings reference by the above links.
-->
The ODBC Visual FoxPro Setup dialog box enables you to add or change a Visual FoxPro data source.
To download the driver, see the Visual FoxPro ODBC Driver download site.
Dialog Box Options
Data Source Name
Type the name you want to use for the data source.
Description
Type a description for the data source.
Database type
Lets you choose the type of database you want your data source to connect to.
Visual FoxPro database (.DBC)
Specifies that the data source connects to a Visual FoxPro database (.dbc file) and to all the tables and local views in the database.
Free Table directory
Specifies that the data source connects to a directory of free tables. Any database tables in the same directory are ignored by ODBC catalog functions such as SQLColumns or SQLTables. Database tables can be accessed by using SQL SELECT statements sent through SQLExecute and SQLExecDirect.
Path
Displays the path and name for the database or the directory of free tables to which the data source connects.
Browse
Enables you to search your system and network for the database or directory to which you want to connect the data source.
Options
Expands the dialog box so that you can set Visual FoxPro ODBC Driver options. Driver
Collating sequence
The sequence in which fields are sorted. The default sequences reflect the sequences supported by your language version of the operating system. For a list of supported collating sequences, see SET COLLATE. ![]()
Exclusive
When this check box is selected, the driver opens the Visual FoxPro database exclusively when you access data using the data source. Other users cannot access the database or the tables in the database while the database is opened exclusively. Tables within the exclusively opened database are opened as SHARED. To open a table exclusively, use the SET EXCLUSIVE command. This check box is disabled when Database type is set to Free Table directory.
Null
Determines whether columns created with ALTER TABLE and CREATE TABLE allow null values. If you set Null ON, INSERT - SQL inserts a null value into any column not included in an INSERT - SQL... VALUE clause. A blank is inserted if Null is OFF. You can also control this option through a passed connection string as in the following code:
Deleted
Determines whether rows marked as deleted are returned. You can also control this option through a passed connection string as in the following code:
Fetch data in background Determines whether records will be fetched in the background (progressive fetching) or your application will wait until all records in the result set are fetched. ![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |