firebird-net-provider Mailing List for Firebird (Page 3)

Jason,
Don't forget that even a select statement needs to be committed since it
will start a trasnaction whether you like it or not. I know there's no
change but it still need to be committed.
Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Jason Vene
> Sent: Sunday, 15 June 2003 7:08 PM
> To: fir...@li...
> Subject: [Firebird-net-provider] Question: Why must I have a transaction
> object supplied for command object?
>
>
> Here's the situation:
>
> I want to perform a simple SELECT * FROM SALES, read
> the data and still be able to use the open connection
> to continue reading.
>
> I'm developing simultainous versions of the app using
> both FbConnection/FbCommand/FbReader and
> SqlConnection/SqlCommand/SqlReader from application
> level objects that abstract to them.
>
> When I perform the "ExecutReader" on the command with
> SqlCommand, I can do that without supplying a
> SqlTransaction object, and continue to use the
> connection on subsequent readers and such.
>
> With FbCommand, however, it throws an exception if the
> transaction isn't supplied (which the source clearly
> shows it requires, without option).
>
> This means I can't use the connection until that
> transaction is committed or rolled back. I can't
> commit the transaction, because there's nothing to
> commit - I'm only reading the data. I can't rollback
> either, both throw exceptions.
>
> Related to this question, I'm downloading the mono C#
> compiler tools, but I wondered how (and perhaps why
> not) I might build the source for the .NET provider
> within VS.NET2003?  I want to pull out the exception
> throw when transaction is found to be null - I don't
> quite understand any reason the transaction is always
> required.
>
> Perhaps there's something else about this I simply
> don't understand.
>
> Many thanks......
>
> Jason
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
>
> -------------------------------------------------------
> 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

Hello:

> Sorry for my ignoranza :
> 
> dataset are not into System.Data

Yes ( but the dataset is database independant ).

> and System.Data not depending from MDAC?

As i know no ( i think the OleDB and ODBC providers yes for obvious 
reasons ).




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Sorry for my ignoranza :

dataset are not into System.Data and System.Data not depending from MDAC?

Best regards
Marco


"Carlos Guzman Alvarez" <car...@te...> ha scritto nel messaggio
news:3EE...@te......
> Hello:
>
> >      i'm interested to develop an interface similary to Access using
> > firebird engine ,Net Provider,C#  and MDAC.
>
> Did you mean a Database Manager ?? ( I think you don't need MDAC )
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain

Hello:

>      i'm interested to develop an interface similary to Access using
> firebird engine ,Net Provider,C#  and MDAC.

Did you mean a Database Manager ?? ( I think you don't need MDAC )





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hello:

 > This means I can't use the connection until that
 > transaction is committed or rolled back. I can't
 > commit the transaction, because there's nothing to
 > commit - I'm only reading the data. I can't rollback
 > either, both throw exceptions.

Can you send a test case ?? which exception are you getting ??. as i 
know this is working well.

> Related to this question, I'm downloading the mono C#
> compiler tools, but I wondered how (and perhaps why
> not) I might build the source for the .NET provider
> within VS.NET2003?  I want to pull out the exception
> throw when transaction is found to be null - I don't
> quite understand any reason the transaction is always
> required.

The transaction is always required beacuse Firbird requires it always 
:), i can modify the provider for "solve" this ?? yes, i like this ?? in 
first place no :), if you start always a transaction your code will work 
with both Firebird and SQL Server ( and other too ).

At this moment VS projects doesn't exists, you can build the provider 
using NAnt ( nant.sourceforge.net )







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Hi all,
i have a question :
     i'm interested to develop an interface similary to Access using
firebird engine ,Net Provider,C#  and MDAC.
    Is it  possible or i have licensing limits for using MDAC to develop a
similary product  ?
    I'm not found a unique response ?
    Your opinion?
Thank you in advance
Best Regards
Marco

P.S. sorry for my english  :-))

Here's the situation:

I want to perform a simple SELECT * FROM SALES, read
the data and still be able to use the open connection
to continue reading.

I'm developing simultainous versions of the app using
both FbConnection/FbCommand/FbReader and
SqlConnection/SqlCommand/SqlReader from application
level objects that abstract to them.

When I perform the "ExecutReader" on the command with
SqlCommand, I can do that without supplying a
SqlTransaction object, and continue to use the
connection on subsequent readers and such.

With FbCommand, however, it throws an exception if the
transaction isn't supplied (which the source clearly
shows it requires, without option).

This means I can't use the connection until that
transaction is committed or rolled back. I can't
commit the transaction, because there's nothing to
commit - I'm only reading the data. I can't rollback
either, both throw exceptions.

Related to this question, I'm downloading the mono C#
compiler tools, but I wondered how (and perhaps why
not) I might build the source for the .NET provider
within VS.NET2003?  I want to pull out the exception
throw when transaction is found to be null - I don't
quite understand any reason the transaction is always
required.

Perhaps there's something else about this I simply
don't understand.

Many thanks......

Jason


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Hello:


I have commited to the CVS, branch "branch-release-1-1", the first 
revision of the Firebird Events API implementation, it's not finished 
yet, i want to make more test and add a new nunit test, but all comments 
and suggestions are welcome :)


Thanks to Tedd for his feedback on this.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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?


As Alan already tell to you i'm working in Events API implementation 
now, i hope to have it for testing soon :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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?


As Alan already tell to you i'm working in Events API implementation 
now, i hope to have it for testing soon :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

You need events and the events API is just being worked on at this time by
Carlos.
If you are not too experienced, then working with events may not be
advisable anyway - it depends what you are really trying to do.
You maybe be advised to raise your queries at the firebird support list - go
to IBPhoenix.com to get the list address.

Alan

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of
> Mike Lavender
> Sent: Saturday, 14 June 2003 11:55 AM
> To: fir...@li...
> Subject: [Firebird-net-provider] Can I receive notifications of Events?
>
>
> 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
>
>
>
>
> -------------------------------------------------------
> 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
>

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

> 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

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

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

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.

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!

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!

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.

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.

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.

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

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

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