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 #必须有