SUSE 11 SP3里面配置ODBC

SUSE 11 SP3 里面的 ODBC 配置和 CentOS 有些许不同

需要先安装 unixODBC

在文件/etc/unixODBC/odbcinst.ini 中新增

[OushuDB]
Description = OushuDB driver for Linux
Driver = /usr/lib64/unixODBC/libodbcpsql.so
Setup = /usr/lib64/unixODBC/libodbcpsqlS.so

在文件/etc/unixODBC/odbc.ini 中新增

[OushuDB]
Driver = OushuDB
Description = HAWQ DSN
Servername = 10.0.193.85
Database = postgres
Username = gpadmin
Password = gparray
Port = 5432
ReadOnly = No
Fetch = 10000 #必须有
UseDeclareFetch = 1 #必须有