I am trying to connect from a Web server( MS personal Webserver ) running on
a Win95c PC via ODBC ( Insight v6.40.0007) to a LINUX (Redhat 5.2) system
running PostgreSQL 6.5.3.
I have tested the ODBC Connection with MS-Access and it works fine.
The problem is that I keep getting an error returned to the browser:
---------------
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
/test.asp, line 23
---------------
Here is the code where
LINUX server name = misha
Database name = postgres
Username = postgres
System DSN = PostgreSQL
---------------
<%@ LANGUAGE="VBSCRIPT" %>
<%
option explicit
Session("admin_ConnectionString") = "DRIVER={PostgreSQL};" & _
"SERVER=misha;UID=postgres;PWD=;APP=Microsoft (R) Developer Studio;" & _
"WSID=;DATABASE=postgres"
Session("admin_ConnectionTimeout") = 15
Session("admin_CommandTimeout") = 180
Session("admin_RuntimeUserName") = "postgres"
Session("admin_RuntimePassword") = ""
'Set Data environments
dim admin
dim Admin_cmd_Temp
dim Admin_RS
Set admin = Server.CreateObject("ADODB.Connection")
admin.ConnectionTimeout = Session("admin_ConnectionTimeout")
admin.CommandTimeout = Session("admin_CommandTimeout")
admin.Open Session("admin_ConnectionString"),
Session("admin_RuntimeUserName"), Session("admin_RuntimePassword")
Set Admin_cmd_Temp = Server.CreateObject("ADODB.Command")
Set Admin_RS = Server.CreateObject("ADODB.Recordset")
Admin_cmd_Temp.CommandType = 1
%>
<%
Admin_cmd_Temp.CommandText = "select id, name from test"
Set Admin_cmd_Temp.ActiveConnection = admin
Admin_RS.Open admin_cmd_Temp, ,1,2
%>
<html>
<head>
<title>testing</title>
</head>
<body>
<%do while not admin_rs.eof%>
<%=admin.rs("id")%>
<%Response.Write("<BR>")%>
<%=admin.rs("name")%>
<%loop%>
</body>
</html>
---------------
- Dave