New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
cannot connect to an embedded db with the 5.0.0.0 [DNET680] #633
Comments
Modified by: @cincuranetstatus: Open [ 1 ] => In Progress [ 3 ] |
Commented by: @cincuranet Version 5 is more eager to check errors returned from server. |
Commented by: livioc (livioc)
i have file system permission on the db file and i'm using the sysdba account so what's my configuration problem if it's not a bug? |
Commented by: @cincuranet This is not a place to get support. Ask here http://www.firebirdsql.org/en/support/ . |
Commented by: livioc (livioc) after a lot of tests i found the problem, it's a bug in the provider 5.0.0.0, the new version uses the windows identity as username to log to the embedded server, not the user specified in the connection string (i get the username used to login with the query 'SELECT CURRENT_USER FROM RDB$DATABASE') |
Commented by: Hennadii Zabula (zabulus) I can confirm. Same issue here. |
Commented by: @cincuranet Create a separate issue for that. |
Modified by: @cincuranet |
Submitted by: livioc (livioc)
Relate to DNET681
i use this connection string
<add name="DbConnection" connectionString="Database=databasealiasname;ServerType=1;User=sysdba;Charset=WIN1252" providerName="FirebirdSql.Data.FirebirdClient"/>
and in the alias.conf i have the full file path
databasealiasname= C:\ProgramData\database.fdb
when i update the provider from 4.10 to 5 i get this exception when opening the connection
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): no permission for read-write access to database *** ---> no permission for read-write access to database ***
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionInternal.cs:line 182
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 202
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 106
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnectionPoolManager.cs:line 221
at FirebirdSql.Data.FirebirdClient.FbConnection.Open() in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbConnection.cs:line 534
with another app i get the exception only when doing the first query
FirebirdSql.Data.FirebirdClient.FbException: no permission for read/select access to TABLE *** ---> FirebirdSql.Data.Common.IscException: no permission for read/select access to TABLE ***
at FirebirdSql.Data.Client.Native.FesDatabase.ParseStatusVector(IntPtr[] statusVector) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 375
at FirebirdSql.Data.Client.Native.FesStatement.Prepare(String commandText) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 302
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1169
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 1192
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior) in C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\FirebirdClient\FbCommand.cs:line 527
Commits: 2bf5fb7 aba71c6
The text was updated successfully, but these errors were encountered: