From: | Mike Mascari <mascarm(at)mascari(dot)com> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Lotus Domino Server/Enterprise Connection Services |
Date: | 2002-10-08 01:51:25 |
Message-ID: | 3DA23A1D.1040801@mascari.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
I wrote:
> Hiroshi Inoue wrote:
>
>>Mike Mascari wrote:
>>
>>>When Domino Server examines data using the Access ODBC driver,
>>>it calls SQLTables() followed by SQLDescribeCol().
>>>SQLDescribeCol() returns a value of 12 (SQL_VARCHAR) for the
>>>data type of the metadata (like table names or column names),
>>>whereas the PostgreSQL driver is returing a -1 (Who knows?) for
>>
>>
>>-1 is SQL_LONGVARCHAR. Hmm the driver has handled the
>>char columns for the result of most catalog functions
>>as PG_TYPE_TEXT and it seems to be the cause. I changed
>>them to PG_TYPE_VARCHAR and put the binaries on
>>http://w2422.nsk.ne.jp/~inoue/.
>>Could you try the dll ?
>
>
> Yes, I will. I poked around a little further. It seems Domino
> can't handle SQL_LONGVARCHAR, so just unchecking "Text as
> LongVarChar" allowed it to properly peruse the catalog. I'll
> also do some more rigorous testing as well...
Your DLL works nicely without having to disable "Text as
LongVarChar", which makes sense.
Thanks!
Mike Mascari
mascarm(at)mascari(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-10-08 07:05:48 | Re: Unix build |
Previous Message | Mike Mascari | 2002-10-08 00:43:28 | Re: Lotus Domino Server/Enterprise Connection Services |