I've used EOModeler with odbc for MS SQL Server,
MySQL and MS Access with no problem. But got
problem with postgre odbc driver.
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.
|