Re: problem odbc 8.0 with EOModeler

Is the column name "Elim" or "elim"?  If the former, try putting quotes aro=
und it, as required by the ANSI and ISO standards for mixed case identifier=
s.  Some database products fail to comply with the standards in this respec=
t.  PostgreSQL comes close, although it treats unquoted identifers as all l=
ower case rather than all upper case as required by the standards.
=20
-Kevin
=20
=20
>>> "YL" <elim@pdtnetworks.net> 07/30/05 3:48 PM >>>
I've used EOModeler with odbc for MS SQL Server,=20
MySQL and MS Access with no problem. But got=20
problem with postgre odbc driver. (the newest one)=20

EOMOdeler cannot get postgresql column types' info=20
through odbc. Also, It cannot interact with EOModeler
for very simple query:

SQLExecDirectin - [ODBCChannel evaluateExpression:
(<ODBCSQLExpression: "SELECT t0.pname,t0.person_id
FROM person t0 WHERE t0.pname =3D ? " withBindings:
(1:Elim(name)) >)]
S 1000-7: ERROR: column 'elim' doesnot exitst

EOModeler is an app in WebObjects (www.apple.com)=20
I'm using version 4.5.1 ObjC. EOModeler has adaptors
for Oracle, Infomix, Sybase, Openbase. All works very
well.

My guess is that postgresql-odbc has some non-standard
api and so EOModeler fails to work with it.