Hi, I'm trying to connect H2 from Ms. Access using ODBC. H2 database I use: H2-1.2.135.jar Postgre ODBC: psqlODBC version 8.03.0400
Problems I got: - If the DB is encrypted, can't connect at all from odbc, if I decrypted the db I can connect to it, is there documentation how to connect to encrypted H2 db using ODBC? - Unable to link to a table that has a field with primary key or unique key, for example: id_employee INT AUTO_INCREMENT PRIMARY KEY The table is shown, but when I select to link it, it says error. If I make the field INT AUTO_INCREMENT, there is no problem linking to it. - And the big problem is, when a table has _ (underscore) in the name, for example: table name employee_jobs, when trying to link to that table, ms access says the table is not exists, very strange why it said there is no such table, because I pick the table from the list of the tables that shown by ms access. I followed the ODBC documentation in here: http://www.h2database.com/html/advanced.html?highlight=odbc&search=odb#odbc_driver Please help. Thanks... -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
