Обсуждение: ODBC Driver

Поиск
Список
Период
Сортировка

ODBC Driver

От
Evelio Martinez
Дата:

Hello!

Which ODBC driver would you recommend me to connect postgresql 7.0.3 on
linux with W95/W98/Srv200 clients  and
possibly Ms Access or VB ?

Thanks in advance

Evelio



Re: ODBC Driver

От
"Poul L. Christiansen"
Дата:
This one:

ftp://ftp.postgresql.org/pub/odbc/index.html
Poul L. Christiansen

Evelio Martinez wrote:

> 
> Hello!
> 
> Which ODBC driver would you recommend me to connect postgresql 7.0.3 on
> linux with W95/W98/Srv200 clients  and
> possibly Ms Access or VB ?
> 
> Thanks in advance
> 
> Evelio




Re: ODBC Driver

От
Bruce Momjian
Дата:
I got this report from a user.  Anyone?

---------------------------------------------------------------------------

Goertz, Dave PSC wrote:
> We have been using the old driver (ver. 07_01_0004) and its seems fine
> except for when doing left outer joins from Access.  The log shows that
> characters like '{' are being placed into the code being given to the back
> end.
> We tried the newer one (ver. 07_03_0100) in the summer and found that it
> caused other problems so we stayed with the old one.
> Now we were trying the newest one (ver. 07_03_0200) and it seems to fix the
> left outer join problem but breaks other things.
> In particular we use a language called SAS to talk to PostgreSQL and
> everything works except for certain comparisons.
> 
> Ex:   If REG_PY NE 0;
> 
> The old driver passes some 39,000 records through this statement but the new
> one passes 1900.
> 
> Are data types being screwed up.  REG_PY should just be a numeric datatype.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073