Hi, Could you check the .trace.db file in H2? If you don't see a problem, could you enable the trace option in the H2 database? To do that, append the argument -trace when starting the PgServer. See also http://www.h2database.com/javadoc/org/h2/tools/Server.html - Maybe there is a statement that H2 doesn't understand.
Regards, Thomas On Thu, May 21, 2009 at 10:59 AM, Kartweel <[email protected]> wrote: > > Hi, > > I've been having trouble getting Microsoft Access to work as a front > end using the postgresql odbc driver. I can connect and view the > tables, but when linking a table it comes up Reserved error (-7747). > I've googled it but can't find anything. > > What I am wondering has anyone successfully used this combination? and > If so what version of H2 and ODBC driver? > > I am running H2 1.1.109 and psqlodbc 08_04_0300. > > I can import tables into Excel successfully with no problems, so it is > working partially, it is just Access giving me issues. > > I've set H2 to run on port 5432 as you cannot change the port number > in the odbc driver settings using the GUI. I've tried changing lots of > settings in the ODBC driver but nothing seems to make any difference. > > Many Thanks, > > Ryan > > > > --~--~---------~--~----~------------~-------~--~----~ 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] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
