Hmm...I've since deinstalled that configuration. I recall having to try a few versions. Let me try to dig up that config - give me a day or so ...
On Tue, Dec 20, 2011 at 5:05 PM, Behrang QasemiZadeh <[email protected]>wrote: > 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. > > -- 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.
