Thanks, I have tried both options but not working yet. may I ask which version of ODBC-driver are you using? and what OS?
On Tue, Dec 20, 2011 at 6:47 PM, Atul Chowdhury <[email protected]> wrote: > 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. -- 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.
