On Thursday, May 20, 2010 4:29:17 AM UTC+8, Paul wrote: > > 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]<javascript:>. > > To unsubscribe from this group, send email to > [email protected] <javascript:>. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
