[Firebird-net-provider] [FB-Tracker] Created: (DNET-680) cannot connect to an embedded db with the 5.0.0.0

[livioc (JIRA) <tr...@fi...>]

cannot connect to an embedded db with the 5.0.0.0
-------------------------------------------------

                 Key: DNET-680
                 URL: http://tracker.firebirdsql.org/browse/DNET-680
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.0.0.0
         Environment:  .net 4.6.1 application with the provider 5.0.0.0, i tried different embedded 2.5.* versions on both x32/64 and windows 7/10 and i had always the same error
            Reporter: livioc
            Assignee: Jiri Cincura
            Priority: Critical


 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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira