In the documentation it says: >>To improve performance, please enable 'server side prepare' under Options / Datasource / Page 2 / Server side prepare.
However, with this setting I encountered errors. When I did NOT enable this setting, my connectivity worked OK. YMMV - good luck. On Tue, Dec 20, 2011 at 9:56 AM, Behrang QasemiZadeh <[email protected]>wrote: > Hi, > > I am trying to access H2DB via an ODBC connection. I followed the > given instruction under the adavanced tab of user guide and set up a > PostgreSQL driver 9.00.03.10 and got successful connection to H2DB. > However, I cannot access the content of H2DB from MSAccess and > Win-Prolog ODBC Tool. MSAccess says : The specified DNS contains an > architecture mismatch between Driver and Application(#0). The > win-prolog tool lists the H2DB connection however connection attepms > are replied by Database Interface Error. > > Sould I use another ODBC driver to solve this problem, or is there any > other details that I should take care after beside the available > documentation? > > I have looked up into mailing list but could not find an answer. > > Your help is much appereciated. > > Cheers > > Behrang > > -- > 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. > > -- 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.
