Обсуждение: enabling psqlODBC logs

Поиск
Список
Период
Сортировка

enabling psqlODBC logs

От
tamanna madaan
Дата:
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


Re: enabling psqlODBC logs

От
BGoebel
Дата:
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.