Home » Infrastructure » Windows » 2147467259 -----[Microsoft][ODBC driver for Oracle]General error
2147467259 -----[Microsoft][ODBC driver for Oracle]General error [message #128359] Mon, 18 July 2005 03:14
sujitgaonkar
Messages: 1
Registered: July 2005
Location: India
Junior Member
Kindly Help
I am connecting to ORACLE using ASP with a DSN conection.
I am retriving 2 columns from a single table (less than 7000 records) and displaying it in a drop down but after filling the drop down with 600 - 700 records it gives this error "2147467259 -----[Microsoft][ODBC driver for Oracle]General error " and stops execution.
cn.Open "dsn=solves;uid=pms;pwd=pms"
Set rscomp=Server.CreateObject("Adodb.recordset")
rscomp.Open sql,cn,adOpenDynamic,adLockOptimistic
<%
if not rscomp.EOF then%>
<SELECT name=compselect style="HEIGHT: 22px; WIDTH: 225px">
<option Value="ALL">ALL</option>
<%do while not rscomp.EOF%>
<OPTION value="<%=rscomp(0)%>"><%=rscomp(1)%> </OPTION>
<%
If err.number<>0 Then Exit Do
rscomp.MoveNext
loop
rscomp.Close
cn.close
%>
</SELECT>&nbsp;&nbsp;&nbsp;<input type=button name="GenReport" value="Generate Report" onClick="CompanySubmit()"></P>
<%
If err.number <> 0 Then
Response.Write err.number & " -----" & err.Description
End if
else
Response.Write "<h3> No records found</h3>"
end if
%>
Previous Topic: Oracle Insert with sequence via ODBC MS Access
Next Topic: installing oracle 9i on windows XP professional
Goto Forum:
  


Current Time: Thu Mar 28 21:25:46 CDT 2024