1,64位系統下,postgresql 的psqlodbc驅動
http://www.postgresql.org/ftp/odbc/versions/src/
2,64位系統下,安裝psqlodbc需要的安裝包:
unixODBC-2.3.1.tar.gz
psqlodbc-09.01.0100.tar.gz
3,安裝unixODBC
tar zxvf unixODBC-2.3.1.tar.gz
cd unixODBC-2.3.1
./configure --enable-gui=no
make
make install
4,安裝psqlodbc
unixODBC提供了Linux對ODBC的支援,但它只是一個ODBC的管理器,要串連實際的資料庫還需要提供這種資料庫的ODBC驅動
psqlodbc就是Linux下用於串連postgresql的免費ODBC驅動
注意: 必須先裝unixODBC,再安裝psqlodbc
tar zxvf psqlodbc-09.01.0100.tar.gz
cd psqlodbc-09.01.0100
./configure --with-unixodbc --with-libpq=/usr/local/pgsql
make
make install
5,配置ODBC (以下提供一個樣本)
vi /etc/odbcinst.ini
[PostgresSQL]
Description = ODBC for PostgresSQL
Driver =
Driver64 = /usr/local/lib/psqlodbcw.so
Setup =
Setup64 =
FileUsage = 1
CpTimeout =
CpReuse =
cp /etc/odbcinst.ini /usr/local/etc/odbcinst.ini
vi /etc/odbc.ini
[tmau_psv3]
Description = tmau_psv3
Driver = PostgresSQL
Trace = No
TraceFile =
Database = tmau_psv3
Servername = 192.168.51.97
Username = pgadmin
Password = kgpgadmin
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
cp /etc/odbc.ini /usr/local/etc/odbc.ini
6,用ODBC提供的isql工具檢查odbc驅動與DNS是否配置成功
[root@r710-64c6 64bits_install]# isql -v tmau_psv3
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
形如以上現象,表示psqlodbc配置成功。