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