I always used to have problems when using Access with H2 via the
postgres driver. At the time I tried just opening the simplest of
databases first, and then working up to a more complex database. It
ended up the problem was when opening a table that had a certain type of
key defined. I can't really remember, it was a while ago. Maybe support
for access has been broken again in a more recent H2 build.
Is the database accessible from something like MS Excel instead? At
least it would narrow down the issue...
On 17/02/2013 11:31 AM, Drew wrote:
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.
--
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.
