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

[Firebird-net-provider] Getting Invalid PInvoke metadata format exception...

[Pierre A. <Pie...@ms...>]

Hello,

While trying out Firebird .NET provider 1.5 (version 1.5.1326.15583)
from a simple command line application, I can use CreateDatabase to
create an empty database.

However, when running the same methods from within NUnit, I get a
very strange exception when calling into CreateDatabase :

  "Invalid PInvoke metadata format exception"

in

FirebirdSql.Data.Firebird.FbConnection.CreateDatabase(String dataSource,
Int32 port, String database, String user, String password, Byte dialect,
Boolean forceWrite, Int16 pageSize, String charset)

Any ideas ?

    Pierre

[Firebird-net-provider] Re: Re: Re: Inserting a Byte Array

[F L <flo...@ho...>]

Hi again,

the BLOB code works if I send it a file, but if it's null, it tells me 
"Object reference not set to an instance of an object"

Thanks for all of your help.

Lopez

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.   
http://join.msn.com/?page=features/virus

[Firebird-net-provider] Re: Re: Re: Inserting a Byte Array

[F L <flo...@ho...>]

Hi,

finally!  The code for the BLOB works!!
Now that I switched to the new .NET Provider, and Firebird 1.5.
Thanks for your help.

But now....
My previous code worked with Provider 1.1 and Firebird 1.0.2, and now it 
doesn't.
I traced my code, and the problem I get is that DeriveParameters doesn't 
return any parameters.  So that's why my code isn't working.  Is there 
something different now for the use of DeriveParameters?

Thanks again for your help.
Lopez

_________________________________________________________________
MSN 8: Get 6 months for $9.95/month. http://join.msn.com/?page=dept/dialup

[Firebird-net-provider] Re: Re: Re: Inserting a Byte Array

[F L <flo...@ho...>]

Hello again,

>I think no, you have got the sources from CVS of from Sourceforge 
>packages??, can you send a example of your call ?? (i'm going to make a 
>test in any case.)

I got them working now.  I upgraded to Firebird 1.5 and now my select * from 
procedures work.  The inserting procedures don't work though.  I thought 
there might be a versioning conflict, but I got them all ok now, and still 
get this error

I get this error:

Exception FbEx: Dynamic SQL Error
SQL error code = -804
SQLDA missing or incorrect version, or incorrect number/type of variables

InnerException: FirebirdSql.Data.Firebird.Gds.GdsException: Exception of 
type FirebirdSql.Data.Firebird.Gds.GdsException was thrown.
   at FirebirdSql.Data.Firebird.Gds.GdsAttachement.ReadStatusVector()
   at FirebirdSql.Data.Firebird.Gds.GdsAttachement.ReceiveResponse()
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.execute(Boolean isSP)
   at FirebirdSql.Data.Firebird.Gds.GdsStatement.ExecuteStoredProc()
   at FirebirdSql.Data.Firebird.FbCommand.InternalExecute()
   at FirebirdSql.Data.Firebird.FbCommand.ExecuteNonQuery()


>If you want i can send to you a compiled version for .NET 1.0 (or 1.1).

Please do.  I'm using .NET 1.0 right now.

Thank you so much.
Lopez

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.    
http://join.msn.com/?page=features/virus

Re: [Firebird-net-provider] Re: Re: Inserting a Byte Array

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

Hello:

> I switched to 1.5.  Compiled with no trouble, but now none of my other 
> calls to execute procedures work.  Not even the 'select * from ' some 
> procedure.
> Do I have to change something in order for it to work?

I think no, you have got the sources from CVS of from Sourceforge 
packages??, can you send a example of your call ?? (i'm going to make a 
test in any case.)

> I tested it with the code you sent and I get an error when I assign a 
> null directly.  I get an "Object reference not set to an instance of an 
> object" error.

If you want i can send to you a compiled version for .NET 1.0 (or 1.1).

> Thanks again for your help.  I really apprecciate it.

Thanks to you :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Re: Inserting a Byte Array

[F L <flo...@ho...>]

Hi,

>I encourage you to make another test with the 1.5 and comment here your 
>problems :) think in that 1.1 was discontinued.

I switched to 1.5.  Compiled with no trouble, but now none of my other calls 
to execute procedures work.  Not even the 'select * from ' some procedure.
Do I have to change something in order for it to work?

I tested it with the code you sent and I get an error when I assign a null 
directly.  I get an "Object reference not set to an instance of an object" 
error.

I'm starting to wonder if it's because I'm using Firebird 1.0.2.  I'm 
upgrading to the newest Firebird and let you know if it works now.

Thanks again for your help.  I really apprecciate it.

Lopez

_________________________________________________________________
Enter for your chance to IM with Bon Jovi, Seal, Bow Wow, or Mary J Blige 
using MSN Messenger http://www.msnmessenger-download.com/imastar

Re: [Firebird-net-provider] Re: Inserting a Byte Array

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

Hello:

> Huummm i'm going to test the same using a null, thanks :)

Seems to be working for me using 1.5, here is the test case:

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

FbTransaction transaction = connection.BeginTransaction();

// Creates a new command and inserts data
FbCommand command = new FbCommand("new_procedure", connection, transaction);
command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("@INT_PARAM", FbDbType.Integer).Value = 
(int)(System.DateTime.Now.Ticks / 100000);
command.Parameters.Add("@BLOB_PARAM", FbDbType.Binary).Value = null;

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

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



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Re: Inserting a Byte Array

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

Hello:

> I did, but then my previous code wasn't working.  I think it was 
> something about the way the procedure is called.  So I went back to 1.1

I encourage you to make another test with the 1.5 and comment here your 
problems :) think in that 1.1 was discontinued.

> The code is pretty much the same as what I do.  Just that I use a file, 
> and then get the bytes from it.

:) i have tested it with a loop and works ok too :)

> On the procedure however, I did not write the sub_type nor the segment 
> size for the blob.  Could that be it?

Segment size probably not but can be good to set the sub type for ensure 
that the parameter is a binary blob.

> Anyway, when I use my procedure using isql, and put a null for my field, 
> the procedure works just fine and adds the entry correctly.  When I send 
> a null through code however, I wind up witn an error.

Huummm i'm going to test the same using a null, thanks :)

> I'll try to see if with 1.5 things work out and I'll keep you posted.
> Meanwhile, if there are any ideas of what's going on, please let me know.

Thanks :)


-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Inserting a Byte Array

[F L <flo...@ho...>]

>I can suggest you to get the 1.5 Alpha 1 :)

I did, but then my previous code wasn't working.  I think it was something 
about the way the procedure is called.  So I went back to 1.1

>Thanks, i have a test case like this ( tell to me if it's correct ), seems 
>to be working ok for a single execution, i'm going to make test using a 
>loop ( the test case uses 1.5 alpha 1 ):

The code is pretty much the same as what I do.  Just that I use a file, and 
then get the bytes from it.

>And the stored proc:

>CREATE PROCEDURE NEW_PROCEDURE (
>      INT_PARAM INTEGER,
>      BLOB_PARAM BLOB SUB_TYPE 0 SEGMENT SIZE 80)
>AS
>begin
>      INSERT INTO TEST_TABLE_01 (INT_FIELD, BLOB_FIELD) VALUES (:INT_PARAM, 
>:BLOB_PARAM);
>end

On the procedure however, I did not write the sub_type nor the segment size 
for the blob.  Could that be it?
Anyway, when I use my procedure using isql, and put a null for my field, the 
procedure works just fine and adds the entry correctly.  When I send a null 
through code however, I wind up witn an error.

I'll try to see if with 1.5 things work out and I'll keep you posted.
Meanwhile, if there are any ideas of what's going on, please let me know.

Thanks for your help,
Lopez

_________________________________________________________________
Get MSN 8 and enjoy automatic e-mail virus protection.    
http://join.msn.com/?page=features/virus

Re: [Firebird-net-provider] Date Format

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

Hello:

Sorry for the late.

> When I store a date like 21/08/2003 in the DB the DB convert it to
> 08/21/2003. There are any thing to config the date format of the DB and put
> it in dd/mm/yyyy ??

In the .net data provider not at this moment, i can try to see if there 
any way for return the dates encoded using the default format of the OS.






-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Trying to use a dataset to update a table.

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

Hello:


>    fbConnection1.Open();
>    FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
> FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
>    fbDataAdapter1.Fill(dataSet1,"TABLE1");
>    DataTable TABLE1 = dataSet1.Tables["TABLE1"];
>    for(int a = 0;a <= 100;++a)
>    {
>     DataRow newrow = TABLE1.NewRow();
>     newrow["NAME"] = "Test Me "+a.ToString();
>     newrow["IDNUMBER"] = a;
>     newrow["FIELD1"] = a;
>     TABLE1.Rows.Add(newrow);
>    }
>    fbCommand2 = builder.GetUpdateCommand();
>    textBox1.Text = fbCommand2.CommandText;
>    fbDataAdapter1.Update(TABLE1);
>    fbConnection1.Close();


Huummm try this:

fbConnection1.Open();
FbTransaction transaction = fbConnection1.BeginTransaction();	<-----
FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
fbDataAdapter1.Fill(dataSet1,"TABLE1");
DataTable TABLE1 = dataSet1.Tables["TABLE1"];
for(int a = 0;a <= 100;++a)
{
	DataRow newrow = TABLE1.NewRow();
	newrow["NAME"] = "Test Me "+a.ToString();
	newrow["IDNUMBER"] = a;
	newrow["FIELD1"] = a;
	TABLE1.Rows.Add(newrow);
}
fbCommand2 = builder.GetUpdateCommand();
textBox1.Text = fbCommand2.CommandText;
fbDataAdapter1.Update(TABLE1);

transaction.Commit();	<-----

fbConnection1.Close();

or


fbConnection1.Open();
FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
fbDataAdapter1.Fill(dataSet1,"TABLE1");
DataTable TABLE1 = dataSet1.Tables["TABLE1"];
for(int a = 0;a <= 100;++a)
{
	DataRow newrow = TABLE1.NewRow();
	newrow["NAME"] = "Test Me "+a.ToString();
	newrow["IDNUMBER"] = a;
	newrow["FIELD1"] = a;
	TABLE1.Rows.Add(newrow);
}
fbCommand2 = builder.GetUpdateCommand();
textBox1.Text = fbCommand2.CommandText;
fbDataAdapter1.Update(TABLE1);
builder.Dispose();	<------
fbConnection1.Close();




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Trying to use a dataset to update a table.

[James G. <Ja...@jn...>]

I am trying to insert records into a table using C#builder and firebird.net
provider 1.5. The code runs but when I check the table no updates have been
commited. Could someone let me know where I have gone wrong?

Thanks,

James Gill

   fbConnection1.Open();
   FirebirdSql.Data.Firebird.FbCommandBuilder builder = new
FirebirdSql.Data.Firebird.FbCommandBuilder(fbDataAdapter1);
   fbDataAdapter1.Fill(dataSet1,"TABLE1");
   DataTable TABLE1 = dataSet1.Tables["TABLE1"];
   for(int a = 0;a <= 100;++a)
   {
    DataRow newrow = TABLE1.NewRow();
    newrow["NAME"] = "Test Me "+a.ToString();
    newrow["IDNUMBER"] = a;
    newrow["FIELD1"] = a;
    TABLE1.Rows.Add(newrow);
   }
   fbCommand2 = builder.GetUpdateCommand();
   textBox1.Text = fbCommand2.CommandText;
   fbDataAdapter1.Update(TABLE1);
   fbConnection1.Close();

Re: [Firebird-net-provider] Re: Inserting a Byte Array

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

Hello:

>> Which version of Firebird and .NET Provider are you using ??
> 
> I'm using Firebird 1.0.2 & .NET Provider 1.1 Alpha 2

I can suggest you to get the 1.5 Alpha 1 :)

> Any ideas?  Let me know if more code is needed to pinpoint my problem.

Thanks, i have a test case like this ( tell to me if it's correct ), 
seems to be working ok for a single execution, i'm going to make test 
using a loop ( the test case uses 1.5 alpha 1 ):

byte[] bytes = new byte[100000*4];
RNGCryptoServiceProvider rng = new RNGCryptoServiceProvider();
rng.GetBytes(bytes);

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

FbTransaction transaction = connection.BeginTransaction();

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

command.Parameters.Add("@INT_PARAM", FbDbType.Integer).Value = 
System.DateTime.Now.Millisecond;
command.Parameters.Add("@BLOB_PARAM", FbDbType.Binary).Value = bytes;

command.ExecuteNonQuery();

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


And the stored proc:

CREATE PROCEDURE NEW_PROCEDURE (
     INT_PARAM INTEGER,
     BLOB_PARAM BLOB SUB_TYPE 0 SEGMENT SIZE 80)
AS
begin
     INSERT INTO TEST_TABLE_01 (INT_FIELD, BLOB_FIELD) VALUES 
(:INT_PARAM, :BLOB_PARAM);
end










-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: Inserting a Byte Array

[F L <flo...@ho...>]

Hello,

>Which version of Firebird and .NET Provider are you using ??
I'm using Firebird 1.0.2 & .NET Provider 1.1 Alpha 2

>Can you send a test case ??
OK, well, I'm sending a snippet of the code I use.  I've tried it different 
ways I still end up having an error somewhere.  The thing is the app some 
times kind of freezes, but most of the times I get the same error.  The 
error codes I get are 335544794 and 335544569.  I've tried to pinpoint the 
problem exactly but the closest I've gotten to see where the error lies is 
that it complains that there is an unknown token, which is the ] in 
System.Byte[] that is passed as a parameter, which is the Byte array that 
has my file.

Anyway, the code I use the get the byte array is this:

string strPracticeBlob = this.txtDemoPic.Text.Trim();
FileStream fsPracticeBlob = new FileStream(strPracticeBlob,
	FileMode.Open, FileAccess.Read);

Byte[] bytePracticeBlob = new Byte[fsPracticeBlob.Length];
fsPracticeBlob.Read(bytePracticeBlob, 0, bytePracticeBlob.Length);
fsPracticeBlob.Close();

And then I call my procedure...(I omitted where I make the connection and 
all that before I use the command for the purpose of this mail)

FbCommand myCommand = new FbCommand();
myCommand.CommandText = "EXECUTE PROCEDURE SP_INSERT_PROC(?,?,?,?,?,?)";
myCommand.Connection = connection;
myCommand.Transaction = transaction;
myCommand.CommandType = CommandType.StoredProcedure;

// other parameters are added

// bytePracticeBlob is a Byte[]
myCommand.Parameters.Add("@PRACTICE", FbType.Binary).Value = 
bytePracticeBlob;


myCommand.ExecuteNonQuery();
transaction.Commit();
myCommand.Dispose();


the error happens at ExecuteNonQuery()

Any ideas?  Let me know if more code is needed to pinpoint my problem.

Thanks again for your help.
Lopez

_________________________________________________________________
Get MSN 8 and help protect your children with advanced parental controls.  
http://join.msn.com/?page=features/parental

Re: [Firebird-net-provider] Inserting a Byte Array

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

Hello:

> I have defined a field in my table as Blob.  If the value for it is 
> null, the row is added succesfully.  When I try to send it a byte array, 
> I don't get an exception, but my app just freezes.
> Any ideas?
> How should I send my data to be stored as a blob?
> What I'm trying to save in the field are files that might be .txt, .doc, 
> etc.

Which version of Firebird and .NET Provider are you using ??

Can you send a test case ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Source

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

Hello:

> where I can get source of provider 1.5?
> What is the CVS adress?

http://sourceforge.net/cvs/?group_id=9028



-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Date Format

[Daniel L. <dan...@ya...>]

When I store a date like 21/08/2003 in the DB the DB convert it to
08/21/2003. There are any thing to config the date format of the DB and put
it in dd/mm/yyyy ??

[Firebird-net-provider] Source

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

Hi,
where I can get source of provider 1.5?
What is the CVS adress?

Thank you
Martin

[Firebird-net-provider] Inserting a Byte Array

[F L <flo...@ho...>]

Hello,

I have defined a field in my table as Blob.  If the value for it is null, 
the row is added succesfully.  When I try to send it a byte array, I don't 
get an exception, but my app just freezes.
Any ideas?
How should I send my data to be stored as a blob?
What I'm trying to save in the field are files that might be .txt, .doc, 
etc.

Thanks in advance for any help you can give me.

Lopez

_________________________________________________________________
<b>MSN 8:</b> Get 6 months for $9.95/month. 
http://join.msn.com/?page=dept/dialup

Re: [Firebird-net-provider] .NET provider example

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

HEllo:

> Some time ago it was discussed whether it would be a good idea to provide a
> sample application which uses the FireBird provider. MS has launched a
> number of applications using ADO.NET, such as TaskVision
>  (http://windowsforms.net/Default.aspx?tabindex=7&tabid=44) . How about
>  implementing the FireBird provider in TaskVision or some other sample MS
> app? By doing this one would
> accomplish two goals: 1) see how easy it is to replace the datalayer and
>  emphasize that the FireBird provider is just as powerfull as the MS
>  Sqlprovider. 2) it would be easy to compare the apps.


Huumm i think this can be interesting any thougths ??




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello:

> Ok, problem solved and it was not the driver but
> admintool did not support unicodes properly. I must go
> find a better admintool, do anyone know here a decent
> FB admintool for win2k?

I use IBExpert personal but seems that don't have proper support for 
unicode strings.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] .NET provider example

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

Some time ago it was discussed whether it would be a good idea to provide a
sample application which uses the FireBird provider. MS has launched a
number of applications using ADO.NET, such as TaskVision
 (http://windowsforms.net/Default.aspx?tabindex=7&tabid=44) . How about
 implementing the FireBird provider in TaskVision or some other sample MS
app? By doing this one would
accomplish two goals: 1) see how easy it is to replace the datalayer and
 emphasize that the FireBird provider is just as powerfull as the MS
 Sqlprovider. 2) it would be easy to compare the apps.

Regards Jan

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

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

Ok, problem solved and it was not the driver but
admintool did not support unicodes properly. I must go
find a better admintool, do anyone know here a decent
FB admintool for win2k?

When I do inserts with Jaybird jdbc driver or NET1.5
provider, then all is fine.

See my webpage, where I've attached a simple test
programs (java and c# versions). Then I put a simple
info how I created a testdb with UNICODE_FSS default
setting.
http://koti.mbnet.fi/akini/ib/

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

> Do you know if IBAccess and IB_SQL admin have
> UNICODE_FSS character set 
> support ??
> Can you test this making the inserts using the .NET
> Provider ??

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

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

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

Hello:

> 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

Support for this type of calls is on CVS only ( are you using CVS 
version ?? ), try using execute procedure sp_name(@param_name)







-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

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

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

Hello:

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


Do you know if IBAccess and IB_SQL admin have UNICODE_FSS character set 
support ??

Can you test this making the inserts using the .NET Provider ??





-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain