I'm not sure I understood the solution... I think I set up the PostgreSQL ODBC driver correctly in the System DSN (at least hittling [ Test ] returns "Connection Successful".)
In Access, when I go to Link tables, select ODBC, Machine Data Source: PostgreSQL (from ODBC Data Sources), it brings up the tables (all listed as PUBLIC): ...but selecting one and clicking [ OK ] returns the following error: This is what I see after trying to link tables to the H2 database from Access. Not sure how to run trace and what to post. My setup: H2: h2-1.3.170 psqlodbc: psqlodbc_09_01_0200-1 Access 2003: 11.0.8321 Any help would be greatly appreciated. Thanks, Drew On Friday, February 26, 2010 11:06:32 AM UTC-6, Thomas Mueller wrote: > > Hi, > > > all the problems seems resolved. > > Thanks a lot for your help! > > Regards, > Thomas > > -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
