Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: ngong on November 23, 2022, 03:36:58 am

Title: feap file as ODBC source
Post by: ngong on November 23, 2022, 03:36:58 am

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.

Title: Re: feap file as ODBC source
Post by: Paolo F Cantoni on November 23, 2022, 09:23:54 am

Quote from: ngong on November 23, 2022, 03:36:58 am

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

Title: Re: feap file as ODBC source
Post by: qwerty on November 23, 2022, 09:29:54 am

Try admin/password

q.

Title: Re: feap file as ODBC source
Post by: ngong on November 23, 2022, 11:59:19 pm

@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.

Title: Re: feap file as ODBC source
Post by: qwerty on November 24, 2022, 02:19:46 am

Have you tried Google for "firebird db viewer"?

q.

Title: Re: feap file as ODBC source
Post by: Paolo F Cantoni on November 24, 2022, 11:42:38 am

Quote from: ngong on November 23, 2022, 11:59:19 pm

@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

Title: Re: feap file as ODBC source
Post by: ngong on November 29, 2022, 09:39:42 pm

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.