Re: ADO recordset, Oracle and Windows2000
- From: "Uwa Agbonile [MSFT]" <uwaag@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 31 May 2005 13:49:07 -0700
What is the version of the Oracle client utilities you have on the machine
that works and on the machine that doesn't? You might want to try using the
same Oracle client version on both. If you are using the Microsoft OLEDB
provider for Oracle, then I would suggest you use either the Oracle 7 or 8
client because there are some known issues with the Oracle 9 client.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Regards,
Uwa Agbonile[MSFT]
"FrustratedLead" <FrustratedLead@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:170273BC-079B-4B98-BA0B-3AC17C6BBF49@xxxxxxxxxxxxxxxx
> 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
.
- References:
- ADO recordset, Oracle and Windows2000
- From: FrustratedLead
- ADO recordset, Oracle and Windows2000
- Prev by Date: Re: Read from one, write into another data source
- Next by Date: Re: tutorials or links
- Previous by thread: ADO recordset, Oracle and Windows2000
- Next by thread: SQLSummit.com catalog of drivers and data providers (ODBC, OLE DB, .NET, etc.)
- Index(es):
Relevant Pages
|
|
