[BUGS] problem odbc 8.0 with EOModeler

2005-07-30 Thread YL
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:   SQLExecDir

Re: [BUGS] problem odbc 8.0 with EOModeler

2005-08-01 Thread YL
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 cas

Re: [BUGS] problem odbc 8.0 with EOModeler

2005-08-01 Thread YL
em odbc 8.0 with EOModeler It looks like this is being treated on the server as though the statement is: SELECT t0."pname", t0."person_id" FROM "person" t0 WHERE t0."pname" = Elim rather than: SELECT t0."pname", t0."person_id" FRO

[BUGS] odbc driver not working with EOModeler

2005-08-04 Thread YL
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 - [ODBCChanne

[BUGS] Problems found when compare pgsql odbc 8.0 and myodbc 3.5 using EOModeler

2005-08-23 Thread YL
EOModeler is a GUI tool to model the database schema as well as the mapping between database records and EnterpriseObjects. The version I'm using comes with database adaptors for Oracle, Sybase,Informix,LDAp FlatFile,Openbase and ODBC. I've used EOModeler with many differenct databases includ