LINUX-搭建ODBC连接Oracle

搭建ODBC连接Oracle

1,解压安装包进行配置

tar -xvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0/ 

–如配置错误，看是否安装gcc

2,编译运行

./configure --prefix=/usr/local/unixODBC-2.3.0 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etc

make && make install

安装完成后，查看unixODBC安装情况，可能会报如下错误：

#odbcinst -j
odbcinst: error while loading shared libraries: libodbcinst.so.2: cannot open shared object file: No such file or directory

odbcinst -j
报错解决：ldconfig命令解决

3,配置连接

编辑配置文件

[oracle@localhost bin]$ cat /etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver = /u01/app/oracle/product/11.2.0/dbhome_1/lib/libsqora.so.11.1
Threading = 0
Driver为Oracle的libsqora.so.11.1文件目录


[oracle@localhost bin]$ cat /etc/odbc.ini
[ORACLE]
Description = ORACLE ODBC DSN
Driver = Oracle in OraDb11g_home1
SERVER = 192.168.6.106
UID = DMHS
PWD = dm123
Servername = PROD
PORT = 1521

4,oracle测试连接

isql -v ORACLE DMHS dm123