Re: problem odbc 8.0 with EOModeler

Is the column name "Elim" or "elim"? If the former, try putting quotes around it, as required by the ANSI and ISO standards for mixed case identifiers. Some database products fail to comply with the standards in this respect. PostgreSQL comes close, although it treats unquoted identifers as all lower case rather than all upper case as required by the standards.

-Kevin


>>> "YL" <elim(at)pdtnetworks(dot)net> 07/30/05 3:48 PM >>>
I've used EOModeler with odbc for MS SQL Server,
MySQL and MS Access with no problem. But got
problem with postgre odbc driver. (the newest one)

EOMOdeler cannot get postgresql column types' info
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 = ? " withBindings:
(1:Elim(name)) >)]
S 1000-7: ERROR: column 'elim' doesnot exitst

EOModeler is an app in WebObjects (www.apple.com)
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.