Fetch = Yes # Bools as Char # Bools are mapped to SQL_CHAR, otherwise to SQL_BIT. ODBC configuration files are another option to specify connection parameters and allow one to use a Data Source Name (DSN) to make it easier to connect to a. Technical Specifications Progress DataDirect for ODBC for PostgreSQL Wire Protocol Driver Version 8.0.2 (32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted. ShowSystemTables = No # If true, the driver automatically uses declare cursor/fetch to handle SELECT statements and keeps 100 rows in a cache. This is good for Access so you can see system tables. RowVersioning = No # Show SystemTables # The driver will treat system tables as regular tables in SQLTables. # It also speeds the update process since every single column does not need to be specified in the where clause to update a row. Protocol = 7.4+ # Includes the OID in SQLColumns ShowOidColumn = No # Fakes a unique index on OID FakeOidIndex = No # Row Versioning # Allows applications to detect whether data has been modified by other users # while you are attempting to update a row. This is only compatible with 7.4 and higher backends. It connects to all popular databases and runs on Win, macOS & Linux. 21 1 1 4 Add a comment 2 Answers Sorted by: 2 I Download the driver from: Search your PG version and install it, then check you ODBC drives under administratives tools. The first is ODBC Data Sources which is a list of arbitrary names and descriptions for each database you. odbc.ini file has three required sections. The file uses conventions typical for Windows Registry files, but despite this restriction can be made to work. ReadOnly = No # PostgreSQL backend protocol # Note that when using SSL connections this setting is ignored. DbVisualizer is the SQL Client and Database Tool with the highest user satisfaction. /.odbc.ini contains user-specified access information for the psqlODBC driver. IP or DNS Servername = 127.0.0.1 # Database name Database = zabbix # Postmaster listening port Port = 5432 # Database is read only # Whether the datasource will allow updates. I installed ODBC libraries and PostgreSQL ODBC driver on Linux by running the command: sudo apt-get install unixodbc unixodbc-dev odbc-postgresql I edited /etc/odbc. Description = PostgreSQL database 1 Driver = postgresql #CommLog = /tmp/sql.log Username = zbx_test Password = zabbix # Name of Server. Windows, running PostgreSQL Ubuntu linux I need to connect from Linux machine to the PostgreSQL on Windows, using C++ code by ODBC library.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |