Problems connecting to Postgres Database with ASP 4.02L

We are using Sun Active Server pages and must get access to a PostgreSQL database via the odbc driver.

Regardless whether I create a DSN from Sun Admin console an press "Test" button or access it DSNless via ASP script,

I do not get a connection

ASP-Script returns unspecified Error 507 and Console DSN test returns ODBC driver failed.

The {PostgreSQL} driver is the only one in the list that does not offer a version number.

PGres database is version 8, but we also tried with a 7.3 without success.

the connection to the database from the host without using SUN ASP is possible.

What must be done to make the PG ODBC driver work?

strConn ="Driver={PostgreSQL}; Server=10.10.1.10;Port=5432; Database=feedform;UID=feedform; PWD=dsfdsf"

[816 byte] By [patgwsa] at [2007-11-27 11:32:20]

# 1

I replaced the open source driver to a current one and tried some other connection string:

strConn = "Driver={Postgres}; Server=10.10.1.10;Port=5432; Database=feedform;Username=feedform; Password=dsfdfds"

system = "postgres"

Now I get:

Error Type:

ADODB.Recordset.1 (0x80004005)

/casp/dcounter/ztest.asp, line 10

when doing a select query on the DB:

strConn = "Driver={Postgres}; Server=10.10.1.10;Port=5432; Database=feedform;Username=feedform; Password=dfdfdsf"

system = "postgres"

Set objConn = CreateObject("ADODB.Connection")

objConn.Open strConn

lstrSQL = "SELECT * FROM autokennzeichen"

Set Rs = objConn.Execute(lstrSQL)

objRs.Close

Set objRs = Nothing

patgwsa at 2007-7-29 16:44:54 >

Web & Directory Servers Hot Topic