Обсуждение: Win 7 x64 odbc call failed

Hello postgres odbc users
I'm in trouble using Access 2013 and postgresql server.
My new laptop is a windows 7 professional 64bit and I have microsoft office
2013.
I want to connect a postgresql 9.1.13 It's a Debian server with postgres
onboard

select version() get this answer
"PostgreSQL 9.1.13 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.2-5) 4.7.2, 64-bit"

I tried to install many version of postgres odbc drivers from the postgres
site both x64 and x32.
I can correctly create both user and system connection and if I tri to test
the connection I get an affermative result, connection as reported by the
odbc administrative tool is ok.

My problem arises from the microsoft office 2013.
If I try to open a previous created db (office 2003 mdb) or a new empty db
created on the 2013 version I can't connect to the postgres server, I get a
message saying "call failed" (chiamata non riuscita in Italian language).

How can I solve this problem (don't tell me to use openoffice or linux, I
wish, but my laptop is not my own laptop..)

Thanks everybody
Pietro






--
View this message in context: http://postgresql.1045698.n5.nabble.com/Win-7-x64-odbc-call-failed-tp5821084.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.

Ok I found a solution by myself..

Obviously working in windows 64 bit, connecting a server debian 64bit i MUST
use the 32bit version of the postgres odbc drivers... Windows rocks!
So I had to install the 32bit version (psqlodbc_09_03_0210.zip)
And then launch the 32bit ODBC tool (the one you find in the control panel
is 64 bit and don't recognize the 32 bit drivers..) by this command

c:\windows\syswow64\odbcad32.exe

Then I can add a connection using the 32bit drivers and M$Access 2013 on
winz_x64 can connect to the 64bit postgresql server..

bye



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Win-7-x64-office-2013-odbc-call-failed-tp5821084p5821087.html
Sent from the PostgreSQL - odbc mailing list archive at Nabble.com.