| 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> <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
%>
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
