(1)官网下载odbc驱动vertica-client-8.1.1-2.x86_64.tar.gz
(2)解压
sudo tar -zxvf vertica-client-8.1.1-2.x86_64.tar.gz
(3)安装依赖
Ubuntu/Debian:
sudo apt-get install unixodbc unixodbc-dev
RedHat/CentOS:
sudo yum install unixODBC unixODBC-devel
(4)修改配置文件
sudo vi /etc/odbcinst.ini
插入
[VERTICA]
Description = ODBC Driver for Vertica
Driver = /yourpath/opt/vertica/lib64/libverticaodbc.so
Setup = /yourpath/opt/vertica/lib64/libverticaodbc.so
:wq
(5)安装node-odbc
npm install odbc
(6)测试
let db=require("odbc")();
let cn = "DRIVER={VERTICA};SERVER=192.168.1.11;UID=dbadmin;PWD=pwd;DATABASE=db";
db.open(cn,(err)=>{
if(err){
console.log(err);
}
else{
let sql="select * from test";
db.query(sql,(err,data)=>{
if(err){
console.log(err);
}
else{
console.log(data);
}
db.close();
});
}
});