ODBC Drivers

Additional Setup Information

The following topic discusses additional steps you must perform to set up the 32-bit ODBC Drivers.

Additional Setup Information

Driver Information

The following topics discuss the ODBC Drivers.

dBASE Driver

Microsoft Access Driver

Microsoft Excel Driver

Microsoft FoxPro Driver

Paradox Driver

SQL Server Driver

Text Driver


Additional Setup Information

The following drivers require additional setup steps or additional software components. All other drivers only require that you install them from disk and, depending on your application, add one or more data sources for the driver.

dBASE Driver

Before you use the dBASE driver, you must place the following line in your AUTOEXEC.BAT file:

SHARE /L:200

The SHARE command allows file sharing and locking in a multitasking environment.  The /L option specifies the number of files that can be locked at one time.

Microsoft Access Driver

If you do not have Microsoft Access installed on your computer, add the following line to your CONFIG.SYS file:

FILES= 50

and the following line to your AUTOEXEC.BAT file:

SHARE.EXE /L:200

(If you are working with very large databases, this should be SHARE.EXE /L:500.)

Microsoft FoxPro Driver

Before you use the Microsoft FoxPro driver, you must place the following line in your AUTOEXEC.BAT file:

SHARE /L:200

The SHARE command allows file sharing and locking in a multitasking environment.  The /L option specifies the number of files that can be locked at one time.

SQL Server Driver

The SQL Server driver uses the Net-Library DLLs to communicate across a network with SQL Server.  If you have not already done so, install these on your computer.

It also uses the catalog stored procedures, which must be installed on your copy of SQL Server.  The catalog stored procedures are automatically installed on later versions of Microsoft SQL Server.

See Also

Hardware and Software Requirements for the SQL Server Driver

Setting Up the SQL Server Driver

Installing the Catalog Stored Procedures