linux odbc 配置文件,Linux下配置PostgreSQL 的ODBC

作者：Gausst松鼠会 | 2024-06-12 03:07:37

踩

psqlodbca.so

Linux下安装ODBC

1、在/etc目录下修改odbc.ini、odbcinst.ini文件

odbc.ini文件中主要是配置数据库连接

odbcinst.ini配置数据库驱动文件

root@ wwww.linuxidc.com:/etc# more odbc.ini

[fsnhhb]

Description = For Nanhai, Foshan's smoke monitor

Driver = PostgreSQL

# Driver = enterprisedb

Trace = Yes

TraceFile = /tmp/sql.log

Database = ZHDB

Servername = 127.0.0.1

UserName = epmonitor

Password = system

Port = 5444

Protocol = 7.4

ReadOnly = No

RowVersioning = No

ShowSystemTables = No

ShowOidColumn = No

FakeOidIndex = No

ConnSettings =

--------------------------------------------------------------------

linuxidc@wwww.linuxidc.com:/etc$ more odbcinst.ini

[PostgreSQL]

Description=ODBC for PostgresSQL

Driver=/usr/lib/odbc/psqlodbca.so

Setup=/usr/lib/odbc/libodbcpsqlS.so

UsageCount=1

[enterprisedb]

Description=PostgresPlus Advanced Server ODBC driver

Driver=/opt/PostgresPlus/8.4AS/connectors/odbc/lib/edb-odbc.so

Setup=/opt/PostgresPlus/8.4AS/connectors/odbc/lib/libodbcedbS.so

UsageCount=1

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/Gausst松鼠会/article/detail/705971