From: | Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com> |
---|---|
To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: MyLog and CommLog options |
Date: | 2017-02-04 07:51:40 |
Message-ID: | 7C1F2298-B33F-4083-86D7-9F0F57AB1C04@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> 4 февр. 2017 г., в 10:45, Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp> написал(а):
>
> Hmm, odbc.ini exists for datasource description whereas odbcinst.ini exists for driver description.
> How do you call ODBC, via DSN or DSNless?
I’m trying both. The latest attempt:
miniBagroff:odbc danilabagroff$ cat /usr/local/etc/odbc.ini
[pg_abra1]
Driver = PostgreSQL
Host = localhost
Port = 5432
Protocol = 6.4
FetchBufferSize = 99
Database = abra1
ReadOnly = no
MyLog = /tmp/mylog2.log
miniBagroff:odbc danilabagroff$ cat /usr/local/etc/odbcinst.ini
[ODBC]
Trace = Yes
TraceFile = /usr/local/var/log/odbc/trace.log
[ODBC Drivers]
PostgreSQL = Installed
[PostgreSQL]
Description = PostgreSQL ODBC Driver
Driver = /usr/local/lib/psqlodbcw.so
Setup = /usr/local/lib/psqlodbcw.so
Protocol = 6.4
FetchBufferSize = 99
ReadOnly = no
MyLog = /tmp/mylog1.log
miniBagroff:odbc danilabagroff$ isql pg_abra1 abra cadabra -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> SELECT 1;
+------------+
| ?column? |
+------------+
| 1 |
+------------+
SQLRowCount returns 1
1 rows fetched
SQL> quit
miniBagroff:odbc danilabagroff$ ls /tmp/mylog*
ls: /tmp/mylog*: No such file or directory
— Daniil A Megrabyan —
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2017-02-04 08:30:35 | Re: MyLog and CommLog options |
Previous Message | Inoue, Hiroshi | 2017-02-04 07:45:24 | Re: MyLog and CommLog options |