firebird-net-provider

[Firebird-net-provider] Your login SYSDBA is same as one of the SQL role name

[Marco <mar...@To...>]

Hi,
	i'm new to firbird and i try to start from the embedded version.
I have to work at an application released from anoter developer.

The app use this:
.NET 2.0 (C#)
Firebird .NET Provider 2.0
Firebird Embedded 1.5

I try to connect to some Firebird DB File not created by me.
The connection string is like this: "ServerType=1;User=SYSDBA;Password=masterkey;Dialect=3;Database=C:\DB.fdb"

Fore meny DB it wroks fine but for other DB the connecion rise this exception:

"Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login."

Where is the problem? I' have read embedded firebird 1.5 not use autentication for DB.
Can you help me?

Thanks

Marco

Re: [Firebird-net-provider] Your login SYSDBA is same as one of the SQL role name

[Jiri C. <di...@ci...>]

On 4/23/08, Marco <mar...@to...> wrote:
>  "Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login."

This is trick, when you need to block sysdba account. Look at
firebird-support list for more info.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Your login SYSDBA is same as one of the

[Marco <mar...@To...>]

Jiri Cincura ha scritto:
> On 4/23/08, Marco <mar...@to...> wrote:
>>  "Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login."
> 
> This is trick, when you need to block sysdba account. Look at
> firebird-support list for more info.
> 
OK, thanks, but can I unlok this block?

Re: [Firebird-net-provider] Your login SYSDBA is same as one of the

[Marco <mar...@To...>]

Jiri Cincura ha scritto:
> On 4/23/08, Marco <mar...@to...> wrote:
>>  "Your login SYSDBA is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login."
> 
> This is trick, when you need to block sysdba account. Look at
> firebird-support list for more info.
> 
OK, thanks, but can I unlok this block?

Re: [Firebird-net-provider] Your login SYSDBA is same as one of the

[Jiri C. <di...@ci...>]

On 4/28/08, Marco <mar...@to...> wrote:
>  OK, thanks, but can I unlok this block?

You have to delete this role from account, that created it. This is
here completely OT, follow the support list.

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com