Connect to PostgreSQL

Posted 2010-07-08 08:32
by tenh
in the Postgre SQL Forum

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

Reply 2010-08-03 12:21
by Max Wikström
in the Postgre SQL Forum

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!