dmurawski | 25 May 17:00 2016

I'm on vacation until Wednesday, May 25th.

I will be back in the office on Wednesday, May 25th.
 
Dan
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
livioc (JIRA | 25 May 16:58 2016

[FB-Tracker] Created: (DNET-683) exception when using a boolean parameter with an embedded v2.5 server

exception when using a boolean parameter with an embedded v2.5 server
---------------------------------------------------------------------

                 Key: DNET-683
                 URL: http://tracker.firebirdsql.org/browse/DNET-683
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 5.0.5.0, 5.0.0.0
         Environment:  .net 4.6.1 application on windows x32 with embedded v.5
            Reporter: livioc
            Assignee: Jiri Cincura

executing a query with an explicit typed boolean parameter will generate this exception

FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure ---> FirebirdSql.Data.Common.IscException: Dynamic SQL Error
SQL error code = -804
Incorrect values within SQLDA structure
   at FirebirdSql.Data.Client.Native.FesDatabase.ProcessStatusVector(IntPtr[] statusVector) in
C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesDatabase.cs:line 365
   at FirebirdSql.Data.Client.Native.FesStatement.Execute() in
C:\Users\Jiri\Documents\devel\NETProvider\working\Provider\src\FirebirdSql.Data.FirebirdClient\Client\Native\FesStatement.cs:line 384
   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 1221
   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

note:with expicit typed parameter i mean:
 cmd.Parameters.Add(" <at> value", FbDbType.Boolean);
cmd.Parameters[0].Value = true;

note2:i'm sending a pull request to github with a failing test for that

--

-- 
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
dmurawski | 24 May 13:18 2016

I'm on vacation until Wednesday, May 25th.

I will be back in the office on Wednesday, May 25th.
 
Dan
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Michał Ziemski (JIRA | 24 May 13:15 2016

[FB-Tracker] Created: (DNET-682) NET Core port

NET Core port
-------------

                 Key: DNET-682
                 URL: http://tracker.firebirdsql.org/browse/DNET-682
             Project: .NET Data provider
          Issue Type: Task
          Components: ADO.NET Provider
            Reporter: Michał Ziemski
            Assignee: Jiri Cincura

NET Core RC2 was released recently.

I'd be great to have a build of NET Provider targeting one of the net platform standards:
https://github.com/dotnet/corefx/blob/master/Documentation/architecture/net-platform-standard.md
that would be able to run in the new environment.

The API exposed by NET Core is somewhat different then the Framework.
Few example:
 - ICloneable is no more (this could be easiliy solved by removing that from the implemented interfaces list)
 - serialization was scrapped (there are some stubs available in System.Runtime.Serialization.Primitives)

There are may other issues. Sometimes easily solved by referencing a relevant CoreFX assembly (ie
System.Data.Common, System.ComponentModel.Primitives, etc ):
https://github.com/dotnet/corefx
others regretfully require some more sophisticated changes.

There are also some points that are simply not availabe (AFAIK):
 - distributed transactions

--

-- 
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 <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
dmurawski | 24 May 08:49 2016

I'm on vacation until Wednesday, May 25th.

I will be back in the office on Wednesday, May 25th.
 
Dan
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Jiří Činčura | 24 May 08:45 2016
Picon
Gravatar

ADO.NET provider 5.0.5.0

More info:
http://blog.cincura.net/233562-ado-net-provider-5-0-5-0-for-firebird-is-ready/
.

--

-- 
Mgr. Jiří Činčura
Independent IT Specialist

------------------------------------------------------------------------------
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 <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
livioc (JIRA | 19 May 16:48 2016

[FB-Tracker] Created: (DNET-681) the provider passes the windows username and not the userid of connection string to the embedded server

the provider passes the windows username and not the userid of connection string to the embedded server
-------------------------------------------------------------------------------------------------------

                 Key: DNET-681
                 URL: http://tracker.firebirdsql.org/browse/DNET-681
             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

the new version( 5.0.0.0) uses the windows identity as username to log to the embedded server, not the user
specified in the connection string 

note: i got the username used to login with the query 'SELECT CURRENT_USER FROM RDB$DATABASE' 

--

-- 
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
dmurawski | 19 May 14:36 2016

I'm on vacation until Wednesday, May 25th.

I will be back in the office on Wednesday, May 25th.
 
Dan
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Paul Dryden | 18 May 19:23 2016
Picon

Aliases not working

For some reason on my system aliases don't work. Now I have to go into each app and change the alias to the actual path name. Any reason or solution for this?

Paul Dryden, University of Utah


------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
dmurawski | 18 May 15:01 2016

I'm on vacation until Wednesday, May 25th.

I will be back in the office on Wednesday, May 25th.
 
Dan
------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
livioc (JIRA | 18 May 14:57 2016

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

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

------------------------------------------------------------------------------
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

Gmane