From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Lotus Domino Server/Enterprise Connection Services |
Date: | 2002-10-08 00:17:30 |
Message-ID: | 3DA2241A.935CBD84@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Mike Mascari wrote:
>
> I wrote:
> > Hi all.
> >
> > Has anyone successfully configured Lotus Domino Server R6 beta to
> > correctly connect to PostgreSQL via ODBC and the Enterprise Connection
> > Services interface?
>
> and
>
> > However, the R6 server returns garbage instead of legitimate
> > data. I suspect the server may be anticipating UCS-2 data, although I
> > didn't have enough time to play around with his configuration.
>
> I've compared the SQL trace log of Lotus Domino Server accessing
> a Microsoft Access database using DECS/ODBC vs. accessing a
> PostgreSQL database using DECS/ODBC. The main difference which
> is prohibiting Lotus Domino Server from connecting to a
> PostgreSQL database is the data type of the meta data.
>
> 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 ?
regards,
Hiroshi Inoue
http://w2422.nsk.ne.jp/~inoue/
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Mascari | 2002-10-08 00:43:28 | Re: Lotus Domino Server/Enterprise Connection Services |
Previous Message | Mike Mascari | 2002-10-07 21:18:17 | Re: Lotus Domino Server/Enterprise Connection Services |