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" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
