Re: Lotus Domino Server/Enterprise Connection Services

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/