Thread: enabling psqlODBC logs
Hi All
How can I enable psqlODBC logs ?? I want to collect error / warning / any critical info logs .
And where to check for these logs ??
Thanks..
Tamanna
--
Tamanna Madaan | Associate Consultant | GlobalLogic Inc.
Leaders in Software R&D Services
ARGENTINA | CHILE | CHINA | GERMANY | INDIA | ISRAEL | UKRAINE | UK | USA
Office: +0-120-406-2000 x 2971
www.globallogic.com
How can I enable psqlODBC logs ?? I want to collect error / warning / any critical info logs .
And where to check for these logs ??
Thanks..
Tamanna
--
Tamanna Madaan | Associate Consultant | GlobalLogic Inc.
Leaders in Software R&D Services
ARGENTINA | CHILE | CHINA | GERMANY | INDIA | ISRAEL | UKRAINE | UK | USA
Office: +0-120-406-2000 x 2971
www.globallogic.com
Hi Try to add "debug=1" or "commlog=1" to the connection string, the string which holds info for port, database to connect and so on. SQLDriverConnect(dbc, NULL, "Driver={PostgreSQL};Server=127.0.0.1;Port=5432;Database=postgres;Uid=postgres;Pwd=mypwd;debug=1;commlog=1;", SQL_NTS, NULL, 0, NULL, SQL_DRIVER_COMPLETE); If you use ODBC.INI you add debug=1 / commlog =1 to the section of your database. The logs created by the driver mylog_*.log / psqlodbc_*.log you find in a temp folder. Use a search tool to find out where exactly they are. hope this helps regards -- View this message in context: http://postgresql.1045698.n5.nabble.com/enabling-psqlODBC-logs-tp4983604p4995095.html Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.