It was the BDE driver.
Cheers
Myles Penlington wrote:
> 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
--
John Mason
Sinclair Knight Merz Limited
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
