Message to Bill Vaughn

Hello Mr. Vaughn,
I've been reading the ADO posts and answers and you seem to be very
knowledgable on the subject, so I was hoping you could help me.

I have an application that was written in VB6 several years ago, for an NT
platform. The application access both Oracle and MSAccess databases and
originally used RDO controls. The Oracle database is maintained by a third
party...not our customer.

About 1 year ago, the customer decided to put the application on a Windows
2000 platform in addition to the NT platform. Also, the 3rd Party upgrade
the Oracle database to 9i. So now the users on NT only hit the MS Access
database and the users on Windows 2000 only hit the Oracle database. All
these various scenarios worked fine with minimal changes to the software.

About 3 months ago, the developer changed the controls from RDO to ADO. The
users on the NT platform are not having any problems hitting the MS Access
database.

However, the users on the Windows 2000 platform can no longer access the
Oracle database. The magic number seems to be "64". What I mean by that is
no matter what parameters the user enters, only 64 records are returned and
then the application raises an error. When stepping through the code, the
Debug.Print statement shows the error as:

-2147217906 [Oracle][ODBC]Invalid bookmark value.

The problem seems to be the combination of Windows 2000, ADO and Oracle. In
the home office our test box is NT, ADO and Oracle 9 and we do not have a
problem hitting the Oracle database or the MS Access database.

Our next step is to upgrade the MDAC on the Windows 2000 machine from 2.5 to
2.8. Do you think this will resolve the issue? We are grasping at straws at
this point.

I am not the developer, but the lead on the project and we've been dealing
with this issue for about 2 months without any progress. Any insight you can
provide would be greatly appreciated.

Thanks,
FrustratedLead
.

Relevant Pages

  • Re: Message to Bill Vaughn
    ... sensitive as COM-based ADO. ... the customer decided to put the application on a Windows ... > 2000 platform in addition to the NT platform. ... > the Oracle database to 9i. ...
    (microsoft.public.data.ado)
  • Re: Is msado15.dll different across Windows operating systems?
    ... I need to run these projects on Windows XP, Windows Server 2003, ... Projects should be targeted to a specific version of the ADO Data Access ... then you will get ADO 2.8 Interfaces - no matter what ... MDAC or platform version the component came from. ...
    (microsoft.public.data.ado)
  • Re: A DBA philosopical question
    ... >> I didn't know Windows was possibly considered all bad. ... Oracle database servers, it is hard to believe Windows has no advantages. ... >>>Except with Apple's Xserve RAID units with their dual XOR engines ... ... > is a department that provides SA support. ...
    (comp.databases.oracle.server)
  • I need help with using Integrated Security to an Oracle DB from a Web Service
    ... Security) when connecting to an Oracle database from an XML Web Service. ... All computers are in the same Windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • I need help with using Integrated Security to an Oracle DB from a Web Service
    ... Security (Windows ... >"Machine A" is our Oracle Database server. ... >client installed and it hosts the XML Web Service. ...
    (microsoft.public.dotnet.framework.aspnet.security)