Problems connecting to PostgreSQL...

[Echo15]

Hi!

I'm trying to make a VB app that connects to a PostgreSQL database. I used the postgres ODBC driver but I get an error when trying to open the connection...

My codes are:

sConnection = "Driver={PostgreSQL};PWD=" & sOraclePwd & ";UID=" & _
              sOracleUser & ";Server=" & sServerName & ";" & "Database=tfm;"
adoConnect.CursorLocation = adUseClient
adoConnect.Open sConnection
MsgBox "Ok"

I get the error in the adoConnect.Open line. The error is description is:
Run-time error '.......':
blank


Any help would be appreciated...

[Echo15]

Hi!

Got it to work now... Just needed to upgrade my PostgresODBC driver...

[PLIFF]

Hi!

Got it to work now... Just needed to upgrade my PostgresODBC driver...

Hey I need to connect VB with postgres I'll apreciate some help you can give to me,
I have Postgres 8.1 already installed but seems to be wrong drivers, tell me what I need to be connected. TKS