Hello, I am trying to do some preliminary legwork for a possible upcoming project that would include me connecting to a PSQL DB (Windows version (possibly on another physical server)) from a webserver (again Windows Server) that is running Apache and PHP.

Is this setup even possible?

It's possible. You'll need to use ODBC from PHP to access PSQL. It'll work locally or remotely.

Thank you for the reply. So, I am thinking that I would install PSQL client on the webserver then reference the pervasive driver using odbc_connect in PHP.

I started looking for the exact syntax to use to accomplish this and I found this thread: [PHP] odbc_connect always returns error IM002 - Pervasive Community Site

However, I cannot see the entire post. It seems to chop off the end of the string:

"$conn=odbc_connect("Driver={Pervasive ODBC Client Interface};ServerName"

What is the rest of the connection string?

The line in one of my posts was:
I was able to copy it even though it wasn't displayed.


You can always just create a Client DSN on the webserver and use that instead of the connection string.