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.Datab aseName:='tryDB ';
Database1.Drive rName:=MSACCESS ;
Database1.Login Promt:=false;
Database1.Param s.Clear;
Database1.Param s.Add('DATABASE NAME=D:\Project s\pattern.mdb') ;
Database1.Conne cted:=true;
TDBGrid.DataSou rce:=DataSource 1;
DataSource1.Dat aSet:=Table1;
Table1.Database Name:='tryDB';

Table1.Active:= true;

Any help would be appreciated.

TIA,

TJ

[Ellen K.]

Re: General SQL Error - 2147221164

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"
<timothy.jones@ team.telstra.co m> wrote:
[color=blue]
>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.Data baseName:='tryD B';
>Database1.Driv erName:=MSACCES S;
>Database1.Logi nPromt:=false;
>Database1.Para ms.Clear;
>Database1.Para ms.Add('DATABAS E NAME=D:\Project s\pattern.mdb') ;
>Database1.Conn ected:=true;
>TDBGrid.DataSo urce:=DataSourc e1;
>DataSource1.Da taSet:=Table1;
>Table1.Databas eName:='tryDB';
>
>Table1.Active: =true;
>
>Any help would be appreciated.
>
>TIA,
>
>TJ
>
>[/color]

[Simon Hayes]

Re: General SQL Error - 2147221164

"Timothy Jones" <timothy.jones@ team.telstra.co m> wrote in message news:<buhv7a$cj 1$1@mws-stat-syd.cdn.telstra .com.au>...[color=blue]
> 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.Datab aseName:='tryDB ';
> Database1.Drive rName:=MSACCESS ;
> Database1.Login Promt:=false;
> Database1.Param s.Clear;
> Database1.Param s.Add('DATABASE NAME=D:\Project s\pattern.mdb') ;
> Database1.Conne cted:=true;
> TDBGrid.DataSou rce:=DataSource 1;
> DataSource1.Dat aSet:=Table1;
> Table1.Database Name:='tryDB';
>
> Table1.Active:= true;
>
> Any help would be appreciated.
>
> TIA,
>
> TJ[/color]

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?sourceid=navclient&ie=UTF-8&oe=UTF-8&q=%2D+2147221164

Simon