[Firebird-net-provider] Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

[Bradburn, Greg (LNG-RDU)]

I am getting the following error when trying to open one of our firebird databases:
FirebirdSql.Data.FirebirdClient.FbException was caught
HResult=-2147467259
Message=Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Source=FirebirdSql.Data.FirebirdClient
ErrorCode=335544472
SQLSTATE=28000
StackTrace:
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at netTiersFileCopier.UpdateFirebirdDatabase.ExecuteBatch(String connectionString, String updateScript, Boolean executeSingleStatements) in c:\Dev\JurisSuite\Branches\v2.7\Foundation\Core\Utililties\netTiersFileCopier\netTiersFileCopier\UpdateFirebirdDatabase.cs:line 623

Here is a screen shot of the code I am executing and the connection string I am using:
Loading Image...

Here is a screenshot of the same database opened in FlameRobin using the same credentials:
[cid:***@01CECE5B.FDC2A220]

Why do I receive that error when trying to open the database programmatically when I can open the same database with the same credentials in FlameRobin?

I have searched for this error but none of the posts that I have found seem to describe the same issue that I am having.

Thanks in advance for your help.
Regards,
Greg.
Greg Bradburn
Sr. Software Engineer
LexisNexis - Business of Law Software Solutions
2000 Regency Pkwy, Suite 600
Cary, NC 27518
919-297-1788 Direct

[Gerdus van Zyl]

Remove "role=;" from your connectionstring, don't know why but if I add it
to my working connection string it gives the same error.
FbConnectionStringBuilder is recommended to build a connectionstring.


<http://about.me/gerdus>

[Bradburn, Greg (LNG-RDU)]

Thanks. That did the trick.

From: Gerdus van Zyl [mailto:***@gmail.com]
Sent: Tuesday, October 22, 2013 8:48 AM
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

Remove "role=;" from your connectionstring, don't know why but if I add it to my working connection string it gives the same error.
FbConnectionStringBuilder is recommended to build a connectionstring.

[Mark Rotteveel]

Post by Gerdus van Zyl
Remove "role=;" from your connectionstring, don't know why but if I add
it to my working connection string it gives the same error.
FbConnectionStringBuilder is recommended to build a connectionstring.

Role "" (empty string) is not the same as no role. A potential solution
would be for the provider not to send the role if it is empty.

Mark

[Rand Random]

Replace the "user" in connection string to
"user id"

From: ***@lexisnexis.com
To: Firebird-net-***@lists.sourceforge.net
Date: Mon, 21 Oct 2013 16:49:34 +0000
Subject: [Firebird-net-provider] Error: Your user name and password are not defined. Ask your database administrator to set up a Firebird login.









I am getting the following error when trying to open one of our firebird databases:
FirebirdSql.Data.FirebirdClient.FbException was caught
HResult=-2147467259
Message=Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
Source=FirebirdSql.Data.FirebirdClient
ErrorCode=335544472
SQLSTATE=28000
StackTrace:
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.Create()
at FirebirdSql.Data.FirebirdClient.FbConnectionPool.CheckOut()
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
at netTiersFileCopier.UpdateFirebirdDatabase.ExecuteBatch(String connectionString, String updateScript, Boolean executeSingleStatements) in c:\Dev\JurisSuite\Branches\v2.7\Foundation\Core\Utililties\netTiersFileCopier\netTiersFileCopier\UpdateFirebirdDatabase.cs:line
623

Here is a screen shot of the code I am executing and the connection string I am using:
https://www.dropbox.com/s/2hkvq2p25jm8wjf/10-21-2013%2012-41-03%20PM.png

Here is a screenshot of the same database opened in FlameRobin using the same credentials:


Why do I receive that error when trying to open the database programmatically when I can open the same database with the same credentials in FlameRobin?

I have searched for this error but none of the posts that I have found seem to describe the same issue that I am having.

Thanks in advance for your help.
Regards,
Greg.
Greg Bradburn

Sr. Software Engineer

LexisNexis – Business of Law Software Solutions

2000 Regency Pkwy, Suite 600

Cary, NC 27518

919-297-1788 Direct