General SQL error...URGENT

[RedOne]

In my system with BCB3 and upgraded BDE, my db program works fine.
It uses MSACCESS driver and becouse I dont want to use MSAccess97,
I installed the latest MDAC. I created setup package with ISX. On the target
computer there was BDE, the old version or upgraded one. After installation
I configured BDE alias for my program and launched it, but it raises error
'General SQL error: -2...(large negative number)'. Probably at
database/table
activation. I reinstalled BDE 5.01 and 5.11 upgrades. The error didnot
disappear.
Reinstalled MDAC. The same problem.
Help!

[Steve Koterski]

Neither the BDE nor C++Builder generate big negative numbers for error
codes. That is a hallmark characteristic of Microsoft Access. What
does the Microsoft documentation for Access (or their developer
support or their newsgroup) say about their error code?

In changing to a later version of MDAC, did you also change the
Jet/DAO engine? Like to that for Access 2000? If so, you cannot use
the native BDE driver, which has not been updated for Access 2000. To
use Access 2000 databases (or the corresponding data engine) from
C++Builder, you would need to use either an ODBC driver compatible
with Access 2000 or ADO.

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\
Steve Koterski "If you aren't fired with
Technical Publications enthusiasm, you will be
Borland fired with enthusiasm."
-- Vince Lombardi (1913-1970)

[Jeff Overcash (TeamB)]

Borland has a FAQ on this at
http://www.borland.com/devsupport/bde/faq/FAQ2B.html. MS moved the link in that
FAQ and Borland hasn't had a chance to update the link yet. Here is the updated
link

http://support.microsoft.com/support/kb/articles/Q141/2/94.asp

RedOne wrote:
>
> In my system with BCB3 and upgraded BDE, my db program works fine.
> It uses MSACCESS driver and becouse I dont want to use MSAccess97,
> I installed the latest MDAC. I created setup package with ISX. On the target
> computer there was BDE, the old version or upgraded one. After installation
> I configured BDE alias for my program and launched it, but it raises error
> 'General SQL error: -2...(large negative number)'. Probably at
> database/table
> activation. I reinstalled BDE 5.01 and 5.11 upgrades. The error didnot
> disappear.
> Reinstalled MDAC. The same problem.

> Help!

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
If there is somebody up there could they throw me down a line. Just a
little helping hand just a little understanding. Just some answers to the
questions that surround me now. If there's somebody up there could
they throw me down a line. (Fish)

[RedOne]

I thought that MDAC 2.1 contains all things neccessary to work
with MsAccess tables. I looked to client machine where
I installed MDAC and didnt find DAO folder. But in my machine
where I dont have MSOffice/Access, this folder exists. I thought
that it was created by MDAC, but this is wrong. Maybe some 3rdpraty
program installed DAO in my machine. So I simply copied DAO
folder to client machine and it seems now BDE's MSACCESS driver
works. It seems the native driver has a noticeable speed advantage
over ODBC/BDE cooperation.

Thanks all