Connect to PostgreSQL

Dear All,

I am a new user in PostgreSQL dabase. I have problem with my connection to PostgreSQL. When i connected i see the message below:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/testcon.asp, line 4

This is my code for connect to PostgreSQL :

set connMember = server.createobject("ADODB.Connection")
strCnm = "Driver={PostgreSQL}; Server=; Port=5432; Uid=usersql; Pwd=webp@ss; database=milk;"
connMember.Open strCnm

What is my wrong code?
How can i solve this error message?
Hope to see your answer as soon as you can.

You can send me back the solution by my email :

Thank you

1 answer

This is a very generic error message and can be caused by many factors.

Did you install the driver on the server running the code?

Oh I can see now that this post was a bit old... did you solve the problem? If so, Please share!