Ideas,
a. Are you using the right BDE driver? (Access97 verus Access95 - BDE
defaults to access95) - Native or ODBC?
b. On the BDE I remember I had to set up the access security Database when
using the Native driver, else got funny errors - can't remember if it was
this one.
Myles.
> -----Original Message-----
> From: Mason, John [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 13, 2000 10:03 AM
> To: Multiple recipients of list database
> Subject: [DUG-DB]: General SQL error?
>
>
> I am getting a "General SQL error -2147221164" on a Win95 station when
> running simple program. The same program runs fine on my WinNT station
> which has Delphi5 installed. Does anybody know what might cause this
> error?
>
> The program uses an Access 97 database to verify data. I have
> a Database
> component with the Aliasname property set to a BDE alias, and
> the Access
> username and password defined in the Params property. The Table
> component has the same databasename property as the Database
> component.
> The program was running ok before I introduced the Database
> component (
> which I added so I could set the password at design time).
>
>
> tia
> --
> John Mason
> Sinclair Knight Merz Limited
>
>
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
