That looks a bit messed up!
I'm not sure sorry, apart from trying different versions of drivers,
etc. and setting H2 to trace level logging.
Does it work if you try it with postgres server?
It feels like it might be a bit of work sorting this out, and a bit of
trial and error.
I know it used to work for me, so I know in the past it has worked. But
I haven't got any of it set up at the moment to verify it still works...
On 18/02/2013 12:10 PM, Drew wrote:
<https://lh3.googleusercontent.com/-Aduo3TSe3pY/USGnZsUlpXI/AAAAAAAAAZc/GVEURnITRys/s228/xls-ODBC-linked_table_err_30217.png><https://lh4.googleusercontent.com/-4Ic7WMCZSLI/USGpNhuDmpI/AAAAAAAAAZ8/s7NeDH29DeU/s230/xls-ODBC-linked_table_err_30217a.png>
OK, that was fun. I haven't used the data import function in Excel
before -- I'm use to saving out the XLS files and importing them
manually in Access. Here's the result of this attempt (and no data in
the table).
Any thoughts?
Thanks.
Drew
On Sunday, February 17, 2013 7:27:36 PM UTC-6, Kartweel wrote:
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] <javascript:>.
To post to this group, send email to [email protected]
<javascript:>.
Visit this group at
http://groups.google.com/group/h2-database?hl=en
<http://groups.google.com/group/h2-database?hl=en>.
For more options, visit https://groups.google.com/groups/opt_out
<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.
--
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.
