Hi all,
Could someone, please give me a clue about the root cause regarding the a problem with the ODBC (64-bit ) for Windows? I would like to use the ODBC driver 64-bit to postgreSQL (which I downloaded from here <http://ftp.postgresql.org/pub/odbc/versions/msi/>) to connect to a batabase in a remote server. I tried with windows 7 and windows 8, both 64-bit version. With the 32-bit ODBC driver (C:\Windows\SysWOW64\odbcad32.exe) it *works fine*, although when I try the 64-bit version, (C:\Windows\System32\odbcad32.exe) it does not work at all. When I press the 'Test' button on the 'System DNS' tab of the ODBC Data source Admin. The following error is reported: --------------------------- Connection Test --------------------------- Communication closed during authentication; Socket has been closed. --------------------------- The server address, user, database, password is correct (it works with the 32-bity version), I've also tried different versions for the 64-bit drivers, but unfortunately without success. Also tried from different machines/networks, but always with the same results. Could you please tell me where the problem could be? Is it at client side (me) or perhaps at the server side, some configurations that is blocking? The used port seems to be opened! PS: I try all the possible SSL modes, when I chose mode: none OR allow, I get the following error: --------------------------- Connection Test --------------------------- FATAL: no pg_hba.conf entry for host "<IP>", user "<USER>", database "<DB>", SSL off; Socket has been closed. --------------------------- OK --------------------------- Thanks in advance, -Rui Dias -- 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. For more options, visit https://groups.google.com/groups/opt_out.
