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

2016-05-19 Thread Геннадий Забула 
I can confirm. Same issue here.
Steps:
run Update-Package FirebirdSql.Data.FirebirdClient
in package manager console

On 18 May 2016 at 15:57, livioc (JIRA)  wrote:
> 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
>  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
>
>
>
> --
> Mobile security can be enabling, not merely restricting. Employees who
> bring their own devices (BYOD) to work are irked by the imposition of MDM
> restrictions. Mobile Device Manager Plus allows you to control only the
> apps on BYO-devices by containerizing them, leaving personal data untouched!
> https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
>

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

2016-05-18 Thread livioc (JIRA) 
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

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



--
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider