ODBC Driver InformationODBC Driver InformationWhen 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.
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: |
Supported, working |
Supported, working |
Supported, working |
Supported, working |
|
FileMaker Pro ** |
Available at: |
Supported, working |
Supported, working |
Supported, working |
Supported, working |
* On Windows 7 64-bit systems, you need to run the 32-bit ODBC manager (odbcad32.exe) to see the built-in drivers, which are currently 32-bit only.
** 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.
On the Mac, there is no integrated ODBC manager. Suggestions include:
● ODBC Manager (http://www.odbcmanager.net)
● iODBC Manager (http://www.iodbc.org)
● ODBC Administrator Tool (http://suport.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: |
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: |
Supported, working |
Not supported |
Not supported |
Not supported |
|
MySQL |
Available at: |
Supported, working |
Supported, working |
Supported, working |
Supported, working |
|
FileMaker Pro * |
Available at: |
Supported, working |
Supported, working |
Supported, working |
Supported, working |
* 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.
~~~~~~~~~~~~~~~~~~~~~~~~~
