• ODBC Driver Information


    JimW

    The Vectorworks 2011 Design Series products include the ability to communicate with external databases according to Open Database Connectivity (ODBC) standard. Using ODBC, a set of data can be used to automatically update the records attached to objects. Similarly, Vectorworks objects can send object data to a database, updating it.

    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.

     

    Windows

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

    Driver Name Driver Driver Connection Update VW records by reading data from database Update database with VW 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, but not working because connection is read only

    Error reported: S1000, “Operation must be an updatable query.” 
    Supported, but not working because connection is read only 

    Error reported: S1000, “Operation must be an updatable query.” 
    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 Not working Error Reported: IM002, “Data source name not found and no default driver specified.” Not working Error Reported: IM002, “Data source name not found and no default driver specified.” Not working Error Reported: IM002, “Data source name not found and no default driver specified.”
    MySQL Available at:

    www.mysql.com
    Supported, working Supported, working Supported, working Supported, working
    FileMaker Pro ** Available at:

    www.filemaker.com
    Supported, working Supported, working Supported, working Supported, working

     

     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     

    *On Windows 7 64bit systems, you need to run the 32bit ODBC manager (odbcad32.exe) to see the built in drivers, which are currently 32bit 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.

    Macintosh

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

    Driver Name Driver Driver Connection Update VW records by reading data from database Update database with VW record data Add new database table rows through object connection
    Actual SQL Available at: 

    www.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:


    www.actualtech.com
    Supported, working Not supported Not supported Not supported
    MySQL Available at: 

    www.mysql.com
    Supported, working Supported, working Supported, working Supported, working
    FileMaker Pro * Available at:

    www.filemaker.com
    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.

    Edited by JimW



      Report Article


    User Feedback


    Hey guys,

     

    how about PostgreSQL?

     

    We tried to connect a PostrgeSQL database by using ODBC w/o success.

    Is PostgreSQL a supported database?

     

    Greez, Alex

    Edited by Alexander Thiel
    Correction

    Share this comment


    Link to comment
    Share on other sites
    On 6/6/2017 at 3:18 AM, Alexander Thiel said:

    Is PostgreSQL a supported database?


    It is not, no.

    Share this comment


    Link to comment
    Share on other sites