[Firebird-net-provider] Gds.NET 2.5.1 overview
hello one and all, i am working with version 2.5.1 of ADO.NET because i need to compile the simplest code for .NET 2 CF. under the build of 2.5.1, i found a batch file \netcf\build.bat and i surmise that the Version10 cs files make fit my .NET2CF platform best. so at this point, i was able to port and run the code for GdsConnection Connect and Disconnect and i believe successfully connected to a host IP server from my mobile device, which happens to be a motorola MT2090, via the wifi LAN. i verified that IsConnected and ProtocolVersion and ProtocolArchitecture threw back sensible values. ok, so now i am looking into GdsDatabase.cs file and i am confused. how do i connect to the database with user and passwd, start a single transaction, throw a select in and retrieve the field values, or throw in an insert, and then commit the transaction and close the database. i want to do very basic stuff. so i am asking for example/sample/tutorial code to show these basics but using the GdsConnection *.cs modules, Version10, and not the more modern FbConnection etc. code. did that make sense? thank you in advance, lucas -- ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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:slu...@iquanta.com]
> Sent: 01 December 2015 05:26 PM
> To: For users and developers of the Firebird .NET providers
> <firebird-net-provider@lists.sourceforge.net>
> 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=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> 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=/4140
> ___
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> 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=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 ADO.NET confusion
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:slu...@iquanta.com] > Sent: 30 November 2015 06:39 PM > To: lo...@nucleo.co.za; For users and developers of the Firebird .NET > providers <firebird-net-provider@lists.sourceforge.net> > 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:j...@cincura.net] >> Sent: 30 November 2015 06:02 PM >> To: For users and developers of the Firebird .NET providers >> <firebird-net-provider@lists.sourceforge.net>; mag...@gmx.com >> 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=/4140 >> ___ >> Firebird-net-provider mailing list >> Firebird-net-provider@lists.sourceforge.net >> 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=/4140 >> ___ >> Firebird-net-provider mailing list >> Firebird-net-provider@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > --
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=/4140
___
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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:j...@cincura.net] > Sent: 30 November 2015 06:02 PM > To: For users and developers of the Firebird .NET providers > <firebird-net-provider@lists.sourceforge.net>; mag...@gmx.com > 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=/4140 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > 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=/4140 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > 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=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 ADO.NET confusion
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=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
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 <slu...@iquanta.com> 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=/4140 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > 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=/4140 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] VS2008 ADO.NET confusion
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 mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] VS2008 ADO.NET confusion
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 mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
