Actually, my buddy just reviewed my log files and suggested exactly that -- set it up as a PostgreSQL server. I'll post details if it gets anywhere... (shouldn't be long)
On Sun, Feb 17, 2013 at 10:26 PM, Ryan How <[email protected]> wrote: > 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 h2-database...@**googlegroups.com. >> To post to this group, send email to [email protected]. >> 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. > > > -- 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.
