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

Re: [Firebird-net-provider] Re: problems with beta 2

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

Hello:

> Hi, I had this error with Firebird.net provider 1.5 beta 2 and not wth 
> old versions:
> When open a conection, this exception appears:
> ----------------------------------
> Formato de metadatos PInvoke no válido.
> Origen: OSSOCK.gethostbyname
> --------------------------------


Which version of the .net framework are you using ?? which installer of 
the data provider are you using ??

> AND commandbuilder.deriveparameters(command) does not work with my 
> stored procedures commands

With beta 2 ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Problem with FbCommandBuilder.DeriveParameters()

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

Hello:

> I get lastest CVS sources, but problem not fixed.

It's working for me, are you sure you have got the latest CVS sources ??

Here is my sample code:

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

            FbTransaction transaction = connection.BeginTransaction();

            FbCommand command = new FbCommand("GETVARCHARFIELD", 
connection, transaction);
            command.CommandType = CommandType.StoredProcedure;

            FbCommandBuilder.DeriveParameters(command);

            transaction.Commit();
            connection.Close();


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Problem with FbCommandBuilder.DeriveParameters()

[olegmad <ol...@ya...>]

> Fixed in CVS, you can use it without start a transaction and
> it will work ok or get latest CVS sources, i ahave added a
> nunit test case too.

I get lastest CVS sources, but problem not fixed.

That code work fine, but if I uncomment one line - exception will throw.

using System;

using System.Data;

using System.Data.Common;

using FirebirdSql.Data.Firebird;

namespace ConsoleApplication

{

class MainClass

{

static private readonly string ConnectionString =
@"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Charset=UNICODE_FSS;Connec
tion Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

static void Main(string[] args)

{

FbConnection connection = new FbConnection(ConnectionString);

connection.Open();

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

//command.Transaction = connection.BeginTransaction(); // if uncomment THIS
line - generate exception :(

command.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(command);

connection.Close();

}

}

}

Re: [Firebird-net-provider] Problem with FbCommandBuilder.DeriveParameters()

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

Hello:

Fixed in CVS, you can use it without start a transaction and
it will work ok or get latest CVS sources, i ahave added a
nunit test case too.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

> you need to add
> this to the connection string:
>
>     Charset=UNICODE_FSS

Thanks!!! Now it work!!! :-)

Bye.

[Firebird-net-provider] Problem with FbCommandBuilder.DeriveParameters()

[olegmad <ol...@ya...>]

Hello Carlos!

I am have probler with FbCommandBuilder.DeriveParameters() too.

I create this procedure:
--------------------------------------------
CREATE PROCEDURE MYPROC
RETURNS (
    "id" INTEGER)
AS
begin
    "id" = 777;
end
--------------------------------------------

And this code:
--------------------------------------------
using System;
using System.Data;

using System.Data.Common;

using FirebirdSql.Data.Firebird;

namespace ConsoleApplication

{

class MainClass

{

static private readonly string ConnectionString =
@"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Charset=UNICODE_FSS;Connec
tion Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

static void Main(string[] args)

{

FbConnection connection = new FbConnection(ConnectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("MYPROC", connection, transaction);

command.CommandType = CommandType.StoredProcedure;

FbCommandBuilder.DeriveParameters(command);

transaction.Commit();

connection.Close();

}

}

}

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

I catch exception:

Unhandled Exception: FirebirdSql.Data.Firebird.FbException: Execute requires
the Command object to have a Transaction object when the Connection object
assigned to the command is in a pending local transaction.  The Transaction
property of the Command has not been initialized.
   at
FirebirdSql.Data.Firebird.DbSchema.FbAbstractDbSchema.GetDbSchemaTable(FbCon
nection connection, Object[] restrictions)
   at FirebirdSql.Data.Firebird.FbConnection.GetDbSchemaTable(FbDbSchemaType
schema, Object[] restrictions)
   at FirebirdSql.Data.Firebird.FbCommandBuilder.DeriveParameters(FbCommand
command)
   at ConsoleApplication.MainClass.Main(String[] args) in
c:\vss\consoleapplication3\class1.cs:line 21


Thanks.

[Firebird-net-provider] Re: problems with beta 2

[nicoya n. <nic...@ho...>]

Hi, I had this error with Firebird.net provider 1.5 beta 2 and not wth old 
versions:
When open a conection, this exception appears:
----------------------------------
Formato de metadatos PInvoke no válido.
Origen: OSSOCK.gethostbyname
---------------------------------
AND commandbuilder.deriveparameters(command) does not work with my stored 
procedures commands
example:
----------------------------------
FirebirdSql.Data.Firebird.FbConnection Con2 = new 
FirebirdSql.Data.Firebird.FbConnection(this.CadenaConexion);
Con2.Open();
Com = new FirebirdSql.Data.Firebird.FbCommand("PA_EMPLEADO_LISTAR",Con2);
Com.CommandType = System.Data.CommandType.StoredProcedure;
FirebirdSql.Data.Firebird.FbCommandBuilder.DeriveParameters(Com);
Con2.Close();
Con2.Dispose();-
----------------------------------
This stored procedure has 2 parameter and not buil its with 
derrveparameters.
Thank You Good look!

_________________________________________________________________
Consigue aquí las mejores y mas recientes ofertas de trabajo en América 
Latina y USA: www.yupimsn.com/empleos

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

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

Hello:

Ok, fixed in CVS.

> static private readonly string ConnectionString =
> @"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Connection
> Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

One question, with this connection string the .net provider will use
UNICODE_FSS as character set only if this is the Default character set 
of .net framework
( for example for me the default is ISO8859_1 ), if you want the .net 
provider
working with UNICODE_FSS ( UTF-8 ), that it's database character set ;)  
,you need to add
this to the connection string:

    Charset=UNICODE_FSS


( With this probably the beta 2 release will work ok ;) but in any case 
can be better
for you to get a new copy of CVS sources )




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

> This is the character set of the database and table fields ?? Can you
> send a sample of the
> connection string that are you using ??

I create new database with that params:

SQL Dialect = 3
Charset = UNICODE_FSS
Page Size = 4096

I create new table in this database:

CREATE TABLE TTT (
    "id"    INTEGER NOT NULL,
    "name"  VARCHAR(10)
);


You can just compile and run next sample, without editing, all info in
ConnectionString - workable!

I send you all my sample:
------------------------------------------------------------------
using System;

using System.Data;

using System.Data.Common;

using FirebirdSql.Data.Firebird;

namespace ConsoleApplication

{

class MainClass

{

static private readonly string ConnectionString =
@"Server=80.80.104.12;Database=c:\temp\carlos.gdb;Connection
Lifetime=15;Dialect=3;User=carlos;Password=carlos;";

static void Main(string[] args)

{

FbConnection connection = new FbConnection(ConnectionString);

connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("SELECT * FROM TTT", connection,
transaction);


DataTable table = new DataTable();

FbDataAdapter adapter = new FbDataAdapter(command);


adapter.Fill(table);

transaction.Commit();

connection.Close();

}

}

}

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

P.S.
    When I use fb.net 1.5 for 1.1 beta 1 - all works fine!!!


Thanks!

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

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

Hello:

> In Firebird 1.5 I use
> charset = UNICODE_FSS

This is the character set of the database and table fields ?? Can you 
send a sample of the
connection string that are you using ??

> font characters set = ANSI_CHARSET

Where you are using this ??


I have added some changes more to the CVS.



--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

> Fixed in CVS ( seems to give only when database has no character set
> specified.)

Hello.
I download CVS, compiled it, but I still have this error... :(
I use the same code and catch same exception.


In Firebird 1.5 I use
charset = UNICODE_FSS
font characters set = ANSI_CHARSET

Whats wrong???

Thanks...

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

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

Hello:

Fixed in CVS ( seems to give only when database has no character set 
specified.)



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Again, embedded support?

[Miha M. <mi...@NO...>]

Yes, please. It would be a precious addition.

Miha

"Carlos Guzmán Álvarez" <car...@te...> wrote in message
news:3F9...@te......
> Hello:
>
> > Hi guys (probably Carlos :) )
> >
> > Are there any plans for supporting embedded firebird?
> > It would be really a greaaaaat feature.
>
>
> I'm thinking on it ;) , probably after 1.5 final release
> i will see how to implement support for the embedded server.
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo
> The Event For Linux Datacenter Solutions & Strategies in The Enterprise
> Linux in the Boardroom; in the Front Office; & in the Server Room
> http://www.enterpriselinuxforum.com
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] Again, embedded support?

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

Hello:

> Hi guys (probably Carlos :) )
>
> Are there any plans for supporting embedded firebird?
> It would be really a greaaaaat feature.


I'm thinking on it ;) , probably after 1.5 final release
i will see how to implement support for the embedded server.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] re:I had probler with fb.net 1.5 beta 2

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

Hello:

> I also get the same error message, but I get it as soon as I try to 
> assign a connection string to the connection.


It's fixed in CVS.



--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Again, embedded support?

[Miha M. <mi...@NO...>]

Hi guys (probably Carlos :) )

Are there any plans for supporting embedded firebird?
It would be really a greaaaaat feature.

Thanks,
Miha

[Firebird-net-provider] re:I had probler with fb.net 1.5 beta 2

[George L. <fir...@wo...>]

I also get the same error message, but I get it as soon as I try to =
assign a connection string to the connection.

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

> I have made some tests without problems, can you send to me the table
> structure
> ( for see if it's a problem with character sets that now are handled in
> different way ),

CREATE TABLE TTT (
    "id"    INTEGER NOT NULL,
    "name"  VARCHAR(64) NOT NULL
);


> and the stack trace of the exception, please.

Unhandled Exception: System.NullReferenceException: Object reference not set
to an instance of an object.
   at FirebirdSql.Data.Firebird.Gds.GdsField.set_SqlSubType(Int32 value)
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.parseTruncSqlInfo(Byte[]
info, GdsRowDescription rowDesc, Int32 lastindex)
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.parseSqlInfo(Byte[] info,
Byte[] items)
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.Prepare()
   at FirebirdSql.Data.Firebird.FbCommand.InternalPrepare()
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteReader(CommandBehavior
behavior)
   at
FirebirdSql.Data.Firebird.FbCommand.System.Data.IDbCommand.ExecuteReader(Com
mandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable, IDbCommand
command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at ConsoleApplication.MainClass.Main(String[] args) in
c:\vss\consoleapplication3\class1.cs:line 27


Thanks.

Re: [Firebird-net-provider] I had probler with fb.net 1.5 beta 2

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

Hello:

> But! When i use old (beta 1) .net provider - all OK.


I have made some tests without problems, can you send to me the table 
structure
( for see if it's a problem with character sets that now are handled in 
different way ),
and the stack trace of the exception, please.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] I had probler with fb.net 1.5 beta 2

[olegmad <ol...@ya...>]

Hello! I download firebird .net provider 1.5 beta 2 for .net framework 1.1.

I try run that simple code:
----------------------------
FbConnection connection = new FbConnection(ConnectionString);
connection.Open();

FbTransaction transaction = connection.BeginTransaction();

FbCommand command = new FbCommand("SELECT * FROM \"TTT\"", connection,
transaction);


DataTable table = new DataTable();

FbDataAdapter adapter = new FbDataAdapter(command);

adapter.Fill(table); // EXCEPTION HERE !!!!!

transaction.Commit();

connection.Close();

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

And I catch that exception:

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

An unhandled exception of type 'System.NullReferenceException' occurred in
system.data.dll

Additional information: Object reference not set to an instance of an
object.
----------------

But! When i use old (beta 1) .net provider - all OK.

What wrong??? Please help!!!

Bye.

[Firebird-net-provider] Basic design time support for FbCommand.CommandText in CVS

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

Hello:

I have added basic design time support for FbCommand.CommandText to the 
CVS, it's not finished yet,
but in first tests seems to run fine.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Problems with VS 2003

[Chris C. <cm...@uk...>]

> Source and .net 1.1 install packages are updated yet.
> 
Thanks Carlos.

Chris.

Re: [Firebird-net-provider] Problems with VS 2003

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

Hello:

> There are only a namespace change on the connection string design time
> classes from beta 1 release, i need to think that it's a problem with
> my dot net install, i will install windows and .net from scratch tomorrow
> and update installation packages.


Source and .net 1.1 install packages are updated yet.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Problems with VS 2003

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

Hello:

> I'm just starting to work with .NET (Delphi background) so don't rule
> out the fact that I may have done something stupid <g>.

No.

There are only a namespace change on the connection string design time
classes from beta 1 release, i need to think that it's a problem with
my dot net install, i will install windows and .net from scratch tomorrow
and update installation packages.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Problems with VS 2003

[Chris C. <ch...@mi...>]

Hi.

I've just started looking at the Firebird .NET provider, I installed
the binary (Beta 1) into c# builder at work today with no problems.

I just installed Beta 2 into VS.NET 2003 (1.1 Version) and when I click
on the button in the connectionstring property in a fbConnection I get:

"Object reference not set to an instance of an object" error message.

I'm just starting to work with .NET (Delphi background) so don't rule
out the fact that I may have done something stupid <g>.

Any help appreciated.

Chris Clark.