DesignSeries00017.pngODBC driver information

When setting up a database program for ODBC functionality, related drivers may not be installed. This list describes drivers available for each platform, where to obtain them, and current problems that may exist.

SQLite database files do not require an ODBC manager.

Windows

On Windows, the ODBC manager is integrated into the operating system (OS).

Driver name

Driver

Driver connection

Update Vectorworks records by reading data from database

Update database with Vectorworks record data

Add new database table rows through object connection

Microsoft Access

Integrated in the OS

Supported, working

Supported, working

Supported, working

Supported, working

Microsoft Excel

Integrated in the OS

Supported, working

Supported, working

Supported, working

Supported, working

Microsoft SQL Server

If not integrated in the OS, ask vendor

Supported, working

Supported, working

Supported, working

Supported, working

Microsoft Text Driver

Integrated in the OS

Supported, working

Supported, working

Supported, working

Supported, working

MySQL

Available at:

mysql.com 

Supported, working

Supported, working

Supported, working

Supported, working

FileMaker Pro

Available at:

claris.com 

Supported, working

Supported, working

Supported, working

Supported, working

Mac

On the Mac, there is no integrated ODBC manager. Suggestions include:

       ODBC Manager (odbcmanager.net)

       iODBC Manager (iodbc.org)

       ODBC Administrator Tool (support.apple.com/kb/DL895)

Driver name

Driver

Driver connection

Update Vectorworks records by reading data from database

Update database with Vectorworks record data

Add new database table rows through object connection

Actual SQL

Available at:

actualtech.com 

Supported, working

Supported, working

Supported, working

Problem reported: data length restriction when writing to database

Supported, working

Problem reported: data length restriction when writing to database

Actual Access

Available at:

actualtech.com 

Supported, working

Not supported

Not supported

Not supported

MySQL

Available at:

mysql.com 

Supported, working

Supported, working

Supported, working

Supported, working

FileMaker Pro *

Available at:

claris.com 

Supported, working

Supported, working

Supported, working

Supported, working

* As of its version 12, FileMaker Pro includes the driver needed to share your database as a data source. To use your FileMaker database file locally, FileMaker Pro must be running, and the database file opened and shared. To share your FileMaker database file as a data source over a network, use FileMaker Server Advanced. As of version 13 of FileMaker Pro, the ODBC driver is distributed with the server version of the product. For more details, see claris.com.

~~~~~~~~~~~~~~~~~~~~~~~~~

Database setup

 

 

 

Was this page helpful?