ADO recordset, Oracle and Windows2000
- From: "FrustratedLead" <FrustratedLead@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 27 May 2005 13:57:44 -0700
I manage a project that has an application written in VB6. It was originally
developed for an NT platform, but has been residing on Windows 2000 Pro for
several months now. There have been no problems connecting to and retrieving
data from the Oracle 9i database.
Just recently, the developer changed the app so that it now uses ADO
controls (it was using RDO). When stepping through the code we found that
the initial query is only retrieving "64" records, no matter what parameters
are put in the SQL statement. And when it gets to the "rs.MoveNext"
statement, an error is raised that states:
-2147217906 [Oracle][ODBC]Invalid bookmark value.
Here are portions of the source code:
***********
Public ActiveConn as New ADODB.connection
Dim rs as New ADODB.recordset
NotamSQL = "select * from notam_view where NOTAM_ORIGIN_DTG >=
'200526051200' and NOTAM_ORIGIN_DTG < '200526051300' order by NOTAM_ID"
rs.Open NotamSQL, ActiveConn, adOpenKeyset
************
The exact same code (with the ADO controls) works fine on the WindowsNT
platform. We have tried everything including replacing DLLs on the 2000
machine, but nothing has solved the problem.
Does anyone know...what are we missing/not seeing with regard to the ADO
controls?
Thanks,
FrustratedLead
.
- Follow-Ups:
- Re: ADO recordset, Oracle and Windows2000
- From: Uwa Agbonile [MSFT]
- Re: ADO recordset, Oracle and Windows2000
- Prev by Date: Re: Connection object question
- Next by Date: Re: ADO connectstring for SQLServer not port 1433
- Previous by thread: Gets error message "Could not lock file"
- Next by thread: Re: ADO recordset, Oracle and Windows2000
- Index(es):
Relevant Pages
|
|
