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

Re: [Firebird-net-provider] Transliterate character

[Martin R. <ne...@mi...>]

Hi everyone,
I try use FB net provider 1.5 inVS2003 and I have problem with execute
stored procedures.
When I use :

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

Then I get error SQL on position 1,1

How I can use store procedure?

Thanks very much.

Martin

Re: [Firebird-net-provider] UNICODE_FSS Character set question

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

Hello:

> [warning, long post]
> Ive understood same that Interbase(Firebird) has used
> UTF-8 as an internal UNICODE_FSS charset. Dont know
> why they named it so weird.
> 
> About ISO8859-1 charset:
> This is what we use here in up north if unicode
> charset is not available. It has scandinavian letters
> as an extended ascii codes. ALT+0228 gives me "ä"
> character in Notepad.
> 
> BUT it's not UTF-8 equalent where "ä" letter is
> represented with two bytes. Here is Win2k Notepad UTF8
> file from hexeditor: 
> EB BB BF C3 A4 where EBBBBF is a unicode BOM-marker.
> So, C3A4 represents "ä" character in UTF-8 format.
> 
> I can run tomorrow few tests with greek and cyrillic
> letters. They definitely should not work with
> ISO8859-1 encoding.
> Greek: ΨΩΪ
> Cyrillic: ЗИЙ
> Scandinavian: åäö
> 
> I will download Jaybird jdbc driver and test it
> against the same testdb as well.

Great !! do not forget to comment the results :), and if you need help 
with the net provider tests write to the list or to my private email.

> What happens if database is UNICODE_FSS and
> connectionStr does not provide a charset parameter. Is
> it _server_ that does all the conversion and most
> likely will fall to default ISO8859-1 if nothing is
> provided?

It will use NONE for connect to the firebird server and strings will be 
encoded/decoded using Encoding.Default.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] [Firebird-net-provide] stored procedure

[Martin R. <ne...@mi...>]

Hi everyone,
I try use FB net provider 1.5 inVS2003 and I have problem with execute
stored procedures.
When I use :

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

Then I get error SQL on position 1,1

How I can use store procedure?

Thanks very much.

Martin

Re: [Firebird-net-provider] UNICODE_FSS Character set question

[mailmur <ma...@ya...>]

[warning, long post]
Ive understood same that Interbase(Firebird) has used
UTF-8 as an internal UNICODE_FSS charset. Dont know
why they named it so weird.

About ISO8859-1 charset:
This is what we use here in up north if unicode
charset is not available. It has scandinavian letters
as an extended ascii codes. ALT+0228 gives me "ä"
character in Notepad.

BUT it's not UTF-8 equalent where "ä" letter is
represented with two bytes. Here is Win2k Notepad UTF8
file from hexeditor: 
EB BB BF C3 A4 where EBBBBF is a unicode BOM-marker.
So, C3A4 represents "ä" character in UTF-8 format.

I can run tomorrow few tests with greek and cyrillic
letters. They definitely should not work with
ISO8859-1 encoding.
Greek: ΨΩΪ
Cyrillic: ЗИЙ
Scandinavian: åäö

I will download Jaybird jdbc driver and test it
against the same testdb as well.

What happens if database is UNICODE_FSS and
connectionStr does not provide a charset parameter. Is
it _server_ that does all the conversion and most
likely will fall to default ISO8859-1 if nothing is
provided?

Native Interbase/Firebird drivers, jaybird and Delphi
drivers use "lc_ctype" parameter name for charset. I
think NETProviders "charset" is more general name for
such parameter. 

That probably does not mean anything here as it's just
a logical name for client driver reading value from
connection string.

--- Carlos Guzman Alvarez <car...@te...> >
Hello:
> mailmur has reported a problem with the UNICODE_FSS
> character set in the .NET provider, i have this
character set mapped to
> UTF-8 in the .NET Provider ( is this really correct
?? i think it's ok
> :) ), the problem gives with a field ( varchar field
) with a value of
> ( database was created using UNICODE_FSS as
character set and i
> have made the test using Firebird 1.5 RC4 ) :
> 
> Känkkäränkkä
> 
> but in the .net provider when i read the field value
> i'm receiving 12 bytes of data:
> 
> 	[0]	75
> 	[1]	228
> 	[2]	110
> 	[3]	107
> 	[4]	107
> 	[5]	228
> 	[6]	114
> 	[7]	228
> 	[8]	110
> 	[9]	107
> 	[10]	107
> 	[11]	228
> 
> When i transfor this buffer into a string using the
> UTF-8 encoding of .NET the result is:
> 
> Knkkrnkk
> 
> Instead if i map the UNICODE_FSS character set to
> ISO8859_1 all runs fine, any idea about what can be
the problem ??

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

Re: [Firebird-net-provider] UNICODE_FSS Character set question

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

Hello:

Oooooops, sorry bad list :)






-- 
BEst regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] UNICODE_FSS Character set question

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

Hello:

mailmur has reported a problem with the UNICODE_FSS character set in the 
.NET provider, i have this character set mapped to UTF-8 in the .NET 
Provider ( is this really correct ?? i think it's ok :) ), the problem 
gives with a field ( varchar field ) with a value of ( database was 
created using UNICODE_FSS as character set and i have made the test 
using Firebird 1.5 RC4 ) :

Känkkäränkkä

but in the .net provider when i read the field value i'm receiving 12 
bytes of data:

	[0]	75
	[1]	228
	[2]	110
	[3]	107
	[4]	107
	[5]	228
	[6]	114
	[7]	228
	[8]	110
	[9]	107
	[10]	107
	[11]	228

When i transfor this buffer into a string using the UTF-8 encoding of 
.NET the result is:

Knkkrnkk

Instead if i map the UNICODE_FSS character set to ISO8859_1 all runs 
fine, any idea about what can be the problem ??



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Should UNICODE_FSS charset work in Provider1.5?

[mailmur <ma...@ya...>]

I have a database with a global UNICODE_FSS (UTF-8 I
think???) character set. I can insert scandinavian
letters (åäö) in IBAccess and IB_SQL admin tools. Data
is displayed fine. I've cheched a column charset from
the system tables and its mapped to a right charset.

But then I have NETProvider1.5 test program, which
cannot read unicode characters but they are completely
dropped from the output string.

ServerVersion is "WI-T6.3.0.3773 Firebird 1.5 Release
Candidate 5" running on Win2k.

It should output CITY value as "Känkkäränkkä", but is
shown as "Knkkrnkk" :-(

[Table metadata]
CREATE TABLE Customers (
  id integer NOT NULL PRIMARY KEY,
  custno integer NOT NULL UNIQUE,
  name varchar(50),
  city varchar(15),
  balance numeric(12,3),
  custtype varchar(4),
  isactive varchar(1)
);

INSERT INTO Customers Values(1, 1001, 'Customer A',
'Känkkäränkkä', 12.456, 'SUA', '1');
INSERT INTO Customers Values(2, 1002, 'Customer B',
'Saiperia', 5.1, 'SUB', '1');

[Console testprogram]
using System;
using System.Data;

using FirebirdSql.Data.Firebird;

class MainClass {

 public static void Main(string[] args) {
  MainClass main = new MainClass();

        String connectionString =
"Database=testdb;User=SYSDBA;Password=masterkey;Server=localhost;charset=UNICODE_FSS;dialect=3";

     IDbConnection con =
main.createConnection(connectionString);
     IDataReader reader = null;
     try {
         IDbCommand command = main.createCommand();
         command.Connection = con;
         command.CommandText = "Select * From
Customers";

         reader = command.ExecuteReader();
         while(reader.Read()) {
             for(int i=0; i < reader.FieldCount; i++)
{
                 Console.Write(reader.GetString(i));
                 Console.Write(", ");
             }
             Console.WriteLine("");
         }
     } finally {
         if (reader != null) reader.Close();
         con.Close();
     }
 }

 public IDbConnection createConnection(String
connectionString) {
     FbConnection con = new
FbConnection(connectionString);
     con.Open();
     Console.WriteLine(con.ServerVersion);
     return con;
 }

 public IDbCommand createCommand() {
     return new FbCommand();
 }
}


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

Re: [Firebird-net-provider] .net exception

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

Hello:

> Getting this exception when I am trying to run a simple select command
> from a firebird database

1.0 version of the provider needs always a transaction for the FbCommand 
objects.

> I tried to install FirebirdNETProvider1.5-Alpha1-DotNET1.1.exe but it
> would not let me telling me I needed to have .net 1.0 installed.

I have updated the package yet.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .net exception

[Joel V. <joe...@co...>]

Hi,
 
Getting this exception when I am trying to run a simple select command
from a firebird database
 
System.InvalidOperationException: Command must have a valid Transaction.
at
FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior
behavior)
at
FirebirdSql.Data.Firebird.FbCommand.System.Data.IDbCommand.ExecuteReader
(Command\
Behavior
behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand
command, CommandBehavior behavior)
 
This is using visual studio 2003, .net 1.1 and firebird RC 1.4 with
.net Provider-1.0.
 
I tried to install FirebirdNETProvider1.5-Alpha1-DotNET1.1.exe but it
would not let me telling me I needed to have .net 1.0 installed.
 
Thanks.
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003
 

Re: [Firebird-net-provider] .net version

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

Hello:

> When installing the 1.5 alfa for .NET 1.1 one gets the message during the
> installation process that the .NET Framework 1.0 has to be installed. I
> suppose this is an error?

Fixed on CVS i will update the package tomorrow.



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .net version

[Jan J. <ja...@uv...>]

Hello
When installing the 1.5 alfa for .NET 1.1 one gets the message during the
installation process that the .NET Framework 1.0 has to be installed. I
suppose this is an error?

Regards Jan

Re: [Firebird-net-provider] How Can I Install the firebird provider ?

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

Hello:

> I have installed "FIREBIRD NET PROVIDER 1.0 pour Framework NET 1.1"
> so as to be used with Visual studio.NET.
> But when I want to create a new connection, there is no "Firebird" Provider
> in
> the list of OLEDB Providers...

Because it's a ADO.NET Data provider not an OleDB driver.

> 
> How can I create a connection to my base .GDB using the Firebird Net
> Provider which was installedon my computer.


Huuummm ... if you mean using visual components try to configure the VS 
.NET toolbaox for add the Firebird ADO.NET Provider components.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] How Can I Install the firebird provider ?

[Gaëtan A. <gae...@is...>]

I have installed "FIREBIRD NET PROVIDER 1.0 pour Framework NET 1.1"
so as to be used with Visual studio.NET.
But when I want to create a new connection, there is no "Firebird" Provider
in
the list of OLEDB Providers...

How can I create a connection to my base .GDB using the Firebird Net
Provider which was installedon my computer.

Thanks for your help

Re: [Firebird-net-provider] Re: Re: Transliterate character

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

Hello Carlos,

I'm really sorry that I didn't realized the missing
";"! Of course you're right. The sample code works
fine and it isn't important which character set I use
when creating the database.

Thanks a lot for your help!
OAS

 --- Carlos Guzman Alvarez <car...@te...>
schrieb: > Hello:
> 
> This connection string is bad:
> 
> Connection = new
> FbConnection("Database=TestChar.gdb; 
> USER=SYSDBA;Password=masterkey Charset=ISO8859_1");
> 
> it sholud be:
> 
> Connection  = new
> FbConnection("Database=TestChar.gdb; 
> USER=SYSDBA;Password=masterkey;Charset=ISO8859_1");
> 
> 
> I have made other test that is working fine too,
> here is the code:
> 
> FbConnection connection = new
> FbConnection(connectionString);
> connection.Open();
> 
> FbTransaction transaction =
> connection.BeginTransaction();
> 
> FbCommand command = new FbCommand("insert into
> test_table_01(int_field, 
> char_field) values (10020, 'äëïöü')", connection,
> transaction);
> 
> command.ExecuteNonQuery();
> 			
> transaction.Commit();
> command.Dispose();
> transaction.Dispose();
> 
> connection.Close();
> 
> 
> 
> 
> -- 
> Best regards
> 
> Carlos Guzmán Álvarez
> Vigo-Spain
>  

__________________________________________________________________

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

Re: [Firebird-net-provider] Link is broken

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

Hello:

> I have installed FirebirdNETProvider1.5-Alpha1-DotNET1.1.exe and it seems to
> work ok now. I don't know wheter you are aware of the fact that the link to
> the the help-file in the programs menu is broken.

Huummm thanks i will fix it for the next release :)



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Link is broken

[Jan J. <ja...@uv...>]

Hello Carlos
I have installed FirebirdNETProvider1.5-Alpha1-DotNET1.1.exe and it seems to
work ok now. I don't know wheter you are aware of the fact that the link to
the the help-file in the programs menu is broken.

Regards Jan

[Firebird-net-provider] New Stored Procedure execution format

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

Hello:

I have added to the CVS the changes for implment the new Stored 
procedure execution format (i need to make more tests on it :)).

With this changes you can exec an stored proc as:

FbCommand command = new FbCommand("GETVARCHARFIELD", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.Integer).Value = 1;
command.Parameters.Add("@RESULT", FbDbType.VarChar).Direction = 
ParameterDirection.Output;

command.ExecuteNonQuery();
command.Dispose();


This will change the command text as:

execute procedure GETVARCHARFIELD(@ID)



Other form will be:

FbCommand command = new FbCommand("GETVARCHARFIELD", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.Integer).Value = 1;

FbDataReader reader = command.ExecuteReader();
command.Dispose();


This will change the command text as:

select * from GETVARCHARFIELD(@ID)



If the command text starts with "execute proecdure " or "select " 
nothing will be changed.



Comments and ideas are wellcome !!








-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] WebMatrix

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

Hello:

Please send emails in text format.

 > *How to install the driver Firebase .NET in WebMatrix ?*

What you means how to use it with ASP.NET or how to add the provider 
components to the WebMatrix toolbar (i'm don't know if this can be made) ??






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] WebMatrix

[Claudinei R. <ne...@ac...>]

Please,

=20

How to install the driver Firebase .NET in WebMatrix ?

=20

Thank's

Nei

ne...@ac...

Brazil

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

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

Hello:

> are you sure that FbConnection is thread safe at all? Im not, and if 
> Carlos didnt make huge changes in that i think, that you cannot share 
> connection or transaction in multithreaded environment... I think you 
> have to have own connection and transaction for each thread, becouse 
> FIREBIRD api is not thread safe and net provider uses this api...
> But may be im wrong...

You are right :) but i think can be good to test this scenario using the 
new implicit transaction support :)






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello:

> Is it right that the autocommit functionality for
> ExecuteNonQuery as you are thinking of would be
> threadsafe and hence be a solution?

I think this will be the solution, thinking in that each command will 
start a new implicit transaction that will be commited when the command 
is disposed,







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

[<pa...@st...>]

oas wrote:

>Hello,
>
>in a project which uses a Oracle or Interbase database
>I=92m using a single connection in two parallel threads.
>With the OracleConnection class from .NET no
>transaction is needed and I didn=92t have multitheading
>problems so far. As I use ExecuteNonQuery commands, I
>had to use transactions for the Firebird Net provider.
>The transaction is now fragile in the two threads.
>Is there a workaround except of locking the thread or
>using a single connection object for each thread?
>Is it right that the autocommit functionality for
>ExecuteNonQuery as you are thinking of would be
>threadsafe and hence be a solution?
>
>Thanks, OAS
>
>
>From: Carlos Guzman Alvarez <carlosga@te...>=20
> Implicit transaction support in 1.5 sources  =20
>2003-08-12 14:51 =20
>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 :)
> =20
>
Hallo,

are you sure that FbConnection is thread safe at all? Im not, and if=20
Carlos didnt make huge changes in that i think, that you cannot share=20
connection or transaction in multithreaded environment... I think you=20
have to have own connection and transaction for each thread, becouse=20
FIREBIRD api is not thread safe and net provider uses this api...
But may be im wrong...

pavol Starek

Re: [Firebird-net-provider] Re: Re: Transliterate character

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

Hello:

> I also tried Charset=ISO8859_1, but the result was
> identical.

Ok, and which have the database ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello,

in a project which uses a Oracle or Interbase database
I’m using a single connection in two parallel threads.
With the OracleConnection class from .NET no
transaction is needed and I didn’t have multitheading
problems so far. As I use ExecuteNonQuery commands, I
had to use transactions for the Firebird Net provider.
The transaction is now fragile in the two threads.
Is there a workaround except of locking the thread or
using a single connection object for each thread?
Is it right that the autocommit functionality for
ExecuteNonQuery as you are thinking of would be
threadsafe and hence be a solution?

Thanks, OAS


From: Carlos Guzman Alvarez <carlosga@te...> 
 Implicit transaction support in 1.5 sources   
2003-08-12 14:51  
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


__________________________________________________________________

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

[Firebird-net-provider] Re: Re: Transliterate character

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

Hello,

the connect string is like
"Database=test.gdb; USER=SYSDBA; Password=masterkey
Charset=WIN1252"

I also tried Charset=ISO8859_1, but the result was
identical.

Thanks, OAS



From: Carlos Guzman Alvarez <carlosga@te...> 
 Re: Transliterate character   
2003-08-14 16:54  
 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

__________________________________________________________________

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