| From: | "dw_remote" <dw_remote(at)excite(dot)com> |
|---|---|
| To: | pgsql-questions(at)postgreSQL(dot)org |
| Subject: | ODBC Connection problem |
| Date: | 2000-01-26 20:31:28 |
| Message-ID: | AQIj4.17801$rY2.8905827@news1.rdc1.on.wave.home.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott V. McGuire | 2000-01-26 21:45:17 | scaling |
| Previous Message | Peter Bojanic | 2000-01-26 20:30:29 | Help understanding how indexes are used by the query optimizer |