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

[Firebird-net-provider] Can't insert text with: $ ' " ,accents, and so on...

[Miguel M <bo...@ne...>]

Even using Server.HtmlEncode on the text I want to insert into a varchar
field I get this error
everytime the text has an accent (ex: é,á) or a & or a ' or a " (probably
more that i didn't test)

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: FirebirdSql.Data.INGDS.GDSException: Exception of type
FirebirdSql.Data.INGDS.GDSException was thrown.


I'm using firebird 1.5 rc5 and .net provider 1.1 for .net framework 1.0

Do I need to create fields with a special charset and collate?

Thanks

Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> When the new was available in the CVS :)

When the new module was available in the CVS, Sorry :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> When will this version be available?

When the new was available in the CVS :)

> Will the derive parameters method work with selectable stored procedures?

Humm n first place i'm going to add always te "execute procedure" string 
at the begining of the CommandText, and the CommandType needs to be 
always StoredProcedure, but after derive parameters you can changethe 
CommandText and CommandType properties, i have asked some time ago in 
the list to add stored procedure calls as in SqlServer, but only Alan 
MacDonald answer to it :) and i have left the idea





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] DeriveParameters question

[Rod C. <rod...@cl...>]

Carlos,

Fantastic! Just what I'm after :)

When will this version be available?

Will the derive parameters method work with selectable stored procedures?

Cheers
Rod.



---------------------------------------------------------------------------------------------------------------
Clearswift monitors, controls and protects all its messaging traffic in 
compliance with its corporate email policy using Clearswift products. 
Find out more about Clearswift, its solutions and services at 
www.clearswift.com.
***********************************************************************************
This communication is confidential and may contain privileged 
information intended solely for the named addressee(s). It may not 
be used or disclosed except for the purpose for which it has been 
sent. If you are not the intended recipient, you must not copy, 
distribute or take any action in reliance on it. Unless expressly stated, 
opinions in this message are those of the individual sender and not of 
Clearswift. If you have received this communication in error, please 
notify Clearswift by emailing su...@cl... quoting the 
sender and delete the message and any attached documents. Clearswift accepts no liability or responsibility for any onward transmission or use of emails and attachments having left the Clearswift domain.
This footnote confirms that this email message has been swept by 
MIMEsweeper for Content Security threats, including computer viruses.

Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> Yes that's exactly what I want to do :)

Thanks, finally i have implmented it in 1.5 version, an example:

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

FbCommandBuilder builder = new FbCommandBuilder();
			
FbCommand command = new FbCommand("GETVARCHARFIELD", connection);
			
command.CommandType = CommandType.StoredProcedure;
						
FbCommandBuilder.DeriveParameters(command);
			
Console.WriteLine("Derived Parameters");
			
for (int i = 0; i < command.Parameters.Count; i++)
{
	Console.WriteLine("Parameter name: {0}\tParameter Source 			 
Column:{1}\tDirection:{2}",
		command.Parameters[i].ParameterName,
		command.Parameters[i].SourceColumn,
		command.Parameters[i].Direction);
}
		
connection.Close();

The resulting command text ( that will be auto generated ) is:

execute procedure GETVARCHARFIELD(@ID)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] DeriveParameters question

[Rod C. <rod...@cl...>]

Hi,

Yes that's exactly what I want to do :)

Cheers
Rod.

-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: 05 August 2003 14:48
To: Rod Cotton
Cc: 'fir...@li...'
Subject: Re: [Firebird-net-provider] DeriveParameters question


Hello:

> Ideally I would like to be able to derive the parameters without=20
> having to know anything about the parameters in advance, this is=20
> possible with the SQL Server and Oracle data providers but I can't=20
> find a way to do it using Firebird.

If i understand well you want to derive parameters from anything like this:

FbCommand cmd =3D new FbCommand("execute procedure test_derive",=20
connection, transaction);

If i'm rigth the only way i know for this is to extract parameters from=20
database metadata, this would be easy to implement in 1.5 version ( it=20
has clases for extract schema information ), i'm rigth ??


Ideas and comments are wellcome :)




--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain


---------------------------------------------------------------------------=
------------------------------------
Clearswift monitors, controls and protects all its messaging traffic in=20
compliance with its corporate email policy using Clearswift products.=20
Find out more about Clearswift, its solutions and services at=20
www.clearswift.com.
***************************************************************************=
********
This communication is confidential and may contain privileged=20
information intended solely for the named addressee(s). It may not=20
be used or disclosed except for the purpose for which it has been=20
sent. If you are not the intended recipient, you must not copy,=20
distribute or take any action in reliance on it. Unless expressly stated,=
 opinions in this message are those of the individual sender and not of=20
Clearswift. If you have received this communication in error, please=20
notify Clearswift by emailing su...@cl... quoting the=20
sender and delete the message and any attached documents. Clearswift accept=
s no liability or responsibility for any onward transmission or use of emai=
ls and attachments having left the Clearswift domain.
This footnote confirms that this email message has been swept by=20
MIMEsweeper for Content Security threats, including computer viruses.

Re: [Firebird-net-provider] DeriveParameters question

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

Hello:

> Ideally I would like to be able to derive the parameters without having to
> know anything about the parameters in advance, this is possible with the SQL
> Server and Oracle data providers but I can't find a way to do it using
> Firebird.

If i understand well you want to derive parameters from anything like this:

FbCommand cmd = new FbCommand("execute procedure test_derive", 
connection, transaction);

If i'm rigth the only way i know for this is to extract parameters from 
database metadata, this would be easy to implement in 1.5 version ( it 
has clases for extract schema information ), i'm rigth ??


Ideas and comments are wellcome :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] DeriveParameters question

[Rod C. <rod...@cl...>]

Hello again,

Now that I've got a stored procedure to fill a DataSet I've moved onto
deriving the parameters for a stored procedure.

I've got a stored procedure that has two input and two output parameters.

The only way I've managed to derive the parameters is using the following
code...

FbTransaction transaction = connection.BeginTransaction();
FbCommand cmd = new FbCommand("execute procedure test_derive(?,?)",
connection, transaction);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
FbCommandBuilder.DeriveParameters(cmd);

Ideally I would like to be able to derive the parameters without having to
know anything about the parameters in advance, this is possible with the SQL
Server and Oracle data providers but I can't find a way to do it using
Firebird.

Many thanks
Rod.


---------------------------------------------------------------------------------------------------------------
Clearswift monitors, controls and protects all its messaging traffic in 
compliance with its corporate email policy using Clearswift products. 
Find out more about Clearswift, its solutions and services at 
www.clearswift.com.
***********************************************************************************
This communication is confidential and may contain privileged 
information intended solely for the named addressee(s). It may not 
be used or disclosed except for the purpose for which it has been 
sent. If you are not the intended recipient, you must not copy, 
distribute or take any action in reliance on it. Unless expressly stated, 
opinions in this message are those of the individual sender and not of 
Clearswift. If you have received this communication in error, please 
notify Clearswift by emailing su...@cl... quoting the 
sender and delete the message and any attached documents. Clearswift accepts no liability or responsibility for any onward transmission or use of emails and attachments having left the Clearswift domain.
This footnote confirms that this email message has been swept by 
MIMEsweeper for Content Security threats, including computer viruses.

[Firebird-net-provider] Re: Help returning multple rows from a stored procedure

[r_d_cotton <rod...@cl...>]

Hi,

Thanks, it's now working perfectly.

Cheers
Rod.

[Firebird-net-provider] Re: Help returning multple rows from a stored procedure

[Rod C. <rod...@cl...>]

Hi,
 
Thanks, works perfectly.
 
Cheers
Rod.


---------------------------------------------------------------------------------------------------------------
Clearswift monitors, controls and protects all its messaging traffic in 
compliance with its corporate email policy using Clearswift products. 
Find out more about Clearswift, its solutions and services at 
www.clearswift.com.
***********************************************************************************
This communication is confidential and may contain privileged 
information intended solely for the named addressee(s). It may not 
be used or disclosed except for the purpose for which it has been 
sent. If you are not the intended recipient, you must not copy, 
distribute or take any action in reliance on it. Unless expressly stated, 
opinions in this message are those of the individual sender and not of 
Clearswift. If you have received this communication in error, please 
notify Clearswift by emailing su...@cl... quoting the 
sender and delete the message and any attached documents. Clearswift accepts no liability or responsibility for any onward transmission or use of emails and attachments having left the Clearswift domain.
This footnote confirms that this email message has been swept by 
MIMEsweeper for Content Security threats, including computer viruses.

Re: [Firebird-net-provider] Help returning multple rows from a stored procedure

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

Hello:

> FbCommand command = new FbCommand(
> 	"SELECT P_POLICYID, P_POLICY FROM usp_pmi_GetPolicyList", 
> 	connection, 
> 	connection.BeginTransaction());
> command.CommandType = System.Data.CommandType.StoredProcedure;

You don't need to set the CommandType to CommandType.StoredProcedure in 
this case, because what you are really executing is a SELECT statement, 
try removing it and tell the results :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Help returning multple rows from a stored procedure

[r_d_cotton <rod...@cl...>]

Hi,

I've been looking at Firebird and the .net provider for a couple of 
days, everything was going fine until I tried to return multiple rows 
from a stored procedure.

Here is the code for the procedure...

SET TERM ^ ;

ALTER PROCEDURE USP_PMI_GETPOLICYLIST 
RETURNS (
    P_POLICYID NUMERIC(18,0),
    P_POLICY VARCHAR(250))
AS
begin
  FOR
    SELECT
        POLICYID,
        POLICY
    FROM
        pmi_policy
    INTO
        :P_POLICYID,
        :P_POLICY
    DO
  suspend;
end

^

SET TERM ; ^

When I run the procedure from within IB Expert with...
select P_POLICYID, P_POLICY from usp_pmi_getpolicylist
I get six rows displayed.

However when I execute the stored procedure using...

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

FbCommand command = new FbCommand(
	"SELECT P_POLICYID, P_POLICY FROM usp_pmi_GetPolicyList", 
	connection, 
	connection.BeginTransaction());
command.CommandType = System.Data.CommandType.StoredProcedure;

FbDataAdapter da = new FbDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds);
connection.Close();

I get the exception "multiple rows in singleton select"

Can anyone tell me what I'm doing wrong?

Thanks
Rod.

Re: [Firebird-net-provider] Closing connections

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

Hello:

> 		~myconnectionclass()
> 		{
> 			if (m_Connection != null)
> 			{
> 				if (m_Connection.State == ConnectionState.Open )
> 				{
> 					m_Connection.Close();
> 				}
> 
> 				m_Connection = null;
> 			}
> 		}
> 
> But sometimes, although the connection is not null and is
> ConnectionState.Open
> when it arrives to m_Connection.Close it throws an exception:
> 
> An unhandled exception of type 'System.NotSupportedException' occurred in
> mscorlib.dll
> Additional information: Stream does not support writing.
> 
> What am I doing wrong??

Huummm i think it's better to make this in a Dispose method implementing 
IDisposable interface, i was with the same problem some time ago in the 
.NET provider for release resources allocated for statements :) , check 
the status of the m_connection.IscConnection.db object, checking the 
state of sockets and streams, if it's the same problem as i have this 
will be no valid.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Closing connections

[Jesus A. <ja...@er...>]

Hi all,

I am using 1.1 Alpha 2 - .NET 1.0

I have a single connection that I keep using during all the application.
It is a class that creates the connection the first time it is required and
in the override of the System.object.Finalize method I close the connection:

		~myconnectionclass()
		{
			if (m_Connection != null)
			{
				if (m_Connection.State == ConnectionState.Open )
				{
					m_Connection.Close();
				}

				m_Connection = null;
			}
		}

But sometimes, although the connection is not null and is
ConnectionState.Open
when it arrives to m_Connection.Close it throws an exception:

An unhandled exception of type 'System.NotSupportedException' occurred in
mscorlib.dll
Additional information: Stream does not support writing.

What am I doing wrong??

Regards,
Jesus

Re: [Firebird-net-provider] Timeout expired - problem with connection lifetime

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

Hello:

> I am using follwoing .Net provider -
> FirebirdNetProvider-1.0-NF1.0

I can't find this exception message 1. sources, can you send a test case ??






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Timeout expired - problem with connection lifetime

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

Hello:

> When i run the application, sometimes i get the error
> -
> 
> "Timeout expired. The timeout period elapsed prior to
> obtaining a connection from the pool. This may have
> occurred because all pooled connections were in use
> and max pool size was reached."

Are you sure you are getting this error from the .NET PRovider, i have 
not found an exception message like this in 1.1 and 1.5 sources which 
version of the net-provider are you using ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Timeout expired - problem with connection lifetime

[Ghanshyam P. <gh_...@ya...>]

Hello,
 I have a .Net application. The connection string used
is -

"User=SYSDBA;Password=masterkey;DataSource=localhost;Port=3050;Database=C:\Test.gdb;Dialect=3;Charset=None;Connection
lifetime=30;Pooling=true;"

When i run the application, sometimes i get the error
-

"Timeout expired. The timeout period elapsed prior to
obtaining a connection from the pool. This may have
occurred because all pooled connections were in use
and max pool size was reached."


I am bit confused with connection lifetime and
pooling. Whether its good practice to include
pooling=true. if yes, then what should be the
lifetime?
If i drop the pooling i.e. pooling=false, what effect
will be there on the performance of the application?
i.e if i don't use the pooling at all, then will it be
harmfull?

Thanx in advance for any help.

Regards,
Ghanshyam.

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

Re: [Firebird-net-provider] NET Provider 1.5 & MS.AppBlocks.Data

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

Hello:

> When a working release of NET Provider 1.5 is released, I am going to 
> convert the Microsoft.ApplicationBlocks.Data v2 class to be used with 
> Firebird instead.  I'm sure it will make life easier on using the FB 
> classes.

I have changed the class SqlHelper to be FirebirdHelper and changed all 
SqlXXX class references to FbXXXX classes :) i have not tested it yet 
but i think i will test it with 1.5 version when it's released :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Embeded database

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

Hello:

> I am trying to use the embeded version of Firebird and am unable to connect
> to it.

The .NET Data provider doesn't work with Firebird embeded version 
because it has his own GDS implementation.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Embeded database

[Ishan B. <ish...@ho...>]

Hello,

I am trying to use the embeded version of Firebird and am unable to connect
to it.

I have done the following:

1. I made a copy of the the following support  files in the application
directory:
  /my_app/app.exe
  /my_app/gds32.dll
  /my_app/firebird.conf
  /my_app/fb/firebird.msg
  /my_app/fb/intl/fbintl.dll
  /my_app/fb/udf/fbudf.dll

2. I also put a copy of the same, in the same directory as:
FirebirdSql.Data.Firebird.dll

3. I removed the reference to local host, but when i try to conect i keep
getting the msg 'Unable to conect to Local host'

Can I get a detailed procedure on how to go about this problem.

Thank you.
Regards,
Ishan

Re: [Firebird-net-provider] Command Builder

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

Hello:

> Is there a Visual SQL command builder for Firebird .Net provider. If yes 
> where can I download it.

At this moment no.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Command Builder

[Sandeep C. <sa...@cf...>]

Is there a Visual SQL command builder for Firebird .Net provider. If yes 
where can I download it.

Regards

Sandeep

[Firebird-net-provider] C# Personal

[Tom K. <to...@tw...>]

Thanks for the tip. My setup is correct but still no connection.  I =
reinstalled the framework and ibprovider.  Now it works no problem.  Go =
figure.

Thank You For Your Time,
Tom

Re: [Firebird-net-provider] Urgent help needed-Problem with Firebird DB

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

Hello:

> database) and it doesn't give any error also. The .Net
> provider is also installed properly. If the setup is
> executed on the 


Are you sure you have all weel configured in IIS ( if this is the 
ASP.NET server you are using ) and that the connection string for the 
.NET Provider is correct, and that you have the .NET framework well 
installed ???





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] SELECT ... FOR UPDATE implementation

[Willibald K. <wi...@dw...>]

> As i don't know other than the ADO.NET Documentation existent in the
> .NET Framework :) , i'm using as "standard" the SqlClient and OleDb
> Providers Documentation.

Thanks for the hint. I'll probably have to do some readup before I
completely understand ADO.NET :-)

Willi