Re: Message to Bill Vaughn
- From: "William \(Bill\) Vaughn" <billvaNoSpam@xxxxxxxxx>
- Date: Sat, 4 Jun 2005 09:37:22 -0700
Welcome to the world of DLL hell. RDO is an interface to the ODBC API and
while subject to some of the vagarities of DLL swapping is not nearly as
sensitive as COM-based ADO (what we call ADO classic). First let me say that
I'm flattered that you addressed me directly, but let me also say that I
don't work with Oracle anymore--not since the 70's when they burned their
bridges with me. However, I suspect that you can stabilize the situation by
using the most recent drops of the MDAC stack. 2.5 is far from bug free and
while far better than 2.1, it's best to move to 2.8. See
www.microsoft.com/data. I would also consider using the OLE DB provider for
Oracle instead of ODBC in this case--it might be more stable as well. If
you read the trade rags you'll have seen that MS is going to stop
distributing loose MDAC downloads as the stack is built into the OS and
upgrades should (only) be done via Windows Update. Use Component Checker
(same source) to test the version of the stack you have loaded.
In the long run you're going to want to switch to .NET and ADO.NET which
eliminates the need for the MDAC stack (in version 2.0) and can further
stabilize the situation. Of course, this won't be a trivial task, but many
have found the result is well worth the effort.
hth
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
www.sqlreportingservices.net
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"FrustratedLead" <FrustratedLead@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C290685B-4FC3-42C4-9A41-9763FB8B9688@xxxxxxxxxxxxxxxx
> 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
.
- References:
- Message to Bill Vaughn
- From: FrustratedLead
- Message to Bill Vaughn
- Prev by Date: Re: ADO & SQL Server.
- Next by Date: Re: MDAC on Win2k3 SP1
- Previous by thread: Message to Bill Vaughn
- Next by thread: MDAC on Win2k3 SP1
- Index(es):
Relevant Pages
|
