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

Re: [Firebird-net-provider] Select statements and transactions

[<car...@te...>]

Hello:

> Is connection pooling just turned on in the connection string or is there a
> .net setting to do this.

This is done using the connection string:

	Pooling=false

Try this and comment the results please :):

<add key="DbConnectionString"
value="Database=C:\\Inetpub\\wwwroot\\NZ\\_database\\RESTOREDB.GDB;User=SYSDBA;
Password=masterkey;Dialect=3;Server=localhost;Pooling=false"/>



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi,

I have not knowingly turned on/off connection pooling so I guess I am using
the default of ON.

Is connection pooling just turned on in the connection string or is there a
.net setting to do this.

The connection string that I am using is this (from my web config file)

<add key="DbConnectionString"
value="Database=C:\\Inetpub\\wwwroot\\NZ\\_database\\RESTOREDB.GDB;User=SYSD
BA;Password=masterkey;Dialect=3;Server=localhost"/>

would I have to add some sort of attribute to this to disable connection
pooling?? could you help me out here please??

cheers

martin.




"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:400...@te......
> Hello:
>
> > I noticed that the code you provided added the call to dispose on the
> > command object. This seemed to have no effect.
>
> Ok, thanks, one question, are you using connection pooling ?? it's
> enabled by default and with it enabled connections are not really closed
> when you call FbConnection.Close method, they return to the pool and
> will be closed when they are expired.
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Select statements and transactions

[<car...@te...>]

Hello:

> I noticed that the code you provided added the call to dispose on the
> command object. This seemed to have no effect.

Ok, thanks, one question, are you using connection pooling ?? it's 
enabled by default and with it enabled connections are not really closed 
when you call FbConnection.Close method, they return to the pool and 
will be closed when they are expired.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi Carlos,

Thanks for the reply.
I am using .NET Data Provider release candidate 2.

I pasted in the code you provided but still I get error "sharing violation"
when I go to delete the .gdb file after I have run my dot net code agaist
it.

here is the process I am following.
1. Locate the file (.gdb) that my web app (vb.net) will use and replace it
with a fresh copy.
2. Run my web app agaist the fresh copy of the database once.
3. Again locate the file (.gdb) and attempt to delete it via windows
explorer. This gives me "sharing violation" and since the only thing that
accessed the database        was my dot net code then I am assuming that
this is causing some sort of locking.

4. Start the firebid control panel app and attempt to stop the service. At
this point I get an error dialog saying "overlapped I/O" operation, although
I am still able to stop the service and delete the file.

Now I start the process of making small changes to my dot net code that
accesses the database and restarting the whole process from stage 1 over
again.
I noticed that the code you provided added the call to dispose on the
command object. This seemed to have no effect.

cheers

martin.







"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3FF...@te......
> Hello:
>
> >       After I have done a select statement through the .net provider do
I
> > have to commit it? and if so what is the procedure.
>
> Which version of the .NET Data Provider are you using ?? Are you using
> connection pooling ?? (it's enabled by default)
>
> > The code I am running to populate my drop dowm box is
>
> Try this:
>
> Dim strSQL As String = "select  ID, DISPLAY_TEXT from EE_SP_NAME
>   ORDER BY DISPLAY_TEXT"
> Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
>   FirebirdSql.Data.Firebird.FbConnection
> Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
> FirebirdSql.Data.Firebird.FbCommand
> Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
> Dim objReader As FirebirdSql.Data.Firebird.FbDataReader
> objConn.ConnectionString =
> ConfigurationSettings.AppSettings("DbConnectionString")
> objCMD.CommandText = strSQL
> objCMD.CommandType = CommandType.Text
> objConn.Open()
> objCMD.Connection = objConn
> objReader = objCMD.ExecuteReader()
> CmbTargetGroup.DataSource = objReader
> CmbTargetGroup.DataValueField = "ID"
> CmbTargetGroup.DataTextField = "DISPLAY_TEXT"
> CmbTargetGroup.DataBind()
> objReader.Close()
> objCMD.Dispose()
> objConn.Close()
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Perforce Software.
> Perforce is the Fast Software Configuration Management System offering
> advanced branching capabilities and atomic changes on 50+ platforms.
> Free Eval! http://www.perforce.com/perforce/loadprog.html
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Select statements and transactions

[<car...@te...>]

Hello:

>       After I have done a select statement through the .net provider do I
> have to commit it? and if so what is the procedure.

Which version of the .NET Data Provider are you using ?? Are you using 
connection pooling ?? (it's enabled by default)

> The code I am running to populate my drop dowm box is

Try this:

Dim strSQL As String = "select  ID, DISPLAY_TEXT from EE_SP_NAME
  	ORDER BY DISPLAY_TEXT"
Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
  	FirebirdSql.Data.Firebird.FbConnection
Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
	FirebirdSql.Data.Firebird.FbCommand
Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
Dim objReader As FirebirdSql.Data.Firebird.FbDataReader
objConn.ConnectionString =
	ConfigurationSettings.AppSettings("DbConnectionString")
objCMD.CommandText = strSQL
objCMD.CommandType = CommandType.Text
objConn.Open()
objCMD.Connection = objConn
objReader = objCMD.ExecuteReader()
CmbTargetGroup.DataSource = objReader
CmbTargetGroup.DataValueField = "ID"
CmbTargetGroup.DataTextField = "DISPLAY_TEXT"
CmbTargetGroup.DataBind()
objReader.Close()
objCMD.Dispose()
objConn.Close()




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Select statements and transactions

[Martin <mc...@we...>]

Hi,

      After I have done a select statement through the .net provider do I
have to commit it? and if so what is the procedure.

The reason I ask is that I have a drop down box in my web app which is
populated with a datareader. The code populates the drop down box perfectly,
however I noticed that straight after running this code I was unable to
delete the actual .GDB file from windows explorer (NOTE. at present this is
the only data access function in my entire app). The error message when I
tried to delete the file was "sharing violation","..The source file may be
in use"

Now I don't actual want to delete the file, I am just using this method as a
test to see if there has been any sharing violation caused with my code
(which may cause other issues in the future).

I have also noted the following behaviour. If I run my piece of code that
populates my drop down box once and then go to the "firebird guardian" in
control panel and attempt to stop the firebird service, I get the error
message "Overlapped I/O operation in progress", although upon pressing OK
the firebird service is stopped successfully, and I can now delete the file.

so now I start over again with another copy of my .GDB file, I run the code
to populate the drop down box again and it runs successfully, but after
running it I can't delete the .GDB file because of the same error message
that states there has been a sharing violation , despite the fact that my
connection is now closed.

The code I am running to populate my drop dowm box is

        Dim strSQL As String = "select  ID, DISPLAY_TEXT from EE_SP_NAME
ORDER BY DISPLAY_TEXT"
        Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
FirebirdSql.Data.Firebird.FbConnection
        Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
FirebirdSql.Data.Firebird.FbCommand
        objConn.ConnectionString =
ConfigurationSettings.AppSettings("DbConnectionString")
        objCMD.CommandText = strSQL
        objCMD.CommandType = CommandType.Text
        objConn.Open()
        objCMD.Connection = objConn
        CmbTargetGroup.DataSource = objCMD.ExecuteReader()
        CmbTargetGroup.DataValueField = "ID"
        CmbTargetGroup.DataTextField = "DISPLAY_TEXT"
        CmbTargetGroup.DataBind()
        objConn.Close()

This code seems to close the connection ok (I've never had similar problems
with it when using ms access or ms sql server)

Now I realize that the above code does not have any transactions in it, so I
figured this may be the problem (after all IB Expert always asks me if I
want to commit SELECT statements..although I have no idea why..) so I put
a transaction in the code as follows


        Dim strSQL As String = "select  ID, DISPLAY_TEXT from EE_SP_NAME
ORDER BY DISPLAY_TEXT"
        Dim objConn As FirebirdSql.Data.Firebird.FbConnection = New
FirebirdSql.Data.Firebird.FbConnection
        Dim objCMD As FirebirdSql.Data.Firebird.FbCommand = New
FirebirdSql.Data.Firebird.FbCommand
        Dim objTran As FirebirdSql.Data.Firebird.FbTransaction
        Dim objReader As FirebirdSql.Data.Firebird.FbDataReader
        objConn.ConnectionString =
ConfigurationSettings.AppSettings("DbConnectionString")
        objCMD.CommandText = strSQL
        objCMD.CommandType = CommandType.Text
        objConn.Open()
        objTran = objConn.BeginTransaction()
        objCMD.Connection = objConn
        objCMD.Transaction = objTran
        objReader = objCMD.ExecuteReader()
        CmbTargetGroup.DataSource = objReader
        CmbTargetGroup.DataValueField = "ID"
        CmbTargetGroup.DataTextField = "DISPLAY_TEXT"
        CmbTargetGroup.DataBind()
        objReader.Close()
        objTran.Commit()
        objConn.Close()

But still I get the shareing violation when I go to delete the file.

I would be greatful if somebody could shed some light on this matter for me.
I am assuming this sharing violation is being caused because I am not
handling my data access correctly through the .net provider, but this has me
a little stumped.

many thanks in advance for any help.

martin.

Re: [Firebird-net-provider] dynamic SQL error

[<car...@te...>]

Hello:

> I downloaded the latest versions of both the server and the
> data provider. I don't have the code here (the internet doesn't
> work in my office at the moment) but to make sure I did not
> make a mistake, I tried using the example from FbCommand page
> from the provider documentation. It really doesn't make
> any sense to me...

Are you testing with anything like this ?? :

FbConnection connection = new FbConnection(connectionString);
connection.Open();

string sql = "select * from employee";

FbCommand command = new FbCommand(sql, connection);

FbDataReader reader = command.ExecuteReader();

while (reader.Read())
{
	Console.WriteLine(reader[0]);
}

command.Dispose();

connection.Close();



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] dynamic SQL error

[<car...@te...>]

Hello:

> I'm basically just trying to make it work, it means I simply
> use the sample employee.fdb database and the simplest possible command
> i.e. SELECT * FROM employee

Can you send a test case ?? which version of the .NET Data Provider are 
you using ??




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] dynamic SQL error

[<su...@qu...>]

I=27m basically just trying to make it work=2C it means I simply
use the sample employee=2Efdb database and the simplest possible command
i=2Ee=2E SELECT * FROM employee

When I try to do the same using ISQL everything works perfectly

----- P=F9vodn=ED zpr=E1va -----
Od=3A Carlos Guzm=E1n =C1lvarez =3Ccarlosga=40telefonica=2Enet=3E
Datum=3A =E8tvrtek=2C 8=2E ledna 2004 v 12=3A58 odp
P=F8edm=ECt=3A Re=3A =5BFirebird-net-provider=5D dynamic SQL error

=3E Hello=3A
=3E =

=3E =3E Can anybody help me please=3F
=3E =

=3E Can you send the CommandText thta you are =

=3E trying to execute=2C please=3F=3F
=3E =

=3E =

=3E --
=3E Best regards
=3E =

=3E Carlos Guzm=E1n =C1lvarez
=3E vigo-Spain
=3E =

=3E =

=3E ---------------------------------------------
=3E ----------
=3E This SF=2Enet email is sponsored by=3A Perforce =

=3E Software=2EPerforce is the Fast Software =

=3E Configuration Management System offering
=3E advanced branching capabilities and atomic =

=3E changes on 50+ platforms=2E
=3E Free Eval! =

=3E http=3A//www=2Eperforce=2Ecom/perforce/loadprog=2Ehtml=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=
=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F=5F
=3E Firebird-net-provider mailing list
=3E Firebird-net-provider=40lists=2Esourceforge=2Enet
=3E https=3A//lists=2Esourceforge=2Enet/lists/listinfo/firebird-net-provi=
der
=3E 

Re: [Firebird-net-provider] dynamic SQL error

[<car...@te...>]

Hello:

> Can anybody help me please?

Can you send the CommandText thta you are trying to execute, please??


--
Best regards

Carlos Guzmán Álvarez
vigo-Spain

[Firebird-net-provider] dynamic SQL error

[<su...@qu...>]

Hi,
I can't make my .NET data provider for Firebird work.
I have Firebird 1.5 RC 8, the appropriate .Net driver and
i'm using Visual Studio (C#) .NET 2003. (on Windows XP)
I have no problems to establish a connection, start a transaction
but whenever I try to execute a command (anyhow) the driver throws
an exception. It says Dynamic SQL error - 901, feature is not supported.

I have tried several versions of Firebird and/or the driver but
everything keeps being the same.
I'm trying everything locally.

Can anybody help me please?

thanks a million

[Firebird-net-provider] Developement status report

[<car...@te...>]

Hello:

1.5 Sources:

The only changes done here since RC2 release are back ported from 1.6 
sources and are related to FbParameter and FbParameterCollection classes.

- Added changes for better handling of parameter collections
(checked against SqlClient provider):

	-Throw an exception when trying to add a parameter to a
	FbParameterCollection instance that is already owned by
	a different FbParameterCollection instance.

	-Generate a new parameter name when the parameter to add
	has no name.					

	-Throw an exception when trying to add a parameter two 			times to the 
same collection.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] How to save images in Blobs ?

[<car...@te...>]

Hello:

>                         _cmdText = "INSERT INTO T_ARTICLE(A_ARTICLE_ID, 
> A_IDENT, A_NAME, A_DESCRIPTION,A_IMAGE) ";
>                         _cmdText += " 
> VALUES(@articleId,@articleIdent,@articleName,@articleDescription,@articleImage) 
> ";

The code seems to be ok (if A_IMAGE is a binary blob field)

> _command.Parameters.Add("@articleImage",FirebirdSql.Data.Firebird.FbDbType.Binary).Value 
> = articleImage.Image;

You need to set the parameter value as byte array.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] How to save images in Blobs ?

[Hugo H. <hug...@gm...>]

HI, I'd like to save images in a blob field. 
 
But I don't know which FbType to use for the parameter creation.
 
I use following sql:
 
                        _cmdText = "INSERT INTO T_ARTICLE(A_ARTICLE_ID,
A_IDENT, A_NAME, A_DESCRIPTION,A_IMAGE) ";
                        _cmdText += "
VALUES(@articleId,@articleIdent,@articleName,@articleDescription,@articleIma
ge) ";
 
 
And one of my parameter description is
 
 
_command.Parameters.Add("@articleImage",FirebirdSql.Data.Firebird.FbDbType.B
inary).Value = articleImage.Image;
 
articleImage is a PictureBox  and the whole stuff is written in C#.
 
Could anyone please give me a hint how to do this with this provider ? 
 
Thanks in advance
Oliver

Re: [Firebird-net-provider] The @ sign

[<car...@te...>]

Hello:

> Whenever I insert a string with an '@' sign via FbCommand + 
> ExecuteScalar, the string seems to get mangled.  For example, inserting 
> "rc...@mo..." results to the string "rchiang?.com" being inserted 
> instead.


This is know issue due to a limitation in the named parameters support, 
you can solve it using parametrized querys.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] The @ sign

[Dick C. <rc...@mo...>]

Hello,

Whenever I insert a string with an '@' sign via FbCommand + 
ExecuteScalar, the string seems to get mangled.  For example, inserting 
"rc...@mo..." results to the string "rchiang?.com" being inserted 
instead.

My connection string is using Charset=ISO8859_1 (not sure if that's 
relevant).  I'm using the Firebird 1.0.x server for Linux and 
FirebirdNetProvider1.5-RC2.

Dick

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

[<car...@te...>]

Hello:

> Tested on the following configurations:
> 
> W2K, .NET 1.1, Firebird 1.0 on Linux and Windows
> W2K, .NET 1.1, Firebird 1.5 on Linux and Windows
> W2K3, .NET 1.1, Firebird 1.0 on Linux and Windows
> W2K3, .NET 1.1, Firebird 1.5 on Linux and Windows
> 
> Just my 2 cents :-)

Thanks very much :)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

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

Carlos Guzmán Álvarez wrote:

> Now than the 1.5 RC2 is released, i am thinking on when i am going to
> release the final version, i am thinking on have one more RC and after
> it release the final version, but, first i want to know what are the
> opinions about performance, stability, features, ... from the people
> that is using the 1.5 version.

Hello Carlos,
I have had it in production since the first alpha. It shows great
performances and seems very stable.
We're using it in a lot of web project, two of which are managing millions
records.

Tested on the following configurations:

W2K, .NET 1.1, Firebird 1.0 on Linux and Windows
W2K, .NET 1.1, Firebird 1.5 on Linux and Windows
W2K3, .NET 1.1, Firebird 1.0 on Linux and Windows
W2K3, .NET 1.1, Firebird 1.5 on Linux and Windows

Just my 2 cents :-)

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Command must have a valid transaction

[<car...@te...>]

Hello:

> Does anyone have any idea what I am doing wrong?

I have tested it with this code:

FbConnection connection = new FbConnection(connectionString);
connection.Open();

string sql = "select * from divisacb";

DataSet	m_patientListDS	= new DataSet("PatientList");
FbDataAdapter m_patientAdapter = new FbDataAdapter();
			m_patientAdapter.TableMappings.Add("Table", "RS_PatientLevel");

FbCommand patientCommand = new FbCommand(sql, connection);
patientCommand.CommandType = CommandType.Text;	
m_patientAdapter.SelectCommand = patientCommand;

m_patientAdapter.Fill(m_patientListDS);

connection.Close();

having no problem, tell to me if it's no correct.

Which version of the .NET Data Provider are you using ?? Can you send a 
test case ??



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Command must have a valid transaction

[Wilhelmina M. <w.m...@ve...>]

Hello,

=20

I am trying to convert some C# code the uses MSDE database with Firebird
database.  When I execute the following code:

=20

private DataSet m_patientListDS =3D new DataSet("PatientList");

private FbDataAdapter m_patientAdapter =3D new FbDataAdapter();

=20

m_patientAdapter.TableMappings.Add("Table", "RS_PatientLevel");

FbCommand patientCommand =3D new FbCommand(SELECT_FROM_PatientLevel(),
OpenConnection());

patientCommand.CommandType =3D CommandType.Text;

m_patientAdapter.SelectCommand =3D patientCommand;

m_patientAdapter.Fill(m_patientListDS);

=20

I catch the following exception when the fifth line is executed:

=20

Message:  "Command must have a valid Transaction."

_COMPlusExceptionCode: -532459699

HResult: -2146233079

=20

Note that the FbComand parameters SELECT_FROM_PatientLevel() is simply a
function that returns the string to select the rows of an entire table =
and
OpenConnection() returns an open FbConnection.

=20

These lines of code fails at the initialization step when the table is =
empty
and no rows are returned.  When I run the same code using MSDE under the
same conditions, I get no error.

=20

Does anyone have any idea what I am doing wrong?

=20

Mimi Maloles=20

=20

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

[<car...@te...>]

Hello:

> There are some little examples, but for C# and VB.NET only.
> 
> The help file have some simple samples too.

And the NUnit test suite but it's in C# too :)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

[<car...@te...>]

Hello:

> I would like to try this with Delphi 8, do you have any nice examples?

There are some little examples, but for C# and VB.NET only.

The help file have some simple samples too.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

[Tony C. <ac...@am...>]

I would like to try this with Delphi 8, do you have any nice examples?

--
Tony Caduto
AM Software Design
Inexpensive Corporate Instant Messaging
http://www.amsoftwaredesign.com

[Firebird-net-provider] Firebird .NET Data Provider 1.5 opinions

[<car...@te...>]

Hello:

Now than the 1.5 RC2 is released, i am thinking on when i am going to 
release the final version, i am thinking on have one more RC and after 
it release the final version, but, first i want to know what are the 
opinions about performance, stability, features, ... from the people 
that is using the 1.5 version.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Connection Open Error

[<car...@te...>]

Hello:

> You suggest that I return to RC1?  I seem to recall reading from the 
> list previously that RC3 is for 1.1 .NET Framework, while RC1 is for 
> 1.0.  My system has Visual Studio with 1.0 .NET Framework, but I also 
> manually installed the 1.1 .NET Framework Runtime.

Sorry, I mean .NET Provider 1.5 RC1, the RC3 was not released yet, RC2 
was released today, both RC1 and RC2 versions of the .NET Data Provider 
have installations for the .NET Framework 1.0 and 1.1.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain