Thread: odbc driver not working with EOModeler

odbc driver not working with EOModeler

From
"YL"
Date:
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.=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.