info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
bug in sqlGetInfo on Linux i386 platform
1 view
Skip to first unread message
Son Nguyen
Jan 29, 2013, 1:26:35 PM1/29/13
to
Hi,
sqlGetInfo on SQL_DBMS_VER returns different string when I have the protocol setting in the odbc.ini file
1) Here is the odbc.ini file that has entry Protocol which is set to 7.2, or 6.4. The SQM_DBMS_VER string contains some other info.
[GOSALES1_PG_92]
Driver=/usr/pgsql-9.1/lib/psqlodbc.so
Description=Sample PostgreSQL DSN
Servername=vottdts26
Database=gosales1
Username=gosales1
Password=gosales1
Servertype=postgres
Port=5432
Protocol = 7.2
drv-mob:/uda/dev/nguyens/postgres> ./a.out
SQL_DBMS_NAME = PostgreSQL, StringLengthPtr = 10
SQL_DBMS_VER = PostgreSQL 9.2.1, compiled by Visual C++ build 1600, 64-bit, StringLengthPtr = 59
SQL_DRIVER_NAME = psqlodbcw.so, StringLengthPtr = 12
SQL_DRIVER_VER = 09.00.0310, StringLengthPtr = 10
2) Here is the odbc.ini that Protocol entry is commented out. The SQM_DBMS_VER string does not contain other info.
[GOSALES1_PG_92]
Driver=/usr/pgsql-9.1/lib/psqlodbc.so
Description=Sample PostgreSQL DSN
Servername=vottdts26
Database=gosales1
Username=gosales1
Password=gosales1
Servertype=postgres
Port=5432
;Protocol = 7.2
drv-mob:/uda/dev/nguyens/postgres> ./a.out
SQL_DBMS_NAME = PostgreSQL, StringLengthPtr = 10
SQL_DBMS_VER = 9.2.1, StringLengthPtr = 5
SQL_DRIVER_NAME = psqlodbcw.so, StringLengthPtr = 12
SQL_DRIVER_VER = 09.00.0310, StringLengthPtr = 10
Thanks
Son Nguyen
Inoue, Hiroshi
Jan 30, 2013, 7:12:02 PM1/30/13
to
Hi Son,
(2013/01/30 3:26), Son Nguyen wrote:
> Hi,
> sqlGetInfo on SQL_DBMS_VER returns different string when I have the
> protocol setting in the odbc.ini file
> 1) Here is the odbc.ini file that has entry Protocol which is set to
> 7.2, or 6.4.
The effective values for *Protocol* are 6.2, 6.3, 6.4 or 7.4 and the
default is 7.4. Setting the protocol to values other than 7.4 has
little meaning for recent versions of PostgreSQL servers. In case
of old protocols the SQL_DBMS_VER string is simply the string which
'select version();' returns.
regards,
Hiroshi Inoue
--
Sent via pgsql-odbc mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
(2013/01/30 3:26), Son Nguyen wrote:
> Hi,
> sqlGetInfo on SQL_DBMS_VER returns different string when I have the
> protocol setting in the odbc.ini file
> 1) Here is the odbc.ini file that has entry Protocol which is set to
> 7.2, or 6.4.
default is 7.4. Setting the protocol to values other than 7.4 has
little meaning for recent versions of PostgreSQL servers. In case
of old protocols the SQL_DBMS_VER string is simply the string which
'select version();' returns.
regards,
Hiroshi Inoue
Sent via pgsql-odbc mailing list (pgsql...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
0 new messages