Hi, > - 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?
Most likely the problem is that only simple names are supported in the "database" property of the connection property. Therefore you can't append ";CIPHER=..." there. Is that the problem? It looks like there needs to be some escape mechanism for that. Otherwise there is nothing special about using ODBC, it should work exactly the same as when using JDBC. That is, the database password is the combination of the file password, a space, and the user password. > - 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'm not sure what the problem is. Unfortunately I currently don't have Microsoft Access installed... Could you start the PG Server with the -trace option, and then post or send me the output when you retry those operations? Probably it's easier if you redirect the output to a file. Another option (probably not required, let's see) would be to set the trace level to 3 so that each JDBC API call is written to the .trace.db file, and then post or send me this file. You will need to do that from a different connection (a JDBC connection), and append ;TRACE_LEVEL_FILE=3 to the database URL. Regards, Thomas -- 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.
