Error on loading coonections in SchemaManager

Data Abstract
1

Hello,

I have DataAbstract for Delphi 7.0.69.1081
AnyDac 6.0.5

When I open schema with SchemaModeler 7 I get this error message :

[FireDAC][Stan][Def]-254, Definition [__DACD_1] is not found in []

Thanks,
Tiberiu Stoicescu

2

Hi Tiberiu,

from the first look - it seems like problem with the delphi driver (at least error message came from there) and possibly with connection string.

Unfortunately there is not enough information to guess the cause. Can you provide or simple testcase where this problem can be reproduced, or at least specify what database are you using and your connection string.

Thanks

3

I can’t use SchemaModeler 7
I am switch back to older version.

4

Hi Tiberiu,

I can admit that new Schema Modeler is not an ideal and bug-less. And I need some help from your side to make it better. Without feedback from your side it will be longer and harder to do that.

If you are still struggling with this problem above then I still waiting for your testcase or maybe more information how to reproduce this situation (for example at least the connection string).

Also let me underline here that given error leads me to suggest that this is the driver problem but not Schema Modeler.

If you are facing with other problems during using Schema Modeler please tell me.

Thanks!

5

Are you connecting via a connection definition in a connection definition file? IIRC this error occurs when a connection definition file is not found.

[__DACD_1] is not found in []
[connection] name is not found in file [filename]
Data Abstract Connection Definition _ 1 … not found in file.

Would be my guess.

6

A FireDAC/AnyDAC connection definition File of course.

7

I using Delphi XE.
I using Windows 8 profesional with UAC activated.

In server data module, in connection manager I have some connection (edited with Schema Modeler), only for design purposes.
In service data module when open schema modeler with right clik on tDASchema object, appear this error messages.

Sometime, when I close Schema modeler, schema modeler is not closing properly (main form disapear but still runing in task manager) and I need to kill with task manager.

8

__DACD_1 - Did you define this alias?

So you defined a
a) Connection in the Schema Modeler you called from external
b) When you open the Schema Modeler from within the project no connection information is found

If this is the case

I used DataAbstract once from VS for test purposes. I have the impression that either the project’s connection definition file (DA) does not contain the definition or the one schema modeler uses when started standalone. Maybe both components invoke the Schema modeler a different way. I cannot remember exactly.

Sounds like an issue for RO indeed. Please compare both file.

Accept my apologies if I am confusing things.

The Schema Modeler 7 does have some issues indeed.

9

Hello,
Thanks, the issue was logged as #63810
As a workaround please copy ADConnectionDefs.ini to SchemaModeler folder and retest it again.

10

@vovani - IIRC works as designed… There is a thread about this in the past long long ago. Maybe some people recall this. Not sure if Marc said once, ‘That would be the way to have both’. Maybe I don’t remember correctly.

11

in ADConnectionDefs.ini I have:
[Access_Demo]
DriverID=MSAcc
Database=$(ADHOME)\DB\Data\ADDemo.mdb
[SQLite_Demo]
DriverID=SQLite
Database=$(ADHOME)\DB\Data\ADDemo.sdb
LockingMode=Normal

In fDataModule.dfm

…
object ConnectionManager: TDAConnectionManager
Connections = <
item
Name = ‘CRM’
ConnectionString =
‘AnyDAC?AuxDriver=IB;Server=192.168.1.10;Database=/programare.gdb’ +
’/CRM.FDB;UserID=sysdba;Password=xxxxxx;Protocol=TCPIP;'
ConnectionType = 'Interbase’
Default = True
end
item
Name = 'ProiecteLocal’
ConnectionString =
‘AnyDAC?AuxDriver=IB;Server=192.168.1.9;Database=D:\IB.GDB\PROIEC’ +
‘TEWEB.fdb;UserID=SYSDBA;Password=xxxxxx;Charset=NONE;@Protoco’ +
'l=TCPIP;@Pooled=True;@ExtendedMetadata=True;'
ConnectionType = 'Interbase’
end>
DriverManager = DriverManager
PoolingEnabled = True
PoolTransactionBehaviour = ptCommit
Left = 552
Top = 16
end

…

I copy ADConnectionDefs.ini to
C:\Program Files (x86)\RemObjects Software\Data Abstract (Common)\Bin directory
and now the error message is:

[FireDAC][Stan][Def]-254, Definition [__DACD_1] is not found in [C:\Program Files (x86)\RemObjects Software\Data Abstract (Common)\Bin\ADConnectionDefs.ini]

Is need to define my connection in AdConnectionDefs?

12

Hello,
Can you send us your schema and connection file (.daSchema & .daConnections)? Open SchemaModeler and use ‘File->Save As’ command.
Looks like you use connecting via a AD connection definition.

13

I saved files and I send it to support@remobjects.com.

I don’t understand what is happen.
Double click on the schema file, is ok.
Close SchemaModeler 7 and open again, the error apear.

14

Hello,
We couldn’t reproduce this error with these files. They are correct.
Can you reproduce it on new project (using local PCTrade or Employee database)? If so, please send us your testcase.