feap file as ODBC source

[ngong]

From Sparx for EA16 I can download the EABase1558.feap file.
It is an empty EA repository and Firebird database file that I can open with EA16.
Selecting it in Win10 as an  ODBC Source (File DSN),  for the connetion string, I am asked for a User/Password/Role.

Any idea what to enter there?

Entering nothing does not create the connections. Also SYSDBA/masterkey does not work.

[Paolo F Cantoni]

From Sparx, for EA16, I can download the EABase1558.feap file.
It is an empty EA repository and Firebird database file that I can open with EA16.
Selecting it in Win10 as an  ODBC Source (File DSN),  for the connection string, I am asked for a User/Password/Role.

Any idea what to enter there?

Entering nothing does not create the connections. Also, SYSDBA/masterkey does not work.

Hi Rolf,
To get around this issue if you don't get the correct user/password is to get into the DB by some means and delete the User security row in t_secpolicies.  THis will allow you to get in and then you can reenable User security with your new user/password.

HTH,
Paolo

[qwerty]

Try admin/password

q.

[ngong]

@qwerty Does not work
@paolo what other means than ODBC is possible to access a firebird DB in a file? Using the default admin SYSDBA/masterkey does not work, either.

[qwerty]

Have you tried Google for "firebird db viewer"?

q.

[Paolo F Cantoni]

@qwerty Does not work
@paolo what other means than ODBC is possible to access a firebird DB in a file? Using the default admin SYSDBA/masterkey does not work, either.

Sorry, Rolf,
I don't know much about Firebird files.  I agree with qwerty about Googling.

Paolo

[ngong]

For now, I have chosen to stay away from .feap files.
Also, it seems to be true, that LemonTree cannot handle .feap files.
Next time I will try to access a .qea file from Dbeaver. Maybe I have more luck with that one.
Or, I will find a way to do feature oriented progress in EA with gitflow like version control using a MariaDB repository.