da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: MSAcc GetTableNames results in error

Forum List » AnyDAC » v 1.x General English

aalekizoglou
User

Fresh Boarder

Posts: 4

Karma: 0

MSAcc GetTableNames results in error

Posted: 2005/07/05 13:41

Hi,

after I connect to my MSAccess Database, I try to retrieve the TableNames using GetTableNames. This results in error

[AnyDAC][DatS]-32. Variable length column [CATALOG_NAME] overflow. Value length - [61], column maximum length - [50]

Due to my tables and queries have been named using long names.

Regards,

Athanasios Alekizoglou

Diman

Admin

Posts: 1495

Karma: 19

RE: MSAcc GetTableNames results in error

Posted: 2005/07/05 14:42

Hello !

Thank you for report. That will be fixed in next release.

Regards,
Dmitry

Diman

Admin

Posts: 1495

Karma: 19

RE: MSAcc GetTableNames results in error

Posted: 2005/07/05 15:04

Or you can fix that on your own. Open daADPhysConnMeta unit. Find there DefineMetadataStructure method. It has subprocedure Add. Write there following:

oCol.DataType := AType;
if AType = dtAnsiString then // ADD THAT LINE
oCol.Size := C_AD_MaxNameLen; // AND ADD THAT LINE
ATable.Columns.Add(oCol);

Regards,
Dmitry

aalekizoglou
User

Fresh Boarder

Posts: 4

Karma: 0

RE: MSAcc GetTableNames results in error

Posted: 2005/07/06 20:57

OK,

I've tried that. I am running on Delphi 7, AnyDAC 1.1.0.
That did not help, even thoug I had to add the C_AD_MaxNameLen constant in daADStanConst.

Nasos

Diman

Admin

Posts: 1495

Karma: 19

RE: MSAcc GetTableNames results in error

Posted: 2005/07/07 00:49

C_AD_MaxNameLen = 128 will be right.

Regards,
Dmitry

aalekizoglou
User

Fresh Boarder

Posts: 4

Karma: 0

RE: MSAcc GetTableNames results in error

Posted: 2005/07/08 13:16

OK,

That will do it.

Regards,
Nasos

Forum List » AnyDAC » v 1.x General English