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=20.3.10.100; 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 : toeurtenh@gmail.com

Thank you
Tenh

1 answer