Skip to content

efa2000/node-red-contrib-odbc

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

node-red-contrib-odbc

Node for Node-RED to unixODBC and its supported drivers. Based on node-odbc https://github.com/wankdanker/node-odbc

NOT SUPPORTED!

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 node-red-contrib-odbc

Configure node

####Connection string

Config

####Query

Config

You can uses the mustache format.

About

ODBC node for nore-red

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published