From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Daniil Megrabyan <danil(dot)megrabjan(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: MyLog and CommLog options |
Date: | 2017-02-04 08:30:35 |
Message-ID: | a821a6ec-d5ed-c6b7-3225-424cad5f7a20@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 2017/02/04 16:51, Daniil Megrabyan wrote:
>> 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
Mylog isn't an option, instead try
Debug = 1
Possibly you will find /tmp/mylog_xxxx.
regards,
Hiroshi Inoue
>
> 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 | Daniil Megrabyan | 2017-02-04 08:44:41 | Re: MyLog and CommLog options |
Previous Message | Daniil Megrabyan | 2017-02-04 07:51:40 | Re: MyLog and CommLog options |