Which version of Postgresql works on windows 7

Use this forum for questions and answers regarding PostGreSQL and the PGDBE.
Message
Author
User avatar
Tom
Posts: 1198
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Which version of Postgresql works on windows 7

#11 Post by Tom »

Add:

The PGDBE uses the libpq.dll as the interface to the PostGreSQL server. Alaska currently ships libpqex.dll version 14/devel with Xbase++, which in my opinion needs PostGreSQL server 12 or later.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
unixkd
Posts: 575
Joined: Thu Feb 11, 2010 1:39 pm

Re: Which version of Postgresql works on windows 7

#12 Post by unixkd »

Hi Slavko

I appreciate everyone on this platform and has always been grateful.

It must have been an oversight for not offering you thanks for your help not deliberate. So many thanks.

Now another help request.

I use sqlexpress which uses odbc and fine for me despite some limitations in dcbrowse compatibility.

I install ADS 64bit server on my system and it works fine with my xbase++ application that is a 32bit application.

Can postgres 64bit also work with xbase++ 32bit app.

Thanks

Joe

k-insis
Posts: 117
Joined: Fri Jan 28, 2011 4:07 am

Re: Which version of Postgresql works on windows 7

#13 Post by k-insis »

Yes you can talk to and work with any 64bit server on any server/cpu platform as long you have 32bit ODBC driver.


I can confirm Xbase + SqlExpress works just fine with 32bit ANSI PostgreSQL driver to 64bit server.

connect string for sqlexpress and postgresql:

//with SSL mode ON (you really should use)
cOdbcC := "DSN=%DSNCONTROLPANEL%;DATABASE=%NAMEOFDB%;SERVER=%HOST%;PORT=5432;UID=%USERNAME%;PWD=%SUPERSECRETPASSWORD%;CA=d;A6=;A7=100;B0=2048;B1=8190;BI=0;C2=dd_;CX=1c205008b;A1=7.4;sslmode=require"

%-----% is one string, linux hosts are all case sensitive for database names


> some limitations in dcbrowse compatibility

Which limitations exactly?



unixkd wrote: Thu Oct 10, 2024 3:41 am Hi Slavko

I appreciate everyone on this platform and has always been grateful.

It must have been an oversight for not offering you thanks for your help not deliberate. So many thanks.

Now another help request.

I use sqlexpress which uses odbc and fine for me despite some limitations in dcbrowse compatibility.

I install ADS 64bit server on my system and it works fine with my xbase++ application that is a 32bit application.

Can postgres 64bit also work with xbase++ 32bit app.

Thanks

Joe

Post Reply