Matthew,
thanks for your post. I've changed something in my env, i.e. got rid
of PG 64 bit and psqlODBC 64 bit. Now I have them installed in their 32 bit
flavours. (NOTE: in my previous string there were "," instead of ";" as
separators for the parameters, but it was my mistake during the writing of
my original post, not in the string passed to the server). The real string
I'm using is:
handle = SQLSTRINGCONNECT("DRIVER=PostgreSQL
ANSI;UID=xxxxx;PWD=xxxxx;DATABASE=xxxxx;SERVER=xxx.xxx.xxx.xxx")
I noticed the "{}" in the DRIVER section, but it doesn't seem to
make any difference when I use them or not (my app running at my customer's
site doesn't use it). And so is the PORT parameter, since the default port
in PG is 5432.
I've created a Data Source with these values, AND IT WORKS!!! (with
SQLCONNECT(<datasourcename>)). So there's something wrong in that string I
don't see. Weird! If someone has some ideas to share, fire away! ;)
TIA
Iames
-----Messaggio originale-----
Da: [email protected] [mailto:[email protected]] Per conto di
Jarvis, Matthew
Inviato: martedì 14 dicembre 2010 18:05
A: [email protected]
Oggetto: RE: VFP 9.0 SP2: problem connecting to PostgreSQL 8.3.4 on Debian
4.1.1(32 bit)
> -----Original Message-----
> From: [email protected]
[mailto:[email protected]]
> On Behalf Of Iames Pizzoli
> Sent: Tuesday, December 14, 2010 2:13 AM
> To: [email protected]
> Subject: VFP 9.0 SP2: problem connecting to PostgreSQL 8.3.4 on Debian
> 4.1.1(32 bit)
> 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'm not real familiar with what it is you are actually doing, but I poked
around and came up with some possible ideas.
Looking at the connection string options at:
http://www.connectionstrings.com/postgre-sql
I see for the ANSI option this:
ANSI
Driver={PostgreSQL ANSI};Server=IP
address;Port=5432;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
I notice that in your example you don't list the Port and the ordering
(important??) is different.
Sorry but that's all I got...
--
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:
Emailpaghe: le paghe in 3 click, veloce ed efficiente puoi averlo in prova
gratuita fino al 31 dicembre 2010. Cosa aspetti provalo!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid681&d-12
_______________________________________________
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.
