General SQL Error - 2147221164

[Timothy Jones]

Hi all,

I'm getting the above error in Delphi 4 when attempting to connect a
TDatabase component to an MS Access table. I am following the below
instructions:

Database1.DatabaseName:='tryDB';
Database1.DriverName:=MSACCESS;
Database1.LoginPromt:=false;
Database1.Params.Clear;
Database1.Params.Add('DATABASE NAME=D:\Projects\pattern.mdb');
Database1.Connected:=true;
TDBGrid.DataSource:=DataSource1;
DataSource1.DataSet:=Table1;
Table1.DatabaseName:='tryDB';

Table1.Active:=true;

Any help would be appreciated.

TIA,

TJ

[Ellen K.]

That error code in my experience is usually actually an error in your
application code, not a database error.

On Tue, 20 Jan 2004 12:11:22 +1100, "Timothy Jones"
<ti***********@team.telstra.com> wrote:

Hi all,

I'm getting the above error in Delphi 4 when attempting to connect a
TDatabase component to an MS Access table. I am following the below
instructions:

Database1.DatabaseName:='tryDB';
Database1.DriverName:=MSACCESS;
Database1.LoginPromt:=false;
Database1.Params.Clear;
Database1.Params.Add('DATABASE NAME=D:\Projects\pattern.mdb');
Database1.Connected:=true;
TDBGrid.DataSource:=DataSource1;
DataSource1.DataSet:=Table1;
Table1.DatabaseName:='tryDB';

Table1.Active:=true;

Any help would be appreciated.

TIA,

TJ

[Simon Hayes]

"Timothy Jones" <ti***********@team.telstra.com> wrote in message news:<bu**********@mws-stat-syd.cdn.telstra.com.au>...

Hi all,

I'm getting the above error in Delphi 4 when attempting to connect a
TDatabase component to an MS Access table. I am following the below
instructions:

Database1.DatabaseName:='tryDB';
Database1.DriverName:=MSACCESS;
Database1.LoginPromt:=false;
Database1.Params.Clear;
Database1.Params.Add('DATABASE NAME=D:\Projects\pattern.mdb');
Database1.Connected:=true;
TDBGrid.DataSource:=DataSource1;
DataSource1.DataSet:=Table1;
Table1.DatabaseName:='tryDB';

Table1.Active:=true;

Any help would be appreciated.

TIA,

TJ

You will probably get a better reponse in a Delphi or Access
newsgroup, but using "- 2147221164" as a search term in Google returns
numerous hits, several related to Delphi:

http://www.google.com/search?sourcei...%2D+2147221164

Simon