irobo-odbc

odbc integration

Usage no npm install needed!

<script type="module">
  import iroboOdbc from 'https://cdn.skypack.dev/irobo-odbc';
</script>

README

Requirements

  • unixODBC binaries and development libraries for module compilation
    • on Ubuntu/Debian sudo apt-get install unixodbc unixodbc-dev
    • on OSX using macports.org sudo port unixODBC
  • odbc drivers for target database
  • properly configured odbc.ini and odbcinst.ini.

Example of odbcinst.ini

    [PostgreSQL]
    Description=ODBC for PostgreSQL
    Driver=/usr/lib/psqlodbc.so
    Setup=/usr/lib/libodbcpsqlS.so
    FileUsage=1

    [MySQL]
    Description=ODBC for MySQL
    Driver=/usr/lib/libmyodbc5.so
    Setup=/usr/lib/libodbcmyS.so
    FileUsage=1

    [FreeTDS]
    Description=ODBC for MS SQL
    Driver=/usr/lib64/libtdsodbc.so.0

    [MSSQL]
    Description=Microsoft ODBC Driver 11 for SQL Server
    Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2270.0
    Threading=1
    UsageCount=1

Install

After insuring that all requirements are installed run the following command in the root directory of your Node-RED install

    npm install irobo-odbc