firebird-net-provider — All about development of the MS .Net provider

Re: [Firebird-net-provider] 4.9.0 beta 1 release

[Jiří Č. <ji...@ci...>]

> 1. readonly IFbMigrationSqlGeneratorBehavior _behavior;
> Is used only in migration operations DropColumn/AlterColumn, not used
> in AddColumn.

The AddColumnOperation calls Generate method for ColumnModel and this
method handles the identity stuff. Or do you mean something else?

> 2. We have additional implementation of Check in (0,1) for boolean
> fields like implemented in SsdlToSql.cs

Good idea. Added. (Testing it as we speak.)

> 3. CreateItemName function doesn't support names longer than 31
> character.

Do you think it should throw exception? I would rather let that for
Firebird. Somebody might tweak the script or something like that.

I know you proposed hashing the name, but that's not reasonable general
solution. The database would look gibberish for outside view. Nobody
would know what's what.

> 4. Also, I don't see where IFbMigrationSqlGeneratorBehavior can be
> injected from client's app code.

In ctor.

> 5. I think the generator creation code in
> DefaultFbMigrationSqlGeneratorBehavior will be copied to a possible
> new implementation, so it is better to split logic. See base class:

Agree. I'd like to first see somebody outside implement other behavior.
Then we can talk about what to extract - i.e. the system tables logic
etc.

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

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Alexander Muylaert-G. <amu...@ho...>]

I had likewise errors on multiple computers in the past weeks. They all had failed windows updates in common. Completely updating windows solved it for me on multiple occasions.

Sent from my Windows Phone
________________________________
From: Jiří Činčura<mailto:ji...@ci...>
Sent: ‎2/‎12/‎2015 11:27
To: fir...@li...<mailto:fir...@li...>
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

On Tue, Dec 1, 2015, at 16:26, slucas wrote:
> ok, that is great, less dlls to deal with.  so whether i put the
> FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the
> directory right next to the exe, i still get the same error.  it throws
> back:
>
> Error {exe name}
> MissingMethodException
> Could not load type
> 'FirebirdSql.Data.FirebirdClient.FbConnection'
> from assembly
> 'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral,
> PublicKeyToken={long number}
>
> so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll
> properly and that dll is throwing back an error.  i think you are
> correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but
> probably for an older version of .NET.  i am thinking for .NET2.0.

Hi, you can try some older versions from
https://sourceforge.net/projects/firebird/files/firebird-net-provider/ .
There were CF versions before.

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

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK
Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Jiří Č. <ji...@ci...>]

On Tue, Dec 1, 2015, at 16:26, slucas wrote:
> ok, that is great, less dlls to deal with.  so whether i put the 
> FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the 
> directory right next to the exe, i still get the same error.  it throws 
> back:
> 
> Error {exe name}
> MissingMethodException
> Could not load type
> 'FirebirdSql.Data.FirebirdClient.FbConnection'
> from assembly
> 'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral, 
> PublicKeyToken={long number}
> 
> so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll 
> properly and that dll is throwing back an error.  i think you are 
> correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but 
> probably for an older version of .NET.  i am thinking for .NET2.0.

Hi, you can try some older versions from
https://sourceforge.net/projects/firebird/files/firebird-net-provider/ .
There were CF versions before.

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

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Ivan A. <int...@un...>]

Hi,
I'm pretty sure
https://drive.google.com/file/d/0BxNlh1_CctC4TUJMZ0xqeE81SHM/view?usp=sharing
is the version I was using successfully on NET CF 3.5. I have no idea if I
compiled it myself at the time (haven't touched any windows-related
development in a few years), but it was running on
 <PlatformFamilyName>PocketPC</PlatformFamilyName>
    <PlatformID>b2c48bd2-963d-4549-9169-1fa021dce484</PlatformID>
    <OSVersion>5.2</OSVersion>
    <DeployDirSuffix>Cassie</DeployDirSuffix>
    <TargetFrameworkVersion>v3.5</TargetFrameworkVersion>
    <NativePlatformName>Windows Mobile 6 Professional
SDK</NativePlatformName>
(taken from the project-file) so it should be working

2015-12-01 18:04 GMT+02:00 Louis van Alphen <lo...@nu...>:

> Maybe you could download the source and recompile for CFx
>
> http://www.firebirdsql.org/en/net-provider/
>
>
>
> -----Original Message-----
> From: slucas [mailto:sl...@iq...]
> Sent: 01 December 2015 05:26 PM
> To: For users and developers of the Firebird .NET providers <
> fir...@li...>
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> ok, that is great, less dlls to deal with.  so whether i put the
> FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the
> directory right next to the exe, i still get the same error.  it throws
> back:
>
> Error {exe name}
> MissingMethodException
> Could not load type
> 'FirebirdSql.Data.FirebirdClient.FbConnection'
> from assembly
> 'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral,
> PublicKeyToken={long number}
>
> so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll
> properly and that dll is throwing back an error.  i think you are
> correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but probably
> for an older version of .NET.  i am thinking for .NET2.0.
>
> the thing is that this motorola MT2090 is still a very actively sold
> device.  i am not just doing this for some obsolete hardware.
>
> can you please point me to a compiled dll for .NET2.0 CF please? i feel
> that i am getting close though.
>
> thanx for the help, lucas
>
>
> On 12/1/15 5:30 AM, Jiří Činčura wrote:
> > On Tue, Dec 1, 2015, at 11:18, slucas wrote:
> >> ok, so i was able to compile with the version linked below.  that is
> >> a start.  and i copied the FirebirdSql.Data.FirebirdClient over to
> >> the scanner's \windows directory.
> > Why there?
> >
> >> so, do i need a version of fbclient.dll on the scanner for the
> >> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does
> > No.
> >
> >> FirebirdSql.Data.FirebirdClient.dll access it directly?
> > Yes.
> >
>
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users
> amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple
> OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Louis v. A. <lo...@nu...>]

I _think_ the older versions are written in C++, so that will likely not work or be much more complex.  

The source prob uses newer C# features, so maybe you could still back-port to .net 2

-----Original Message-----
From: slucas [mailto:sl...@iq...] 
Sent: 01 December 2015 06:43 PM
To: For users and developers of the Firebird .NET providers <fir...@li...>
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

if i remember properly, that was the first thing i tried like two weeks ago.  it wouldn't compile under VS2008 at all.

i think i need an older version designed for CF and .NET2.0.


On 12/1/15 11:04 AM, Louis van Alphen wrote:
> Maybe you could download the source and recompile for CFx
>
> http://www.firebirdsql.org/en/net-provider/
>
>
>
> -----Original Message-----
> From: slucas [mailto:sl...@iq...]
> Sent: 01 December 2015 05:26 PM
> To: For users and developers of the Firebird .NET providers 
> <fir...@li...>
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> ok, that is great, less dlls to deal with.  so whether i put the 
> FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in 
> the directory right next to the exe, i still get the same error.  it 
> throws
> back:
>
> Error {exe name}
> MissingMethodException
> Could not load type
> 'FirebirdSql.Data.FirebirdClient.FbConnection'
> from assembly
> 'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral, 
> PublicKeyToken={long number}
>
> so obviously the exe is calling the 
> FirebirdSql.Data.FirebirdClient.dll
> properly and that dll is throwing back an error.  i think you are correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but probably for an older version of .NET.  i am thinking for .NET2.0.
>
> the thing is that this motorola MT2090 is still a very actively sold device.  i am not just doing this for some obsolete hardware.
>
> can you please point me to a compiled dll for .NET2.0 CF please? i feel that i am getting close though.
>
> thanx for the help, lucas
>
>
> On 12/1/15 5:30 AM, Jiří Činčura wrote:
>> On Tue, Dec 1, 2015, at 11:18, slucas wrote:
>>> ok, so i was able to compile with the version linked below.  that is 
>>> a start.  and i copied the FirebirdSql.Data.FirebirdClient over to 
>>> the scanner's \windows directory.
>> Why there?
>>    
>>> so, do i need a version of fbclient.dll on the scanner for the 
>>> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does
>> No.
>>
>>> FirebirdSql.Data.FirebirdClient.dll access it directly?
>> Yes.
>>
>
> ----------------------------------------------------------------------
> -------- Go from Idea to Many App Stores Faster with Intel(R) XDK Give 
> your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ----------------------------------------------------------------------
> -------- Go from Idea to Many App Stores Faster with Intel(R) XDK Give 
> your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

if i remember properly, that was the first thing i tried like two weeks 
ago.  it wouldn't compile under VS2008 at all.

i think i need an older version designed for CF and .NET2.0.


On 12/1/15 11:04 AM, Louis van Alphen wrote:
> Maybe you could download the source and recompile for CFx
>
> http://www.firebirdsql.org/en/net-provider/
>
>
>
> -----Original Message-----
> From: slucas [mailto:sl...@iq...]
> Sent: 01 December 2015 05:26 PM
> To: For users and developers of the Firebird .NET providers <fir...@li...>
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> ok, that is great, less dlls to deal with.  so whether i put the FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the directory right next to the exe, i still get the same error.  it throws
> back:
>
> Error {exe name}
> MissingMethodException
> Could not load type
> 'FirebirdSql.Data.FirebirdClient.FbConnection'
> from assembly
> 'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral, PublicKeyToken={long number}
>
> so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll
> properly and that dll is throwing back an error.  i think you are correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but probably for an older version of .NET.  i am thinking for .NET2.0.
>
> the thing is that this motorola MT2090 is still a very actively sold device.  i am not just doing this for some obsolete hardware.
>
> can you please point me to a compiled dll for .NET2.0 CF please? i feel that i am getting close though.
>
> thanx for the help, lucas
>
>
> On 12/1/15 5:30 AM, Jiří Činčura wrote:
>> On Tue, Dec 1, 2015, at 11:18, slucas wrote:
>>> ok, so i was able to compile with the version linked below.  that is
>>> a start.  and i copied the FirebirdSql.Data.FirebirdClient over to
>>> the scanner's \windows directory.
>> Why there?
>>    
>>> so, do i need a version of fbclient.dll on the scanner for the
>>> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does
>> No.
>>
>>> FirebirdSql.Data.FirebirdClient.dll access it directly?
>> Yes.
>>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Louis v. A. <lo...@nu...>]

Maybe you could download the source and recompile for CFx

http://www.firebirdsql.org/en/net-provider/



-----Original Message-----
From: slucas [mailto:sl...@iq...] 
Sent: 01 December 2015 05:26 PM
To: For users and developers of the Firebird .NET providers <fir...@li...>
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

ok, that is great, less dlls to deal with.  so whether i put the FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the directory right next to the exe, i still get the same error.  it throws
back:

Error {exe name}
MissingMethodException
Could not load type
'FirebirdSql.Data.FirebirdClient.FbConnection'
from assembly
'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral, PublicKeyToken={long number}

so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll
properly and that dll is throwing back an error.  i think you are correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but probably for an older version of .NET.  i am thinking for .NET2.0.

the thing is that this motorola MT2090 is still a very actively sold device.  i am not just doing this for some obsolete hardware.

can you please point me to a compiled dll for .NET2.0 CF please? i feel that i am getting close though.

thanx for the help, lucas


On 12/1/15 5:30 AM, Jiří Činčura wrote:
> On Tue, Dec 1, 2015, at 11:18, slucas wrote:
>> ok, so i was able to compile with the version linked below.  that is 
>> a start.  and i copied the FirebirdSql.Data.FirebirdClient over to 
>> the scanner's \windows directory.
> Why there?
>   
>> so, do i need a version of fbclient.dll on the scanner for the 
>> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does
> No.
>
>> FirebirdSql.Data.FirebirdClient.dll access it directly?
> Yes.
>


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

ok, that is great, less dlls to deal with.  so whether i put the 
FirebirdSql.Data.FirebirdClient.dll in the \windows directory or in the 
directory right next to the exe, i still get the same error.  it throws 
back:

Error {exe name}
MissingMethodException
Could not load type
'FirebirdSql.Data.FirebirdClient.FbConnection'
from assembly
'FirebirdSql.Data.FirebirdClient' version 2.5.2.0, culture=neutral, 
PublicKeyToken={long number}

so obviously the exe is calling the FirebirdSql.Data.FirebirdClient.dll 
properly and that dll is throwing back an error.  i think you are 
correct.  i need the same FirebirdSql.Data.FirebirdClient.dll but 
probably for an older version of .NET.  i am thinking for .NET2.0.

the thing is that this motorola MT2090 is still a very actively sold 
device.  i am not just doing this for some obsolete hardware.

can you please point me to a compiled dll for .NET2.0 CF please? i feel 
that i am getting close though.

thanx for the help, lucas


On 12/1/15 5:30 AM, Jiří Činčura wrote:
> On Tue, Dec 1, 2015, at 11:18, slucas wrote:
>> ok, so i was able to compile with the version linked below.  that is a
>> start.  and i copied the FirebirdSql.Data.FirebirdClient over to the
>> scanner's \windows directory.
> Why there?
>   
>> so, do i need a version of fbclient.dll on the scanner for the
>> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does
> No.
>
>> FirebirdSql.Data.FirebirdClient.dll access it directly?
> Yes.
>

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Jiří Č. <ji...@ci...>]

On Tue, Dec 1, 2015, at 11:18, slucas wrote:
> ok, so i was able to compile with the version linked below.  that is a 
> start.  and i copied the FirebirdSql.Data.FirebirdClient over to the 
> scanner's \windows directory.

Why there?
 
> so, do i need a version of fbclient.dll on the scanner for the 
> FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does 

No.

> FirebirdSql.Data.FirebirdClient.dll access it directly?

Yes.

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

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

ok, so i was able to compile with the version linked below.  that is a 
start.  and i copied the FirebirdSql.Data.FirebirdClient over to the 
scanner's \windows directory.

so, do i need a version of fbclient.dll on the scanner for the 
FirebirdSql.Data.FirebirdClient.dll to reach the server?  or does 
FirebirdSql.Data.FirebirdClient.dll access it directly?

if i need fbclient.dll, do i need a special version of it?  can i 
compile its source for my CF5/.NET2 platform?

i tried a simple transfer of both fbclient.dll v2.5x32bit and v1.5x32bit 
but neither worked, i even tried gds32.dll from v1.5x32bit.

thank you in advance, lucas


On 11/30/15 11:43 AM, Louis van Alphen wrote:
> Ping uses different protocol AFAIK. But at least it is a start. But you will have to test whether you can run Fbclient on WinCE. Best to write a test app targeting .net2/3.5 and then run  it from your desktop to check that it works. Then deploy that to device and test. That is how I did all my mobile dev for WinCe. Dev & dbug on PC and then just deploy to device, obviously abstracting any plarofrm specific stuff...
>
> -----Original Message-----
> From: slucas [mailto:sl...@iq...]
> Sent: 30 November 2015 06:39 PM
> To: lo...@nu...; For users and developers of the Firebird .NET providers <fir...@li...>
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> so just to confirm.  if i use the wifi connection on the scanner, and i am also am to ping any address on the local network from the gun,
>
> then i should be able to integrate firebird client directly into my scanner executable?
>
>
> On 11/30/15 11:23 AM, Louis van Alphen wrote:
>> Agreed , talking to the DB from the mobile app is not the way to go. This is why I tried to implement a HTTP server that the device talks to. The issue I had was that the device could never connect to the PCs ip address. I could never get the network config to work despite days and days of searching. Finding other ppl with the same issue, but never a solution. This was with a USB tethered / ActiveSync setup. With Wifi it wont be an issue.
>>
>>
>> -----Original Message-----
>> From: Jiří Činčura [mailto:ji...@ci...]
>> Sent: 30 November 2015 06:02 PM
>> To: For users and developers of the Firebird .NET providers <fir...@li...>; ma...@gm...
>> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>>
>> On Mon, Nov 30, 2015, at 16:36, slucas wrote:
>>> so now i am trying to integrate the firebird access so that the
>>> scanner can access the firebirdsql server at another IP on the
>>> network.  make sense?
>> Kind of. I would rather make an app server to do the communication, because of how the Firebird protocol will behave on such a network (I suppose you're not using cable ;)).
>>
>> Anyway you can try (very) old
>> http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download
>> where the CF was supported. But that was build for something like .NET CF 3.5.
>>
>> --
>> Mgr. Jiří Činčura
>> Independent IT Specialist
>>
>> ------------------------------------------------------------------------------
>> Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
>> Use one codebase in this all-in-one HTML5 development environment.
>> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
>> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>>
>> ------------------------------------------------------------------------------
>> Go from Idea to Many App Stores Faster with Intel(R) XDK
>> Give your users amazing mobile app experiences with Intel(R) XDK.
>> Use one codebase in this all-in-one HTML5 development environment.
>> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
>> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Long shot

[Jiří Č. <ji...@ci...>]

Your bet is correct. The trusted auth code is used only when logging in.
Once the connection has been established, the codepath is the same.

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

[Firebird-net-provider] Long shot

[Martin Å. <pal...@ou...>]

Hi,

 

Running an application at a client site we notice a substantial lagging when
user is connected with trusted authentication compared to traditional.

And it is not a lag when posting changes to database but when posting
changes to a .net Dataset (they are committed to the db at a later stage).

 

Is there *anything* in the driver that can explain this (eg privilege
check).  My bet is “nope”.

 

Running FB2.5, FirebirdClient 4.8.1, WPF/XBAP app in Citrix 

 

/Martin

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Louis v. A. <lo...@nu...>]

Ping uses different protocol AFAIK. But at least it is a start. But you will have to test whether you can run Fbclient on WinCE. Best to write a test app targeting .net2/3.5 and then run  it from your desktop to check that it works. Then deploy that to device and test. That is how I did all my mobile dev for WinCe. Dev & dbug on PC and then just deploy to device, obviously abstracting any plarofrm specific stuff...

-----Original Message-----
From: slucas [mailto:sl...@iq...] 
Sent: 30 November 2015 06:39 PM
To: lo...@nu...; For users and developers of the Firebird .NET providers <fir...@li...>
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

so just to confirm.  if i use the wifi connection on the scanner, and i am also am to ping any address on the local network from the gun,

then i should be able to integrate firebird client directly into my scanner executable?


On 11/30/15 11:23 AM, Louis van Alphen wrote:
> Agreed , talking to the DB from the mobile app is not the way to go. This is why I tried to implement a HTTP server that the device talks to. The issue I had was that the device could never connect to the PCs ip address. I could never get the network config to work despite days and days of searching. Finding other ppl with the same issue, but never a solution. This was with a USB tethered / ActiveSync setup. With Wifi it wont be an issue.
>
>
> -----Original Message-----
> From: Jiří Činčura [mailto:ji...@ci...]
> Sent: 30 November 2015 06:02 PM
> To: For users and developers of the Firebird .NET providers <fir...@li...>; ma...@gm...
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> On Mon, Nov 30, 2015, at 16:36, slucas wrote:
>> so now i am trying to integrate the firebird access so that the
>> scanner can access the firebirdsql server at another IP on the
>> network.  make sense?
> Kind of. I would rather make an app server to do the communication, because of how the Firebird protocol will behave on such a network (I suppose you're not using cable ;)).
>
> Anyway you can try (very) old
> http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download
> where the CF was supported. But that was build for something like .NET CF 3.5.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

so just to confirm.  if i use the wifi connection on the scanner, and i 
am also am to ping any address on the local network from the gun,

then i should be able to integrate firebird client directly into my 
scanner executable?


On 11/30/15 11:23 AM, Louis van Alphen wrote:
> Agreed , talking to the DB from the mobile app is not the way to go. This is why I tried to implement a HTTP server that the device talks to. The issue I had was that the device could never connect to the PCs ip address. I could never get the network config to work despite days and days of searching. Finding other ppl with the same issue, but never a solution. This was with a USB tethered / ActiveSync setup. With Wifi it wont be an issue.
>
>
> -----Original Message-----
> From: Jiří Činčura [mailto:ji...@ci...]
> Sent: 30 November 2015 06:02 PM
> To: For users and developers of the Firebird .NET providers <fir...@li...>; ma...@gm...
> Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion
>
> On Mon, Nov 30, 2015, at 16:36, slucas wrote:
>> so now i am trying to integrate the firebird access so that the
>> scanner can access the firebirdsql server at another IP on the
>> network.  make sense?
> Kind of. I would rather make an app server to do the communication, because of how the Firebird protocol will behave on such a network (I suppose you're not using cable ;)).
>
> Anyway you can try (very) old
> http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download
> where the CF was supported. But that was build for something like .NET CF 3.5.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Louis v. A. <lo...@nu...>]

No it is a subset of .NET 2.

I have battled for years to do what you are trying, with no luck whatsoever. Cannot run the FB client on the device. I then tried to POST an  XML to a HTTP server sitting on a PC on the network. That is also a mission as the networking implementationon these devices (WinCe) are shockingly poor. So gave up on that. Basically had to write a sync function that writes an XML file to the device file system and then use RAPI from the desktop side to access the device file system.




-----Original Message-----
From: slucas [mailto:sl...@iq...] 
Sent: 30 November 2015 05:36 PM
To: ma...@gm...; For users and developers of the Firebird .NET providers <fir...@li...>
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

yes, i believe so.  it is ultimately for a motorola rugged barcode scanner, model MT2090.  from its users manual it states, "The MT2000 runs the CE.NET 5.0 Core OS...".  and i believe that is a .NET2.0 framework.

on VS2008, i have been compiling into my executable (exe) on a .NET2.0 framework and so far all of the versions of the executable have been working great.

so now i am trying to integrate the firebird access so that the scanner can access the firebirdsql server at another IP on the network.  make sense?

On 11/30/15 10:17 AM, Markus Ostenried wrote:
> .NET Compact Framework
> https://en.wikipedia.org/wiki/.NET_Compact_Framework
>
> On Mon, Nov 30, 2015 at 3:57 PM, slucas <sl...@iq...> wrote:
>> what is CF?
>>
>>
>> On 11/30/15 2:39 AM, Jiří Činčura wrote:
>>> Are you using CF?
> ----------------------------------------------------------------------
> -------- Go from Idea to Many App Stores Faster with Intel(R) XDK Give 
> your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Louis v. A. <lo...@nu...>]

Agreed , talking to the DB from the mobile app is not the way to go. This is why I tried to implement a HTTP server that the device talks to. The issue I had was that the device could never connect to the PCs ip address. I could never get the network config to work despite days and days of searching. Finding other ppl with the same issue, but never a solution. This was with a USB tethered / ActiveSync setup. With Wifi it wont be an issue.


-----Original Message-----
From: Jiří Činčura [mailto:ji...@ci...] 
Sent: 30 November 2015 06:02 PM
To: For users and developers of the Firebird .NET providers <fir...@li...>; ma...@gm...
Subject: Re: [Firebird-net-provider] VS2008 ADO.NET confusion

On Mon, Nov 30, 2015, at 16:36, slucas wrote:
> so now i am trying to integrate the firebird access so that the 
> scanner can access the firebirdsql server at another IP on the 
> network.  make sense?

Kind of. I would rather make an app server to do the communication, because of how the Firebird protocol will behave on such a network (I suppose you're not using cable ;)).

Anyway you can try (very) old
http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download
where the CF was supported. But that was build for something like .NET CF 3.5. 

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

------------------------------------------------------------------------------
Go from Idea to Many App Stores Faster with Intel(R) XDK Give your users amazing mobile app experiences with Intel(R) XDK.
Use one codebase in this all-in-one HTML5 development environment.
Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
http://pubads.g.doubleclick.net/gampad/clk?id=254741911&iu=/4140
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] [FB-Tracker] Created: (DNET-654) Trimming ten-thousandths of a second during TIMESPAN conversion to the DateTime in the NET Provider for Firebird.

[Kamil K. (JIRA) <tr...@fi...>]

Trimming ten-thousandths of a second during TIMESPAN conversion to the DateTime in the NET Provider for Firebird.
-----------------------------------------------------------------------------------------------------------------

                 Key: DNET-654
                 URL: http://tracker.firebirdsql.org/browse/DNET-654
             Project: .NET Data provider
          Issue Type: Bug
          Components: ADO.NET Provider
    Affects Versions: 4.7.0.0
         Environment: Windows 10, 64-bit
            Reporter: Kamil Kocian
            Assignee: Jiri Cincura


The NET Provider for Firebird trims ten-thousandths of a second during TIMESPAN conversion to the .NET DateTime type in method TypeDecoder.DecodeTime(int sql_time). Trimming the ten-thousandths of a second is causing problem when comparing time read from Firebird to .NET and using the value again in SQL statements. 

However it is possible to initialize .NET type DateTime(or TimeSpan) with number of ticks, this way keeping the precision of Firebird TIMESTAMP in .NET. 

Problematic source code in FirebirdSql.Data.FirebirdClient\Common\TypeDecoder.cs :
public static TimeSpan DecodeTime(int sql_time)
{
	int millisInDay = sql_time / 10;
	int hour = millisInDay / 3600000;
	int minute = (millisInDay - hour * 3600000) / 60000;
	int second = (millisInDay - hour * 3600000 - minute * 60000) / 1000;
	int millisecond = millisInDay - hour * 3600000 - minute * 60000 - second * 1000;

	return new TimeSpan(0, hour, minute, second, millisecond);
}

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

        

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Jiří Č. <ji...@ci...>]

On Mon, Nov 30, 2015, at 16:36, slucas wrote:
> so now i am trying to integrate the firebird access so that the scanner 
> can access the firebirdsql server at another IP on the network.  make
> sense?

Kind of. I would rather make an app server to do the communication,
because of how the Firebird protocol will behave on such a network (I
suppose you're not using cable ;)).

Anyway you can try (very) old
http://sourceforge.net/projects/firebird/files/firebird-net-provider/2.5.2/NETProvider-2.5.2-CF.7z/download
where the CF was supported. But that was build for something like .NET
CF 3.5. 

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

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

yes, i believe so.  it is ultimately for a motorola rugged barcode 
scanner, model MT2090.  from its users manual it states, "The MT2000 
runs the CE.NET 5.0 Core OS...".  and i believe that is a .NET2.0 framework.

on VS2008, i have been compiling into my executable (exe) on a .NET2.0 
framework and so far all of the versions of the executable have been 
working great.

so now i am trying to integrate the firebird access so that the scanner 
can access the firebirdsql server at another IP on the network.  make sense?

On 11/30/15 10:17 AM, Markus Ostenried wrote:
> .NET Compact Framework
> https://en.wikipedia.org/wiki/.NET_Compact_Framework
>
> On Mon, Nov 30, 2015 at 3:57 PM, slucas <sl...@iq...> wrote:
>> what is CF?
>>
>>
>> On 11/30/15 2:39 AM, Jiří Činčura wrote:
>>> Are you using CF?
> ------------------------------------------------------------------------------
> Go from Idea to Many App Stores Faster with Intel(R) XDK
> Give your users amazing mobile app experiences with Intel(R) XDK.
> Use one codebase in this all-in-one HTML5 development environment.
> Design, debug & build mobile apps & 2D/3D high-impact games for multiple OSs.
> http://pubads.g.doubleclick.net/gampad/clk?id=254741551&iu=/4140
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Markus O. <ma...@gm...>]

.NET Compact Framework
https://en.wikipedia.org/wiki/.NET_Compact_Framework

On Mon, Nov 30, 2015 at 3:57 PM, slucas <sl...@iq...> wrote:
> what is CF?
>
>
> On 11/30/15 2:39 AM, Jiří Činčura wrote:
>> Are you using CF?

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

what is CF?


On 11/30/15 2:39 AM, Jiří Činčura wrote:
> Are you using CF?
>

Re: [Firebird-net-provider] VS2008 ADO.NET confusion

[Jiří Č. <ji...@ci...>]

Are you using CF?

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

[Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

may someone please give me some clarity?  i am using visual studio 
2008.  i have to use that version to develope an embedded program for a 
smart device.  so i am locked into VS2008.

i am trying to find and implement the correct library for fb_client.dll 
for use on this windows CE embedded device that uses .NET 2.0 
framework.  i can't for the life of me figure out what libraries or the 
proper version to install for VS2008 that actually work?

thank you in advance, lucas

[Firebird-net-provider] VS2008 ADO.NET confusion

[slucas <sl...@iq...>]

may someone please give me some clarity?  i am using visual studio 
2008.  i have to use that version to develope an embedded program for a 
smart device.  so i am locked into VS2008.

i am trying to find and implement the correct library for fb_client.dll 
for use on this windows CE embedded device that uses .NET 2.0 
framework.  i can't for the life of me figure out what libraries or the 
proper version to install for VS2008 that actually work?

thank you in advance, lucas

[Firebird-net-provider] [FB-Tracker] Created: (DNET-653) Support for -skip_data

[Jiri C. (JIRA) <tr...@fi...>]

Support for -skip_data
----------------------

                 Key: DNET-653
                 URL: http://tracker.firebirdsql.org/browse/DNET-653
             Project: .NET Data provider
          Issue Type: Sub-task
            Reporter: Jiri Cincura
            Assignee: Jiri Cincura




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