MS Access data problem on Vista

[BH]

I created an app with BCB 5 that uses an Access 2000 db. The app runs as
expected on XP, but returns the following when I try to run it on Vista:

General SQL error.
Out of Memory.
Alias
Alias: MyAlias.

I've tried several configs in the bdeadmin, but still get the error. What
could be causing this issue? Any and all ideas would be appreciated.

[Bob Swart]

Hi BH,

Post by BH
I created an app with BCB 5 that uses an Access 2000 db. The app runs as
General SQL error.
Out of Memory.
Alias
Alias: MyAlias.

Alias? You're not using the BDE to "access" your Access 2000 db, are
you? I would expect that you use dbGo for ADO (or ADOExpress as the name
still is in C++Builder 5).

Post by BH
I've tried several configs in the bdeadmin, but still get the error. What
could be causing this issue? Any and all ideas would be appreciated.

Could you please confirm if you are using the BDE (which is generally an
issue on Vista) or ADO to work with your Access 2000 db.

Groetjes,
Bob Swart

[BH]

I created the app with BCB5 Professional (no ADO). I have a User DSN set up
in Windows ODBC Administrator for the Access 2000 db. The Database Name
property for the TTable and TQuery components in the app all point to the
User DSN.

Post by Bob Swart
Hi BH,

Post by BH
I created an app with BCB 5 that uses an Access 2000 db. The app runs as
General SQL error.
Out of Memory.
Alias
Alias: MyAlias.

Alias? You're not using the BDE to "access" your Access 2000 db, are you?
I would expect that you use dbGo for ADO (or ADOExpress as the name still
is in C++Builder 5).

Post by BH
I've tried several configs in the bdeadmin, but still get the error.
What
could be causing this issue? Any and all ideas would be appreciated.

Could you please confirm if you are using the BDE (which is generally an
issue on Vista) or ADO to work with your Access 2000 db.
Groetjes,
Bob Swart
--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml

[Bob Swart]

Hi BH,

Post by BH
I created the app with BCB5 Professional (no ADO). I have a User DSN set up
in Windows ODBC Administrator for the Access 2000 db. The Database Name
property for the TTable and TQuery components in the app all point to the
User DSN.

OK, so you are still using the BDE (ODBC through the BDE, right?).

In that case, if you get an "Out of Memory" error, try increasing the
SHAREDMEMSIZE (using the BDE Administrator tool), for example:

SHAREDMEMSIZE to 16384 (on a 1GB machine)
SHAREDMEMSIZE to 60000 (on a 2GB machine)
MAXBUFSIZE to 20480
MAXFILEHANDLES to 128

Groetjes,
Bob Swart

[BH]

Bob,

The machine shows 1.8 GB RAM. I tried the settings you suggested for the 1
and 2 GB setups and still get the same errors. I installed an earlier
version of the program that uses Paradox tables and it works as expected
with either setting, but I would still like to get the Access version
working.

Post by Bob Swart
Hi BH,

Post by BH
I created the app with BCB5 Professional (no ADO). I have a User DSN set
up in Windows ODBC Administrator for the Access 2000 db. The Database
Name property for the TTable and TQuery components in the app all point
to the User DSN.

OK, so you are still using the BDE (ODBC through the BDE, right?).
In that case, if you get an "Out of Memory" error, try increasing the
SHAREDMEMSIZE to 16384 (on a 1GB machine)
SHAREDMEMSIZE to 60000 (on a 2GB machine)
MAXBUFSIZE to 20480
MAXFILEHANDLES to 128
Groetjes,
Bob Swart
--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
CodeGear Technology Partner -- CodeGear RAD Studio Reseller (BeNeLux)
Blog: http://www.drbob42.com/blog - RSS: http://eBob42.com/weblog.xml