Programming with dBASE - BDE 5.2.0.2 problem??

Author

BDE 5.2.0.2 problem??

Tony Martin

2005-05-11, 7:23 am

Hi,

I need to exchange data between Dbase Plus, VB6 and VB.net applications
running simultaneously.

I've been able to do this successfully using the VB ADODB data provider and
the BDE V5.2.02 (running on Win XP Pro).

I just upgraded to Win XP Pro Service Pack 2 and what now seems to happen
is:

1. If have opened a .dbf table in dBase Plus and then invoke one of the VB
apps to read the data, the VB app refuses to open a recordset (complaining
about the external data provider). This happens even after closing the
table in dBase Plus. If dBase Plus has not previously opened the table, the
VB app opens the recordset fine.
It does not matter what method I use to open and close the data in dBase (I
have tried xBase, query objects and straight SQL select statements).

2. If a VB app opens a .dbf table (by creating an ADODB recordset), and
then I try to open the same table in dBase Plus, the BDE returns the error
"Cannot load driver". The BDE is using the native dBase driver - no ODBC
involvement.

I can run the same routines using a dBase 5.7 app with the old BDE (also
running on XP Pro SP2) with no problem.

I have the BDE configured for Local Share set to True. Is there some BDE
config problem I haven't spotted?

Thanks in advance for any help.

Tony Martin

*Lysander*

2005-05-11, 7:23 am

In article <4UWdrbhVFHA.444@news-server>, ajm@pnc.com.au says...

> I have the BDE configured for Local Share set to True. Is there some BDE=
=20
> config problem I haven't spotted?

Do you have any filemonitor (for example filemon by sysinternals) to=20
check, which driver cannot be loaded?
Sounds to me like both applications are using a *.dll as a driver, but=20
because every driver can be used only once system-wide there will be=20
conflict if the drivers have the same name, but not the same functions.
=20

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~
European dBase-conference dBKonEurope on June 3rd and 4th
English spoken conference around different database-topics
::
Info here: www.dbkon.org

Tony Martin

2005-05-11, 9:23 am

Thanks Andre,

I think you're right - there must be a driver conflict. More testing
reveals that if dBase Plus opens any file (engages the driver), the VB apps
can't access anything and vice versa.

I don't know which drivers are conflicting. I will try to find out which
drivers the various apps are trying to use.

Thanks again for you help.

Tony

Sponsored Links