Re: Re: numeric type and odbc from access 2000

I also use the ODBC driver and have noticed some things that could be
improved and some bugs

Since it's open source I was thinking of getting the source code and making
some changes myself

Has anyone done this? My knowledge of C is passable so maybe I could do
this?

The ODBC driver doesn't seem to be too well supported which is a shame
because its the only link

PG has with the Windows world if your using any MS app or developing in VB.

MC.

>The problem can be fixed in psql with explicit casting but the windows
odbc
driver for postgres does not make that determination correctly so update
and delete statements from access give errors when there is a float or a
numeric/decimal type in any table. And unfortunately, there is no way to
adjust the sql statements sent from access to the ODBC to explicitly cast
datatypes (or at least I think that's true)

This seems to be a major issue if one is using access as a front-end client
beacuse any table with float/numeric type will not be updated or deleted.

Any idea (from anyone) when there will be an ODBC fix or a fix so the
numeric type don't have to be explicitly casted in postgresql.

cheers,

Shahab
Shahab Asgharzadeh, MD

Bioinformatics Director, Neurogenetics Lab
Assistant Professor of Neurology, Northwestern University
Pediatric Clinical Associate, University of Chicago
312-503-4737
"You must be the change you wish to see in the world." - Gandhi

--

NOTICE: The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential. If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.