MariaDB 5.5 ODBC SQLEX Error

mhsabado commented 1 year ago

Hi Marcos,

I have tested MariaDB 5.5 with ODBC 3.1 DSN and DSN-Less connection using SQLEX and got the ff error. The same test works fine using SQLRDD. I also observed that Logical Data Type is translated to TinyInt.

Thanks, Mario

Error SQLRDD/0 SQL execution error at dbGoTop, return code: -1, state: 42000, description: [ma-3.1.19][5.5.68-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '"sr_recno", A."sr_deleted" FROM test A ORDER BY A."sr_recno" ASC LIMIT 26' at line 1. Called from DBCREATE(0) Called from MAIN(56) ┌──────────────────────────────────────────────┐ │ Error SQLEX/1010 Argument error: test │ │ │ │ Quit │ └──────────────────────────────────────────────┘

mariadb_odbc_sqlex_error

marcosgambeta commented 1 year ago

The commit below fixed the syntax error for me: https://github.com/marcosgambeta/sqlrddpp/commit/e1f04cd5681ebbf33aa85f00f60d63c48ce20b75

Please, test in your development environment.

mhsabado commented 1 year ago

Hi Marcos,

This is to confirm that my local test for MariaDB ODBC using SQLEX is already fixed.

Thank you very much!

Best regards, Mario

On Tue, Sep 26, 2023 at 3:22 AM Marcos Antonio Gambeta < @.***> wrote:

The commit below fixed the syntax error for me: e1f04cd https://github.com/marcosgambeta/sqlrddpp/commit/e1f04cd5681ebbf33aa85f00f60d63c48ce20b75

Please, test in your development environment.

— Reply to this email directly, view it on GitHub https://github.com/marcosgambeta/sqlrddpp/issues/10#issuecomment-1734330838, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACAWM4SLY43BIL4P5ISSAWTX4HKVVANCNFSM6AAAAAA5EZOKGQ . You are receiving this because you authored the thread.Message ID: @.***>

marcosgambeta / sqlrddpp

MariaDB 5.5 ODBC SQLEX Error #10