Problems connecting to PostgreSQL...

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:

Code:

---

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...

Hi!

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

Quote:

---

Originally Posted by Echo15

Hi!

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

---

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