I am having an issue where i have a asp page connecting to a database being successful on the first connect but failing on any attempt after that.
The following is the message I get:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Unspecified error
/Test1.asp, line 13
The following is the code I use:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/db_main.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_db_main_STRING
Recordset1.Source = "SELECT * FROM informix.xx_rec WHERE id=1"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<table width="75%" border="1">
<tr>
<th>ID</th>
<th>NAME</th>
<th>SSN</th>
</tr>
<tr>
<td><%=(Recordset1.Fields.Item("id").Value)%></td>
<td><%=(Recordset1.Fields.Item("fullname").Value)% ></td>
<td><%=(Recordset1.Fields.Item("ss_no").Value)%> </td>
</tr>
</table>
</body>
</html>
<%
Recordset1.Close()
Set Recordset1 = Nothing
%>
The error seems to be occurring on the Recordset1.Open() line of code.
Any help would be greatly appreciated
dBforums
>
Problem with recordset opening
03-26-04, 10:38
Linear Mode
