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.