Hi all,
I'm trying to connect to a remote PostgreSQL 8.3.4 server on
Debian 4.1.1 (32 bit) using this:
handle = SQLSTRINGCONNECT("DRIVER=PostgreSQL
ANSI(x64),UID=xxxxx,PWD=xxxxx,DATABASE=xxxxx,SERVER=xxx.xxx.xxx.xxx")
I's returning -1. If I use pgAdmin III 1.12.1 with these values I can
connect OK. This string is the same (well, sort of., read on) used by my app
installed at my customer's site where dozens of clerks every day input a lot
of data. Now they want some changes in some forms, so I'm trying to restore
the environment on my PC. Recently I switched to Win 7 Pro 64 bit, so
installed the new PostgreSQL 9.0.1 64 bit, and psqlODBC 9.0.1 64 bit.
The '(x64)' part in DRIVER parameter is the only thing different from what
they use. And is what I suspect is the culprit here. Can I connect from a 64
bit driver to a 32 bit server? And if I can't, am I forced to install a 32
bit PostgreSQL release with a 32 bit psqlODBC driver on my 64 bit OS to be
able to connect? And in this case, should this be an old 8.x release or a
recent 9.x one?
Thanks to the kind souls who'll want to shed some light on this. ;o)
Iames
--
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP
autenticato? GRATIS solo con Email.it http://www.email.it/f
Sponsor:
Prova subito Emailpaghe, e' in prova gratuita sino al 31 dicembre 2010
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=10679&d=14-12
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
