ODBC 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: |
Supported, working |
Supported, working |
Supported, working |
Supported, working |
|
FileMaker Pro |
Available at: |
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: |
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 |
* 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.
