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

[Firebird-net-provider] Can I receive notifications of Events?

[Mike L. <mla...@ne...>]

Hello,

    I am just starting to use the Firebird database and am using the .NET
component.  Can I receive notifications for when the database (A table or
Row) changes and react to them in my code.  I am not very experienced with
databases and I am not sure if this is the same thing as "triggers".  If not
with the .Net component maybe with another component?  Does anyone have any
Ideas?

Thanks,

Mike Lavender

Re: Subject: [Firebird-net-provider] Questions about the .NET Data provider

[Kovalenko D. <di...@lc...>]

> However, I never could get any of the ODBC or OLE DB
> drivers for Firebird to work,

Thank you very much, Jason :-)

-- 
Dmitry Kovalenko
http://www.ibprovider.com

Re: [Firebird-net-provider] ASP.Net!!!

[Alessandro P. <pet...@in...>]

""Misael Chuc "" <MC...@ro...> wrote in message
news:see...@gw......
> Hi Allesandro!
>
> Thank you very much for you Help!, I'll follow you example!
>
> Regards!
>
> Any Body  know, How  I can  make a connection to Interbase/Firebird
> from Macromedia Dreamweaver MX?
>
> Because with Dreamweaver have a Tool to make a Connection via OLEDB.

If you want to connect using Dreamweaver MX and OLEDB you have to use a
Firebird OLEDB Driver, if you want to continue using the .NET Provider
(suggested!) you have two possibilities:

1) you code the connection manually.
2) you create your own DW Extension.

Regards,
Alessandro Petrelli.

[Firebird-net-provider] ASP.Net!!!

[Misael C. <MC...@ro...>]

Hi Allesandro!
 
Thank you very much for you Help!, I'll follow you example!

Regards!
 
Any Body  know, How  I can  make a connection to Interbase/Firebird
from Macromedia Dreamweaver MX?

Because with Dreamweaver have a Tool to make a Connection via OLEDB.

Sorry, but I'm a Novice on ASP.Net and C#.

Regards to All

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

> db.Output.WriteLong(0);    // Address of ast routine
> db.Output.WriteLong(0);    // Argument to ast routine

Sorry this needs to be :

db.Output.WriteInt(0);	// Address of ast routine
db.Output.WriteInt(0);	// Argument to ast routine




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] ASP.NET..

[Alessandro P. <pet...@in...>]

Misael,
in your web.config file write a key like this:

    <appSettings>
        <add key="ConnectionString"
value="Database=d:\db\mydb.fdb;User=MYUSER;Password=mypwd;Dialect=3;Server=1
27.0.0.1" />
    </appSettings>

and then use the provider simply importing the assembly and instantiating a
new connection:

using FirebirdSql.Data.Firebird;

namespace MyNameSpace
{
    public class MyClass
    {
        public void MyMethod()
        {
               FbConnection FbConn = new
FbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
               FbConn.Open();
               try
               {
                    // do what you need to do...
                }
                finally
                {
                    FbConn.Close();
                }
        }
    }
}

Regards,
Alessandro Petrelli.

> ""Misael Chuc "" <MC...@ro...> wrote in message
news:see...@gw......
> How can I make a Connection to interbase server via firebird-net-provider
using ASP.NET or How can make a UDL file to I can use in my proyect.

> Regards!

[Firebird-net-provider] ASP.NET..

[Misael C. <MC...@ro...>]

How can I make a Connection to interbase server via
firebird-net-provider using ASP.NET or How can make a UDL file to I can
use in my proyect.
 
Regards!

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

> I would be more than happy to help you with the Event implementation.

Huuuummmmm one question i'm reviewing the firebird sources, if i 
understand well ( i have no great level of C++ ) for isc_que_events we 
need to send anything like this:

						db.Output.WriteInt(op_que_events); // Op code
db.Output.WriteInt(db.Handle); 	// Database object id
db.Output.WriteTyped(GdsCodes.EPB_version1, epb);// Event description block
db.Output.WriteLong(0);	// Address of ast routine
db.Output.WriteLong(0);	// Argument to ast routine
db.Output.WriteInt(db.RemoteEventId); // Client side id of remote event


But how we can send tge address of ast rountine ( i was thinking on send 
the addess of a delegate but i'nm nosure if it can be :D ), and the 
argument list, any idea ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

> I'll try to prepare some samples as soon as possible.

Great!!



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

> Back in November or December I had mentioned that I would look at
> implementing the Events API.  Due to time contstraints I was forced to
> abandon the attempt.  At the time I had a lot of notes that were, more or
> less, a roadmap of how it would be implemented.
> 
> The unfortunate thing is that these notes were in a location NOT backed up
> and that hard drive has since died.  But, I am sure much of what I had is
> still somewhere in my head.  I just need to relearn all of the details.

 > I would be more than happy to help you with the Event implementation.

Great!! I have started to work on this yet but all ideas are welcome 
when i have anything working i will make a commit into the 1.1 branch.

> PS.  I am glad to see your back online.  There seemed to be an uneasy
> silence after your announcement.

Thanks :D




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] Questions about the .NET Data provider

[Tedd <te...@al...>]

Carlos,

Back in November or December I had mentioned that I would look at
implementing the Events API.  Due to time contstraints I was forced to
abandon the attempt.  At the time I had a lot of notes that were, more or
less, a roadmap of how it would be implemented.

The unfortunate thing is that these notes were in a location NOT backed up
and that hard drive has since died.  But, I am sure much of what I had is
still somewhere in my head.  I just need to relearn all of the details.

I would be more than happy to help you with the Event implementation.

Tedd

PS.  I am glad to see your back online.  There seemed to be an uneasy
silence after your announcement.


-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Carlos Guzman Alvarez
Sent: Thursday, June 12, 2003 5:21 AM
To: Alan McDonald
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] Questions about the .NET Data
provider



All contributions will be welcome :D, i will try to see ASP .NET more in
deep after try to implement Events API :)

R: [Firebird-net-provider] Questions about the .NET Data provider

[Alessandro P. <pet...@in...>]

Alan,
I've no time right now but... there are 2 different ways:
1) using DataSource and DataGrid internal paging. PRO: no code required.
CONS: the DataSet is completely rebuilt each time.
2) using AllowCustomPaging property: in this case you have to rebuild =
the
sql string (using SKIP) on the DataGrid OnPageIndexChanged event.

If the dataset is small you can use the first method but if you have a =
lot
of rows the second one is the preferred way to do paging.

Sorry for my poor English.

Regards,
Alessandro Petrelli.

-----Messaggio originale-----
Da: Alan McDonald [mailto:al...@me...]=20
Inviato: gioved=EC 12 giugno 2003 14.50
A: Alessandro Petrelli; fir...@li...
Oggetto: RE: [Firebird-net-provider] Questions about the .NET Data =
provider

Alessandro,
I'd love to see these. Does the datagrid component expect you to use =
these
clauses when not using a recordset? Or does the datagrid expect a =
recordset
and the Recordset expect you to use them, or does the datagrid expect =
the
recordset to use them?
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alessandro Petrelli
> Sent: Thursday, 12 June 2003 10:47 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] Questions about the .NET Data
> provider
>
>
>
> "Carlos Guzman Alvarez" <car...@te...> wrote in message
> news:3EE...@te......
> >
> > Hello:
> >
> > >  I will be looking eagerly at your employee.gdb example
> > > app. Maybe I can contribute.
> >
> > All contributions will be welcome :D, i will try to see ASP .NET =
more in
> > deep after try to implement Events API :)
> >
> >
>
> I'm using the provider with ASP.NET a lot  and  I'm also paging =
datagrids
> with FIRST / SKIP with success.
> I'll try to prepare some samples as soon as possible.
>
> Regards,
> Alessandro Petrelli.
>
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] (no subject)

[Bob C. <Ad...@na...>]

RE: [Firebird-net-provider] Questions about the .NET Data provider

[Alan M. <al...@me...>]

Alessandro,
I'd love to see these. Does the datagrid component expect you to use these
clauses when not using a recordset? Or does the datagrid expect a recordset
and the Recordset expect you to use them, or does the datagrid expect the
recordset to use them?
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alessandro Petrelli
> Sent: Thursday, 12 June 2003 10:47 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] Questions about the .NET Data
> provider
>
>
>
> "Carlos Guzman Alvarez" <car...@te...> wrote in message
> news:3EE...@te......
> >
> > Hello:
> >
> > >  I will be looking eagerly at your employee.gdb example
> > > app. Maybe I can contribute.
> >
> > All contributions will be welcome :D, i will try to see ASP .NET more in
> > deep after try to implement Events API :)
> >
> >
>
> I'm using the provider with ASP.NET a lot  and  I'm also paging datagrids
> with FIRST / SKIP with success.
> I'll try to prepare some samples as soon as possible.
>
> Regards,
> Alessandro Petrelli.
>
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Alessandro P. <pet...@in...>]

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3EE...@te......
>
> Hello:
>
> >  I will be looking eagerly at your employee.gdb example
> > app. Maybe I can contribute.
>
> All contributions will be welcome :D, i will try to see ASP .NET more in
> deep after try to implement Events API :)
>
>

I'm using the provider with ASP.NET a lot  and  I'm also paging datagrids
with FIRST / SKIP with success.
I'll try to prepare some samples as soon as possible.

Regards,
Alessandro Petrelli.

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

>  I will be looking eagerly at your employee.gdb example
> app. Maybe I can contribute.

All contributions will be welcome :D, i will try to see ASP .NET more in 
deep after try to implement Events API :)








-- 
Bets regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] Questions about the .NET Data provider

[Alan M. <al...@me...>]

> Well i have no experience with ASP.NET ( i will try to start to see it
> after try to implement Events API i'm going to start witrh it today ),
> but now you can exec command with FIRST/SKIP clausule, are you thinking
> in make it automatic or how ??
>

I assume that all this .NET stuff and all the older ASP stuff has been
written with both eyes firmly planted on MSSQL. I have no experience with
MSSQL so I could never confirm if certain efficiencies were being used which
were not accessible to users of other backends. I know I can now use
FIRST/SKIP clause but the use of these keywords in themselves is not readily
integrated into the ASP.NET model. They are certainly not surfacing in any
of the ASP server objects. I will have to look more closely now at the
sample ASP.NET apps. I will be looking eagerly at your employee.gdb example
app. Maybe I can contribute.

Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Alan McDonald
> Sent: Thursday, 12 June 2003 7:12 PM
> To: CAR...@te...
> Cc: fir...@li...
> Subject: [Firebird-net-provider] Questions about the .NET Data provider
>
>
> Carlos,
> Can you tell me:...
> The ASP.NET coponents include a datagrid (much like the old datagrid for
> ASP) but it now sports a page numbering navigation bar (instead on the old
> first, last, previous, next links)
> I'm not sure how the old one handled this in terms of the query and paging
> but I suspect that even with large queries, the component, in conjunction
> with the recordset object would retrieve all records in the
> query, then page
> down/up to the required start point for the page control, then render the
> records required for the page. Obviously this is quite a heavy
> solution for
> larger datasets/queries. I have to suspect this to be so since
> the old ODBC
> drivers and the old IB (up to 6.0) never had the FIRST and SKIP commands.
>
> Now that FB has the FIRST and SKIP commands, will the ASP.NET provider be
> able to use them for the purpose of efficiently delivering page-sized
> recordsets to this new grid control? Is there another way it does this
> efficiently? Is there something I am missing?
>
> Thanks
> Alan McDonald
> PS - glad to see you are back on line - thanks to Sean - perhaps
> contact me
> offline - maybe there is something else you need which I might be able to
> provide you.
>
>
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by: eBay
> Great deals on office technology -- on eBay now! Click here:
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

[Firebird-net-provider] Questions about the .NET Data provider

[Alan M. <al...@me...>]

Carlos,
Can you tell me:...
The ASP.NET coponents include a datagrid (much like the old datagrid for
ASP) but it now sports a page numbering navigation bar (instead on the old
first, last, previous, next links)
I'm not sure how the old one handled this in terms of the query and paging
but I suspect that even with large queries, the component, in conjunction
with the recordset object would retrieve all records in the query, then page
down/up to the required start point for the page control, then render the
records required for the page. Obviously this is quite a heavy solution for
larger datasets/queries. I have to suspect this to be so since the old ODBC
drivers and the old IB (up to 6.0) never had the FIRST and SKIP commands.

Now that FB has the FIRST and SKIP commands, will the ASP.NET provider be
able to use them for the purpose of efficiently delivering page-sized
recordsets to this new grid control? Is there another way it does this
efficiently? Is there something I am missing?

Thanks
Alan McDonald
PS - glad to see you are back on line - thanks to Sean - perhaps contact me
offline - maybe there is something else you need which I might be able to
provide you.

Re: Subject: [Firebird-net-provider] Questions about the .NET Data provider

[<CAR...@te...>]

Hello=3A

=3E I=27m developing an app in C++=2C and was intending to use
=3E Ado (not the =2ENET version)=2C because the target was not
=3E to be a =22managed=22 program=2C but an =22unmanaged=22 program
=3E (and I had considered the free MSDE SQL engine from
=3E MS)=2E However=2C in case of larger database requirements=2C
=3E I wanted to avoid the =241500 charge for MSSQL=27s =22full=22
=3E version (small package)=2C so Firebird seemed really
=3E attractive (and so did MySQL)=2E

Huummm if i can give you an advice =3A) use Firebird !!=2C MSDE has a =

limitation of five users=2C if i remember well=2C and MySQL lacks=2C at t=
his =

moment=2C some interesting features as Triggers=2C Stored Procs=2C =

Referential integrity=2C =2E=2E=2E =


=3E However=2C I never could get any of the ODBC or OLE DB
=3E drivers for Firebird to work=2C except for the one
=3E =22sanctioned=22 by Borland from Easysoft=2E That worked=2C
=3E but then I saw =2ENet provider=2C and reconsidered (for
=3E perhaps time 4) what connection methods I should use=2E

Have you tested the IBPhoenix ODBC Driver =3F=3F=3F =

( http=3A//www=2Eibphoenix=2Ecom/main=2Enfs=3Fa=3Dibphoenix=26page=3Dibp=5F=
60=5Fodbc )

=3E The only thing I noticed=2C outside of a requirement for
=3E the transaction which I=27m not sure I understand well
=3E enough to even object=2C or just use=2C is the absence of
=3E support for the DataSet object=2E That would allow use
=3E of all the other =22goodies=22 in ADO=2ENET that depend upon
=3E DataSet (and perhaps=2C too=2C DataTable)=2E

Huuumm the =2ENET framework has a independent Dataset/DataTable classes =

that can be used with any ADO=2ENET Provider=2E

=3E Frankly=2C though=2C I=27m just fine without it=2C because I
=3E have my own data management features that perform the
=3E functions typical of DataSet=2C and I=27ll abstract from
=3E there toward my application code=2E
=3E =

=3E I=27m a few months away from completing my own
=3E application=2C and I=27m continuing to evaluate just what
=3E providers or connection methods are best for me to
=3E use=2C but this =2ENET data provider has=2C in just my test
=3E evaluations=2C done what I need it to do=2E =

=3E =

=3E As I get closer to my target release=2C let me ask=2C in
=3E what way may I return the favor - such as a
=3E contribution to your cause=2E I don=27t see that a license
=3E is required to use or include the =2ENet provider in my
=3E distribution (unless I=27m mistaken)=2C but if I=27m going
=3E to benefit from it=27s use=2C it=27s only good business to
=3E support it=27s development=2E

There are some ways to contribute=3A

	- Sending bug reports =

	- Sending patches=2E
     	- Sending suggestions about new features or modification for =

existing one=2E=2E
     	- =2E=2E=2E
     	- For money support i think the best way is to help using the =

Firebird Foundation =

	( http=3A//www=2Efirebirdsql=2Eorg/ff/foundation/ )=2E

The provider has LGPL license=2C i don=27t know the details about it =3A)=
=2C =

but i think you can use without problems with comercial and non-
comercial applications=2C as i know the limitation is that if you make =

modifications to the source code and you want to distribute them you =

need to make them public (if i=27m wrong please correct me =3AD)=2E





--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain

Subject: [Firebird-net-provider] Questions about the .NET Data provider

[Jason V. <jas...@ya...>]

Response to "are you using .Net Provider" and such...

I'm just now beginning to "test" the waters with it.
 
I'm developing an app in C++, and was intending to use
Ado (not the .NET version), because the target was not
to be a "managed" program, but an "unmanaged" program
(and I had considered the free MSDE SQL engine from
MS). However, in case of larger database requirements,
I wanted to avoid the $1500 charge for MSSQL's "full"
version (small package), so Firebird seemed really
attractive (and so did MySQL).

However, I never could get any of the ODBC or OLE DB
drivers for Firebird to work, except for the one
"sanctioned" by Borland from Easysoft. That worked,
but then I saw .Net provider, and reconsidered (for
perhaps time 4) what connection methods I should use.

So I loaded the .NET provider, and found one of the
sample apps in MSDN for MSSQL's own provider, and
tried that - it worked with MSSQL just fine, so I
decided to add in the "#using
"FirebirdSql.Data.Firebird.dll" " and switch all of
the Sqlxxx to Fbxxx, and found only one small point to
be changed; the example didn't require a transaction
object prior to the "ExecuteReader" call, but other
than that, the Firebird provider worked fine.

The only thing I noticed, outside of a requirement for
the transaction which I'm not sure I understand well
enough to even object, or just use, is the absence of
support for the DataSet object. That would allow use
of all the other "goodies" in ADO.NET that depend upon
DataSet (and perhaps, too, DataTable).

Frankly, though, I'm just fine without it, because I
have my own data management features that perform the
functions typical of DataSet, and I'll abstract from
there toward my application code.

I'm a few months away from completing my own
application, and I'm continuing to evaluate just what
providers or connection methods are best for me to
use, but this .NET data provider has, in just my test
evaluations, done what I need it to do. 

As I get closer to my target release, let me ask, in
what way may I return the favor - such as a
contribution to your cause. I don't see that a license
is required to use or include the .Net provider in my
distribution (unless I'm mistaken), but if I'm going
to benefit from it's use, it's only good business to
support it's development.





__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Re: [Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:

> What do you think of a simple sample app which uses the employee
> database which ships with FB -- that way people can see how to use both
> the provider and Firebird?

Can be good, probably by making it using Windows Forms and ASP .NET ( 
this can be good for me too because i want to see ASP .NET :D )






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

RE: [Firebird-net-provider] Questions about the .NET Data provider

[Leyne, S. <Se...@Br...>]

Carlos,

Although I don't use the provider...

> 3. What type of project do you think that can be of interest for help=20
> people on use Firebird + .NET/Mono and that can be made using the=20
> Firebird .NET Data Provider ??

What do you think of a simple sample app which uses the employee
database which ships with FB -- that way people can see how to use both
the provider and Firebird?


Sean

[Firebird-net-provider] Questions about the .NET Data provider

[Carlos G. A. <car...@te...>]

Hello:


1. Are you using version 1.1 of the .NET Data aprovider ?? Have tested 
the Services implementation ?? Are you having problems with it ??


2. I'm thinking on try to implement Events API , do you think that this 
can be of interest or not ??


3. What type of project do you think that can be of interest for help 
people on use Firebird + .NET/Mono and that can be made using the 
Firebird .NET Data Provider ??








-- 
Best regards

Carlos Guzmán Álvarez
Vigo-España

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

Re: [Firebird-net-provider] Temporary good-bye.

[Carlos G. A. <car...@te...>]

Hello:

Probably and thanks to the support of Sean Leyne i could continue with 
the developement of the .NET provider :D



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

"No tengo dones especiales.Sólo soy apasionadamente curioso"
Albert Einstein, científico.

[Firebird-net-provider] Temporary good-bye.

[Carlos G. A. <car...@te...>]

Hello:


After the end of this week i'm going to be without internet connection
for an undetermined period of time, depends on the time i need to found
a job ( i'm unemployed now and i can't continue to pay the connection).

I want to give great thanks to all the people that have been helping on
the developement of the .NET provider.

I will try to check the .NET provider developement list periodically, 
using a cybercafe :P, and i will check this email too:

	car...@ho...

I'm going to try to be back as soon as possible.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain