What is an ODBC driver and what does it do?

What is an ODBC driver and what does it do?

ODBC stands for Open DataBase Connectivity and is a Microsoft standard for accessing different database systems from within Windows.  

Most popular databases have an associated ODBC connection routine.    

It is provided free with some databases but others have their ODBC driver as an extra that you must purchase. 

    • Related Articles

    • [MYOB ODBC] Invalid account number

      This error message from the Ostendo - MYOB Link program is due to 'funny characters' being in the Description field of the line record as held in Table FINANCIALPURCHASEINVOICES. These are accepted by Ostendo and MYOB but the ODBC Driver interprets ...

    • [MYOB ODBC] - Supplier not found in MYOB

      If you get a message "The Supplier for the Purchase Invoice does not exist in MYOB" even though you have checked they are the same This could be due to 1 of two reasons 1. Ostendo and MYOB allow commas in the Supplier Name but the MYOB-ODBC Driver ...

    • [MYOB ODBC] - Cannot connect to MYOB from the Link program

      With MYOB running we get message "MYOB ODBC - unable to launch MYOB database is already opened for exclusive use" In Windows 7 try running the Ostendo - MYOB routine as an Administrator. I.e. Right Mouse on the Desktop Icon and select 'Run as ...

    • [MYOB ODBC] - Unable to determine if Import has finished

      This requires elimination of potential problem that give rise to this error message. Therefore: 1 Deactivate the Anti-Virus software completely and try to post - this shows if it is an Anti-Virus problem or not 2 Try to post to the Clearwater Demo ...

    • Setting Up Tax for Wine Manufacturers In Australia For MYOB

      This is an issue with the MYOB ODBC driver whereby the tax codes that make up the Consolidated Tax Code in MYOB need to be both GST type (not Sales tax types). That will then split the tax out correctly in MYOB via posting to the one Consolidated Tax ...