Jump to content

  • ODBC Driver Information

    PVA - Admin

    By PVA - Admin (edited)

    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

    • Like 2

      Report Article
    Go to articles Troubleshooting

    User Feedback


    Alexander Thiel

    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
    Link to comment
    • Vectorworks, Inc Employee
    PVA - Admin
    • Vectorworks, Inc Employee
    On 6/6/2017 at 3:18 AM, Alexander Thiel said:

    Is PostgreSQL a supported database?


    It is not, no.

    • Like 1
    Link to comment


    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Add a comment...

    ×   Pasted as rich text.   Restore formatting

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×

×
×
  • Create New...