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

Re: [Firebird-net-provider] Transliterate character

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

Hello:

> I have some problems with different character sets. I
> have a table with a column of type VARCHAR(32764)
> CHARACTER SET ISO8859_1 and want to use the Firebird
> .Net Dataprovider (1.5.1318.34382) to insert rows.
> Here an example from C++ .NET:

Which character set are you using in the Connection String and the 
firebird Database ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: R: [Firebird-net-provider] Example application for .NET Data Provider 1.5

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

Hello:

> I was looking for it a few days ago but I saw it was not implemented. It is
> very useful, especially in those applications (at most ASP.NET) that uses
> (or should :-)) Stored Procedure a lot. Again you have my vote (for both).

I have not implemented the stored proc execution format yet ( only in 
FbCommandBuilder.DeriveParameters ) and the Data Block needs to have 
more test after implement this feature ( if finally it's ) and i have 
not commited it on CVS ( i need to review the license ;) )




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Transliterate character

[<oas...@ya...>]

Hello,

I have some problems with different character sets. I
have a table with a column of type VARCHAR(32764)
CHARACTER SET ISO8859_1 and want to use the Firebird
.Net Dataprovider (1.5.1318.34382) to insert rows.
Here an example from C++ .NET:

IDbCommand* pCMD = m_DBConnection->CreateCommand();
IDbTransaction* pTrans =
m_DBConnection->BeginTransaction(IsolationLevel::ReadCommitted);
pCMD->Transaction = pTrans;
pCMD->CommandText = "INSERT INTO TEST VALUES ('ä')" 
pCMD->ExecuteNonQuery();
pTrans->Commit();

This doesn’t work. ExecuteNonQuery yields this
message:

arithmetic exception, numeric overflow, or string
truncation
Cannot transliterate character between character sets

The CommandText property is a Unicode string
containing a character above ASCII 127 ('ä'). How can
I write this character to the table field of type
ISO8859_1?

Can anybody help me?

Thanks, OAS


__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
Logos und Klingeltöne fürs Handy bei http://sms.yahoo.de

R: [Firebird-net-provider] Example application for .NET Data Provider 1.5

[Alessandro P. <ale...@al...>]

Carlos,

> > Two separate examples could show the differences between the two 
> > methods listed above. The second is the most interesting 
> and elegant.
> > 
> > Do you have a working Data Block for Firebird?
> 
> I have ported the SQL Server Data Block 2.0 for use the Firebird 
> provider, but seems to be focused too much on the use of 
> Stored Procs ( 
> this is my first impression ) and one more time i'm thinking 
> on add to 
> the net provider calls of Stored Procs as in SqlClient an example:
> 
> FbCommand command = new FbCommand("stored_proc_name", connection);
> 
> instead of :
> 
> FbCommand command = new FbCommand("execute procedure 
> stored_proc_name(?,?,?,?)", connection);
> 
> 
> I have made few test yet with it but it can be useful :)

I was looking for it a few days ago but I saw it was not implemented. It is
very useful, especially in those applications (at most ASP.NET) that uses
(or should :-)) Stored Procedure a lot. Again you have my vote (for both).

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Example application for .NET Data Provider 1.5

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

Hello:

> I can help you with ASP.NET starting from September (I will be on holidays
> from tomorrow to 1th September).

Thanks :)

> Two separate examples could show the differences between the two methods
> listed above. The second is the most interesting and elegant.
> 
> Do you have a working Data Block for Firebird?

I have ported the SQL Server Data Block 2.0 for use the Firebird 
provider, but seems to be focused too much on the use of Stored Procs ( 
this is my first impression ) and one more time i'm thinking on add to 
the net provider calls of Stored Procs as in SqlClient an example:

FbCommand command = new FbCommand("stored_proc_name", connection);

instead of :

FbCommand command = new FbCommand("execute procedure 
stored_proc_name(?,?,?,?)", connection);


I have made few test yet with it but it can be useful :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Example application for .NET Data Provider 1.5

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......

> Now than the first alpha of 1.5 version was released i'm thinking on
> start with the suggestion made some time ago by Sean Leyne of make a
> sample application using the EMPLOYEE.GDB database, but i have two
> little questions:
>
>
> 1. Made it using Windows Forms or ASP.NET

I can help you with ASP.NET starting from September (I will be on holidays
from tomorrow to 1th September).

> 2. Made it using directly provider or clasess or anything similar to the
> Data Block for Sq Server by MS.

Two separate examples could show the differences between the two methods
listed above. The second is the most interesting and elegant.

Do you have a working Data Block for Firebird?

-- 
Alessandro -- D&D Support Team (http://www.dedonline.com)
Sostieni i ng liberi: abbonati a quelli a pagamento!

[Firebird-net-provider] Example application for .NET Data Provider 1.5

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

Hello:

Now than the first alpha of 1.5 version was released i'm thinking on
start with the suggestion made some time ago by Sean Leyne of make a 
sample application using the EMPLOYEE.GDB database, but i have two 
little questions:


1. Made it using Windows Forms or ASP.NET

2. Made it using directly provider or clasess or anything similar to the 
Data Block for Sq Server by MS.



Commenst are wellcome !!



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Implicit transaction support in 1.5 s ources

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

Hi,

> I'm not sure if i understand well what you means ( i have bad english ;) 

Your Engish is far better than my Spanish ;)

> ) but if you exec a command without a transaction a new transaction will 
> be started implcity and itl will be finished when you dispose the command.

That's exactly what I meant :) If I don't create a transaction a new one
will be created and commited when the command is disposed of. If I create a
transaction I can use it for a group of calls and commit it myself.

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] Implicit transaction support in 1.5 s

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......

> I'm not sure if i understand well what you means ( i have bad english ;)
> ) but if you exec a command without a transaction a new transaction will
> be started implcity and itl will be finished when you dispose the command.

That is the way the SqlProvider behave, right? It simplify and clarify code
and transaction management, so you have my vote.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] Implicit transaction support in 1.5 s ources

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

Hello:

> Great idea, will it cope with transactions already existing that wrap a
> number of calls?

I'm not sure if i understand well what you means ( i have bad english ;) 
) but if you exec a command without a transaction a new transaction will 
be started implcity and itl will be finished when you dispose the command.





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Implicit transaction support in 1.5 s ources

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

Carlos,

Great idea, will it cope with transactions already existing that wrap a
number of calls?

Cheers
Rod.

-----Original Message-----
From: Carlos Guzman Alvarez [mailto:car...@te...]=20
Sent: 12 August 2003 15:22
To: Firebird .Net Provider
Subject: [Firebird-net-provider] Implicit transaction support in 1.5 sources


Hello:


1.5 sources has implicit transaction support for FbCommand.ExecuteScalar=20
and FbCommand.ExecuteReader methods, i'm thinking on add it to=20
FbCommand.ExecuteNonQuery method, but i want to know opinions before=20
made it :)




--=20
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain



-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data
Reports, E-commerce, Portals, and Forums are available now. Download today
and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider


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

[Firebird-net-provider] Implicit transaction support in 1.5 sources

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

Hello:


1.5 sources has implicit transaction support for FbCommand.ExecuteScalar 
and FbCommand.ExecuteReader methods, i'm thinking on add it to 
FbCommand.ExecuteNonQuery method, but i want to know opinions before 
made it :)




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello:


 > the exe package seems to be broken...

Thanks very much i have update the package yet

 > I always get the following exception on Cmd.ExecuteNonQuery():


I have made a test with a stored proc returning an smallint without 
problem, and there are an nunit test that returns a varchar that works 
too, can you send the table structure and sp code.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......
>
> I'm going to release packages for 1.1 later this week.
>

Hola Carlos,
the exe package seems to be broken...
By the way I succesfully compiled the new sources.

Now I can't understand what's happening with the following simple code:

  public short Login(string LoginName, string Password)
  {
   FbConnection Conn = new
FbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   Conn.Open();
   FbTransaction Trans = Conn.BeginTransaction();

   short UserID = 0;

   try
   {
    FbCommand Cmd = new FbCommand("EXECUTE PROCEDURE
SP_LOGIN(@IN_LOGIN_NAME, @IN_PWD)", Conn, Trans);

    Cmd.CommandType = CommandType.StoredProcedure;

    Cmd.Parameters.Add("@IN_LOGIN_NAME", FbDbType.VarChar).Value =
LoginName;
    Cmd.Parameters.Add("@IN_PWD", FbDbType.VarChar).Value = Password;
    Cmd.Parameters.Add("@OUT_ID", FbDbType.SmallInt).Direction =
ParameterDirection.ReturnValue;

    Cmd.ExecuteNonQuery();


    if (Cmd.Parameters["@OUT_ID"].Value != DBNull.Value)
    {
     UserID = (short)Cmd.Parameters["@OUT_ID"].Value;
    }
   }
   finally
   {
    Trans.Commit();
    Conn.Close();
   }

   return UserID;
  }


I always get the following exception on Cmd.ExecuteNonQuery():

[NullReferenceException: Object reference not set to an instance of an
object.]
   FirebirdSql.Data.Firebird.FbParameter.setFbDbType(Object value) +5
   FirebirdSql.Data.Firebird.FbParameter.set_Value(Object value) +18
   FirebirdSql.Data.Firebird.FbCommand.SetOutputParameters() +224
   FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() +112
   Acronimio.Lasting.LMTSecurity.Login(String LoginName, String Password) in
d:\webroot\Lasting\components\Security.cs:27
   ASP.login_aspx.btnLogin_OnClick(Object Sender, EventArgs e) +74
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Any idea?

Thank you very much.

Ciao,
Alessandro Petrelli.

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

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......
>
> I'm going to release packages for 1.1 later this week.
>

Hola Carlos,
the exe package seems to be broken...
By the way I succesfully compiled the new sources.

Now I can't understand what's happening with the following simple code:

  public short Login(string LoginName, string Password)
  {
   FbConnection Conn = new
FbConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
   Conn.Open();
   FbTransaction Trans = Conn.BeginTransaction();

   short UserID = 0;

   try
   {
    FbCommand Cmd = new FbCommand("EXECUTE PROCEDURE
SP_LOGIN(@IN_LOGIN_NAME, @IN_PWD)", Conn, Trans);

    Cmd.CommandType = CommandType.StoredProcedure;

    Cmd.Parameters.Add("@IN_LOGIN_NAME", FbDbType.VarChar).Value =
LoginName;
    Cmd.Parameters.Add("@IN_PWD", FbDbType.VarChar).Value = Password;
    Cmd.Parameters.Add("@OUT_ID", FbDbType.SmallInt).Direction =
ParameterDirection.ReturnValue;

    Cmd.ExecuteNonQuery();


    if (Cmd.Parameters["@OUT_ID"].Value != DBNull.Value)
    {
     UserID = (short)Cmd.Parameters["@OUT_ID"].Value;
    }
   }
   finally
   {
    Trans.Commit();
    Conn.Close();
   }

   return UserID;
  }


I always get the following exception on Cmd.ExecuteNonQuery():

[NullReferenceException: Object reference not set to an instance of an
object.]
   FirebirdSql.Data.Firebird.FbParameter.setFbDbType(Object value) +5
   FirebirdSql.Data.Firebird.FbParameter.set_Value(Object value) +18
   FirebirdSql.Data.Firebird.FbCommand.SetOutputParameters() +224
   FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery() +112
   Acronimio.Lasting.LMTSecurity.Login(String LoginName, String Password) in
d:\webroot\Lasting\components\Security.cs:27
   ASP.login_aspx.btnLogin_OnClick(Object Sender, EventArgs e) +74
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108

System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +18
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain() +1277

Any idea?

Thank you very much.

Ciao,
Alessandro Petrelli.

Re: [Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available

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

Hello:

> Why do you continue development on .NET 1.0 before .NET 1.1?  This confuses
> me.  Is there a v1.5 Provider for .NET 1.1?

I'm going to release packages for 1.1 later this week.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available

[Lee C. <lee...@ad...>]

Why do you continue development on .NET 1.0 before .NET 1.1?  This confuses
me.  Is there a v1.5 Provider for .NET 1.1?

Lee Connell
Twin Mountain, NH
University of Phoenix Student
Networking Support Technician

[Firebird-net-provider] [ANN] Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available

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

Hello:

Firebird .NET Data Provider 1.5 Alpha 1 ( for .NET 1.0 ) available for 
download.


Release Changes:


Alpha 1 ( 2003-08-1 )
------- --------------

- New GDS implementation.

- Reorganization of XML documentation files using a new XML file format.

- Design time support for connection string ( For MS .NET only )

- Support for database schema retrieval.

- Support for SELECT ... FOR UPDATE statements.

         ---------------------------------------------------


You can download binarys ( for Windows and .NET Framework 1.0 ) at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1.exe?download


You can download sources at:

http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Alpha1-Src.zip?download




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 sources in CVS

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

Hello:

> It is my understanding that the 'pserver' images are updated 6-12 hours
> behind the 'master' CVS image.

Ahh can be thanks for clarify this i was thinking on a 24 hours delay 
for the message of the ViewCVS page :)


Thanks very much.


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Firebird .NET Data Provider 1.5 sources in CVS

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

Alessandro,

> Hola Carlos,
> it seems I can't access the new files anonymously using TortoiseCVS.

It is my understanding that the 'pserver' images are updated 6-12 hours
behind the 'master' CVS image.


Sean

Re: [Firebird-net-provider] Firebird .NET Data Provider 1.5 sources in CVS

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

"Carlos Guzman Alvarez" <car...@te...> wrote in message
news:3F3...@te......
> Hello:
>
> The sources of the new 1.5 version of the .NET Data provider are in the
cvs:
>
> Module : NETProvider\NETProvider_15

Hola Carlos,
it seems I can't access the new files anonymously using TortoiseCVS.

Have you got the full cvsroot?
Previously I was using
":pserver:ano...@cv...:/cvsroot/firebird" and
"Net-Provider" as module name.

Thank you.

Ciao,
Alessandro Petrelli.

[Firebird-net-provider] Firebird .NET Data Provider 1.5 sources in CVS

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

Hello:

The sources of the new 1.5 version of the .NET Data provider are in the cvs:

Module : NETProvider\NETProvider_15


I'm moving Sources for 1.0 version to:

Module : NETProvider\NETProvider_10



I will try to release the first alpha for testing in one or two days.



All comments are wellcome!! :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 1.5 NET

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

Hello:

> When is 1.5 NET Provider goinna be out?

I'm waitin for the creation of a new module for the sources in the CVS, 
this is being discussed in the admin's list, i'm waiting :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] 1.5 NET

[Lee C. <lee...@ad...>]

Carlos,

When is 1.5 NET Provider goinna be out?


Lee Connell
Twin Mountain, NH
University of Phoenix Student
Networking Support Technician

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

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

Hello:

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

What Character set have the Firebird database and what character set are 
you using in the connection string ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain