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

Re: [Firebird-net-provider] System.NullReferenceException

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

Hello:

> Thanks for your swift reply. I retrieve the information about the stored
> procedures in a few select statements which work without a problem.
> 
> I was not aware of FbConnection.GetDbSchemaTable and I will look into
> that.

I haven't had time for test it yet, one question have you tested it 
setting the SourceColumn of each parameter ??




--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

Re: [Firebird-net-provider] select quick

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

""Paola"" <pa...@sa...> ha scritto nel messaggio
news:104...@ne......

> Sorry, Are you italian?

Yes, but if you want to talk in italian please, send me a private email.

Ciao,
Alessandro Petrelli.

[Firebird-net-provider] 1.6 assembly distribution

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

Hello:

I have commited some changes for allow the build of the 1.6 sources in a 
single dll, the build now can be done in 4 assemblys or in a single 
assembly ( they are different build files ).

When building a single assembly, the common, embeeded and gds classes 
will be internal.


i will try to some tests later today.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] FbValidation failure with connection pooling

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

Hello:

> If I run this when the app starts, it's fine. But following opening a
> connection with Pooling enabled, it raises a FbException in
> 'val.Start()', "No message for code 5 found".
> 
> If I turn pooling off, it works fine.
> 
> Interestingly, even if I wait for the pooled connection to be closed,
> and try the code again, it still fails....

The validation can't be done if there are connections opened to the 
database, maybe the connection sin the pool has been no closed yet when 
you are trying to do the validation.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003

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

Hello:

> It seems setting the SourceColumn of the FbParameters fixes the problem! Knew I was forgetting something stupid.
> 
> It all works fine now (using your latest .dll 1.5.1509.41448).

Great!! i will commit the changes into the CVS later today




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] FbValidation failure with connection pooling

[JS.staff <jsp...@ec...>]

I seem to be getting problems using the following code:

			FbValidation val =3D new FbValidation();
			val.UserName =3D "SYSDBA";
			val.UserPassword =3D "masterkey";
			val.Database =3D "mytest";
			val.Options =3D
FbValidationFlags.ValidateDatabase;
			val.Start(); // *** exception here with pooling
			try
			{
				string s;
				while ((s =3D val.GetNextLine()) !=3D null)
				{
					textBox1.Text +=3D s;
				}
			}
			finally
			{
				val.Close();
			}

If I run this when the app starts, it's fine. But following opening a
connection with Pooling enabled, it raises a FbException in
'val.Start()', "No message for code 5 found".

If I turn pooling off, it works fine.

Interestingly, even if I wait for the pooled connection to be closed,
and try the code again, it still fails....

Thanks,

John

Re: Fw: [Firebird-net-provider] Does Fb .net provider support IB open source 6.0.20?

[tao l. <la...@ho...>]

It works great!

Thank you for your excellent work, Carlos!


----- Original Message ----- 
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "tao lin" <la...@ho...>
Sent: Thursday, February 19, 2004 11:47 AM
Subject: Re: Fw: [Firebird-net-provider] Does Fb .net provider support IB
open source 6.0.20?


> Hello:
>
> > Thank you, Carlos.
> >
> > Could you send the patch dll to me please? I am using Fb.Net Provider
1.5
> > RC5 under Ms.net 1.1.
>
>
> It's a zip file with the extension changed ( it has some more changes
> that aren't in the CVS )
>
> Test it and comment tes results please :)
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>

Re: Fw: [Firebird-net-provider] Does Fb .net provider support IB open source 6.0.20?

[tao l. <la...@ho...>]

Thank you, Carlos.

Could you send the patch dll to me please? I am using Fb.Net Provider 1.5
RC5 under Ms.net 1.1.

Cheers,
Tao

----- Original Message ----- 
From: "Carlos Guzmán Álvarez" <car...@te...>
To: "lams_yi" <la...@ho...>
Cc: <fir...@li...>
Sent: Thursday, February 19, 2004 3:42 AM
Subject: Re: Fw: [Firebird-net-provider] Does Fb .net provider support IB
open source 6.0.20?


> Hello:
>
> >  But I test the sqlCommand, it looks like it don't have this problem.
>
> But Sql Server has this built-in the server engine hehe ;)
>
> I'm going to commit a patch for this into the CVS, i can send to you a
> binary version of the dll if you tell me what version of the .NET data
> provider are you using and if you want it :)
>
>
>
>
>
> --
> Best regards
>
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

RE: [Firebird-net-provider] System.NullReferenceException

[Erik H. <hee...@zo...>]

Hello Carlos

Thanks for your swift reply. I retrieve the information about the stored
procedures in a few select statements which work without a problem.

I was not aware of FbConnection.GetDbSchemaTable and I will look into
that.

Erik=20

-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: woensdag 18 februari 2004 20:32
To: Erik Heemskerk
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] [Firebird-net-provider]


Hello:

> Here is my complete project=20
> http:/Home.zonnet.nl/heemskerk72/storedprocs.zip

I will try to review it.

> I try to read all the stored procedures from a database and their=20
> parameters to test them so I need the flexibility which I can't seem=20
> to get at the moment.

Are you trying to extract metadata information ?? if yes, the=20
FbConnection.GetDbSchemaTable method doesn't fit your needs ??





--
Best regards

Carlos Guzm=E1n =E1lvarez
Vigo-Spain

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

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

Hello:

> Here is my complete project
> http:/Home.zonnet.nl/heemskerk72/storedprocs.zip

I will try to review it.

> I try to read all the stored procedures from a database and their
> parameters to test them so I need the flexibility which I can't seem to
> get at the moment.

Are you trying to extract metadata information ?? if yes, the 
FbConnection.GetDbSchemaTable method doesn't fit your needs ??





--
Best regards

Carlos Guzmán álvarez
Vigo-Spain

[Firebird-net-provider] select quick

[Paola <pa...@sa...>]

Thank you, Alessandro

Also I have reached us, later

This is really that I wanted

However, my question is: how join then the lines in Dataset?

 

 

Sorry, Are you italian?

I have difficult write in English

Thanks

Paola.

[Firebird-net-provider] select quick

[Paola <pa...@sa...>]

Thanks 

But I use version 1.5

[Firebird-net-provider] [Firebird-net-provider]

[Erik H. <hee...@zo...>]

Hello all,

I may have a similar problem to the one described by JS.Staff in
"[Firebird-net-provider] Using FbDataAdapter in VS 2003". I get the same
System.NullReferenceException when I try to fill an instance of
FbDataAdapter. 

The weird part is that I try to call a stored procedure the FbCommand I
use which takes 2 input parameters and has 2 output-parameters. When I
set these input parameters hardcoded all is well and the procedure
returns what I expected, but when I read the parameters from a datagrid
I filled earlier it crashes. 

Here is my complete project
http:/Home.zonnet.nl/heemskerk72/storedprocs.zip

I try to read all the stored procedures from a database and their
parameters to test them so I need the flexibility which I can't seem to
get at the moment.

The (small) database I included in the zip has the default password set
on it.

I'm use Firebird RC8, net-provider version 1.5.1505.18636 and VS2003

I hope someone has the solution to this problem

Erik

RE: [Firebird-net-provider] select quick

[Marco B. <mar...@ai...>]

Thank you... now it's working properly. =20

The Newbie

> -----Original Message-----
> From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
> Sent: Wednesday, February 18, 2004 7:49 PM
> To: Marco Brambilla
> Cc: fir...@li...
> Subject: Re: [Firebird-net-provider] select quick
>=20
> Hello:
>=20
> >     SELECT FIRST :numrows SKIP 5
>=20
> Try this:
>=20
> 	SELECT FIRST (:numrows) SKIP 5
>=20
>=20
>=20
>=20
>=20
> --
> Best regards
>=20
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>=20

Re: [Firebird-net-provider] select quick

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

Hello:

>     SELECT FIRST :numrows SKIP 5

Try this:

	SELECT FIRST (:numrows) SKIP 5





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] select quick

[Marco B. <mar...@ai...>]

(Sorry for this off-topic question...)

Hi Alessandro... like Paola, I have a stored proc that needs to be improved
that way.

But I receive an error if I try to use FIRST... SKIP in a stored procedure.

Thanks in advance.

Here is the code:
--
alter PROCEDURE "sdqFORUMMSGSet_msgs"
    
(        
"_GHOST" SMALLINT,
"_ISDELETED" SMALLINT,
"_ID_SENDER" INTEGER,
"_ID_FORUM" INTEGER,
numrows INTEGER,
numfrom INTEGER
)

RETURNS
(
"GHOST" SMALLINT,
"ISDELETED" SMALLINT,
"ID" INTEGER,
"ID_SENDER" INTEGER,
"ID_FORUM" INTEGER,
"CREATED" TIMESTAMP,
"NICK_SENDER" VARCHAR(20),
"BODY" VARCHAR(2000)        
)

AS

BEGIN


    FOR
    SELECT FIRST :numrows SKIP 5
        
        "GHOST",
        "ISDELETED",
        "ID",
        "ID_SENDER",
        "ID_FORUM",
        "CREATED",
        "NICK_SENDER",
        "BODY"

    FROM
        "FORUMMSG"

    WHERE
        
        ("GHOST" = :"_GHOST" OR :"_GHOST" IS NULL)
         AND ("ISDELETED" = :"_ISDELETED" OR :"_ISDELETED" IS NULL)
         AND ("ID_SENDER" = :"_ID_SENDER" OR :"_ID_SENDER" IS NULL)
         AND ("ID_FORUM" = :"_ID_FORUM" OR :"_ID_FORUM" IS NULL)

ORDER BY CREATED desc

    INTO
        
        :"GHOST",
        :"ISDELETED",
        :"ID",
        :"ID_SENDER",
        :"ID_FORUM",
        :"CREATED",
        :"NICK_SENDER",
        :"BODY"
                  
    
  DO
  BEGIN
    SUSPEND;
  END


END
--


> -----Original Message-----
> From: fir...@li... 
> [mailto:fir...@li...] On 
> Behalf Of Alessandro Petrelli
> Sent: Wednesday, February 18, 2004 12:59 PM
> To: fir...@li...
> Subject: Re: [Firebird-net-provider] select quick

Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003

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

Hello:

>Yeah the dataset is being initialised by code made by Visual Studio - it 
 >fills fine (and updates, deletes and inserts when using the 
FbCommandBuilder).
 >Just not with manually written SQL.

I think i know where is the problem but i need to make a test using 
SqlClient too check how is working with it.





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Using FbDataAdapter in VS 2003

[JS.staff <jsp...@ec...>]

SGkgVG9ueSwNCiANClllYWggdGhlIGRhdGFzZXQgaXMgYmVpbmcgaW5pdGlhbGlzZWQgYnkgY29k
ZSBtYWRlIGJ5IFZpc3VhbCBTdHVkaW8gLSBpdCBmaWxscyBmaW5lIChhbmQgdXBkYXRlcywgZGVs
ZXRlcyBhbmQgaW5zZXJ0cyB3aGVuIHVzaW5nIHRoZSBGYkNvbW1hbmRCdWlsZGVyKS4gSnVzdCBu
b3Qgd2l0aCBtYW51YWxseSB3cml0dGVuIFNRTC4NCiANCkkgdXNlZCB0byB1c2UgRGVscGhpIGFs
bCB0aGUgdGltZSwgZ3JlYXQgbGFuZ3VhZ2UgLSBwaXR0eSBpdCdzIG5vdCBtb3JlIHBvcHVsYXIu
DQogDQpDIyBkb2VzIGhhdmUgc29tZSBhZHZhbnRhZ2VzIHRob3VnaC4gTGlrZSB0aGUgIldoYXQg
dGhlIGhlbGwgZG9lcyAqdGhhdCogbWVhbj8/PyIgZWZmZWN0IHdoZW4geW91ciBib3NzIGxvb2tz
IG92ZXIgeW91ciBzaG9sZGVyLiA7KQ0KIA0KVGhhbmtzLA0KIA0KSm9obg0KDQoJLS0tLS1Pcmln
aW5hbCBNZXNzYWdlLS0tLS0gDQoJRnJvbTogVG9ueSBSaXYgW21haWx0bzp0b255QHNvbWV3aGVy
ZS5jb21dIA0KCVNlbnQ6IFdlZCAxOC8wMi8yMDA0IDE2OjI5IA0KCVRvOiBmaXJlYmlyZC1uZXQt
cHJvdmlkZXJAbGlzdHMuc291cmNlZm9yZ2UubmV0IA0KCUNjOiANCglTdWJqZWN0OiBSZTogW0Zp
cmViaXJkLW5ldC1wcm92aWRlcl0gVXNpbmcgRmJEYXRhQWRhcHRlciBpbiBWUyAyMDAzDQoJDQoJ
DQoNCglEb24ndCBrbm93IGlmIHRoaXMgaGVscHMgb3IgaXMgcmVsZXZhbnQsIGJ1dCB3aGVuIHlv
dSB1c2UgdGhlICAuRmlsbCh4LHkpLA0KCUhhdmUgeW91IGluaXRpYWxpc2VkIHRoZSB4IGJlZm9y
ZWhhbmQNCgkNCglJbiBEZWxwaGkgKFNvcnJ5IGl0cyBpbiBEZWxwaGkpIHlvdSBoYXZlIHRvIHRv
IGRvIHRoZSBmb2xsb3dpbmcuLi4NCgkgeCA6PSBEYXRhU2V0LkNyZWF0ZTsNCglNeURhdGFBZGFw
LkZpbGwoeCwnVEVTVCcpOw0KCQ0KDQo=

Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003

[Tony R. <to...@so...>]

Don't know if this helps or is relevant, but when you use the  .Fill(x,y),
Have you initialised the x beforehand

In Delphi (Sorry its in Delphi) you have to to do the following...
 x := DataSet.Create;
MyDataAdap.Fill(x,'TEST');


""JS.staff"" <jsp...@ec...> wrote in message
news:2AF...@ec...ernal...
> Hi all,
>
> I'm experimenting with the .NET provider for Firebird (provider 1.5 RC5)
> and MS VS 2003 (Windows 2000, FB 1.5 RC7).
>
> I can fill a dataset, and update/insert manually using FbCommands, but
> am having problems with FbDataAdapter. When I do a .Fill(x,y) I get the
> following exception:
>
> "NullReferenceException: object not set to an instance of an object"
>
> Both Update and Insert command objects are specified. Any ideas?
>
> Thanks,
>
> John
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

RE: [Firebird-net-provider] Using FbDataAdapter in VS 2003

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

Hello:

> If I use the FbCommandBuilder to produce update/insert/delete commands it=
 works fine.....!!

ok, i will test your test case in one or two hours and i will comment
the result.






--
Best regards

Carlos Guzm=C3=A1n =C3=81lvarez
Vigo-Spain

RE: [Firebird-net-provider] Using FbDataAdapter in VS 2003

[JS.staff <jsp...@ec...>]

If I use the FbCommandBuilder to produce update/insert/delete commands =
it works fine.....!!

Help!

John


-----Original Message-----
From: JS.staff=20
Sent: 18 February 2004 13:39
To: fir...@li...
Subject: RE: [Firebird-net-provider] Using FbDataAdapter in VS 2003


Thanks for the quick reply. This duplicates my problem. I'm sure I'm =
doing (or not doing!) something dumb!

Uses a simple table, TESTTABLE (id integer, username varchar(50))

Thanks,

John

////////////////////////////////////////////
		private void tester()
		{
			FbCommand sel =3D new FbCommand("select id,username from =
testtable",fbConnection1);
			FbCommand upd =3D new FbCommand("update testtable set username =3D =
@username where id =3D @id",fbConnection1);
			FbCommand ins =3D new FbCommand("insert into testtable values =
(@id,@username)",fbConnection1);
			FbCommand del =3D new FbCommand("delete from testtable where id =3D =
@id",fbConnection1);
			upd.Parameters.Add("@username",FbDbType.VarChar);
			upd.Parameters.Add("@id",FbDbType.Integer);
			ins.Parameters.Add("@username",FbDbType.VarChar);
			ins.Parameters.Add("@id",FbDbType.Integer);
			del.Parameters.Add("@username",FbDbType.VarChar);
			del.Parameters.Add("@id",FbDbType.Integer);

			FbDataAdapter adap =3D new FbDataAdapter();
			adap.SelectCommand =3D sel;
			adap.UpdateCommand =3D upd;
			adap.InsertCommand =3D ins;
			adap.DeleteCommand =3D del;

			fbConnection1.Open();
			try
			{
				FbTransaction trans =3D =
fbConnection1.BeginTransaction(IsolationLevel.RepeatableRead);
				try
				{
					sel.Transaction =3D trans;
					upd.Transaction =3D trans;
					ins.Transaction =3D trans;
					del.Transaction =3D trans;
					adap.Update(dataSet1,"something");	// which requires an update call
					trans.Commit();
				}
				catch
				{
					trans.Rollback();
					throw;
				}
			}
			finally
			{
				fbConnection1.Close();
			}
		}

///////////////////////////////////////////////


-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: 18 February 2004 12:37
To: JS.staff
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003


Hello:

> "NullReferenceException: object not set to an instance of an object"
>=20
> Both Update and Insert command objects are specified. Any ideas?

Can you send a test case ??




--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain


-------------------------------------------------------
SF.Net is sponsored by: Speed Start Your Linux Apps Now.
Build and deploy apps & Web services for Linux with
a free DVD software kit from IBM. Click Now! =
http://ads.osdn.com/?ad_id=1356&alloc_id438&op=3Dick
_______________________________________________
Firebird-net-provider mailing list =
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

[Firebird-net-provider] Named parameters rework

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

Hello:

I have commited a fix into the CVS that reworks the named parameters 
extraction for try to solve the problems reported with '@' that inline 
in the sql command text.

Will be nice if anybody can give a try to them :) and report problems.

If there are people interested on test it i can send him/her a binary 
version of the CVS sources.


Thanks in advance.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: Fw: [Firebird-net-provider] Does Fb .net provider support IB open source 6.0.20?

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

Hello:

>  But I test the sqlCommand, it looks like it don't have this problem.

But Sql Server has this built-in the server engine hehe ;)

I'm going to commit a patch for this into the CVS, i can send to you a 
binary version of the dll if you tell me what version of the .NET data 
provider are you using and if you want it :)





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

RE: [Firebird-net-provider] Using FbDataAdapter in VS 2003

[JS.staff <jsp...@ec...>]

Thanks for the quick reply. This duplicates my problem. I'm sure I'm =
doing (or not doing!) something dumb!

Uses a simple table, TESTTABLE (id integer, username varchar(50))

Thanks,

John

////////////////////////////////////////////
		private void tester()
		{
			FbCommand sel =3D new FbCommand("select id,username from =
testtable",fbConnection1);
			FbCommand upd =3D new FbCommand("update testtable set username =3D =
@username where id =3D @id",fbConnection1);
			FbCommand ins =3D new FbCommand("insert into testtable values =
(@id,@username)",fbConnection1);
			FbCommand del =3D new FbCommand("delete from testtable where id =3D =
@id",fbConnection1);
			upd.Parameters.Add("@username",FbDbType.VarChar);
			upd.Parameters.Add("@id",FbDbType.Integer);
			ins.Parameters.Add("@username",FbDbType.VarChar);
			ins.Parameters.Add("@id",FbDbType.Integer);
			del.Parameters.Add("@username",FbDbType.VarChar);
			del.Parameters.Add("@id",FbDbType.Integer);

			FbDataAdapter adap =3D new FbDataAdapter();
			adap.SelectCommand =3D sel;
			adap.UpdateCommand =3D upd;
			adap.InsertCommand =3D ins;
			adap.DeleteCommand =3D del;

			fbConnection1.Open();
			try
			{
				FbTransaction trans =3D =
fbConnection1.BeginTransaction(IsolationLevel.RepeatableRead);
				try
				{
					sel.Transaction =3D trans;
					upd.Transaction =3D trans;
					ins.Transaction =3D trans;
					del.Transaction =3D trans;
					adap.Update(dataSet1,"something");	// which requires an update call
					trans.Commit();
				}
				catch
				{
					trans.Rollback();
					throw;
				}
			}
			finally
			{
				fbConnection1.Close();
			}
		}

///////////////////////////////////////////////


-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: 18 February 2004 12:37
To: JS.staff
Cc: fir...@li...
Subject: Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003


Hello:

> "NullReferenceException: object not set to an instance of an object"
>=20
> Both Update and Insert command objects are specified. Any ideas?

Can you send a test case ??




--
Best regards

Carlos Guzm=E1n =C1lvarez
Vigo-Spain

Re: [Firebird-net-provider] Using FbDataAdapter in VS 2003

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

Hello:

> "NullReferenceException: object not set to an instance of an object"
> 
> Both Update and Insert command objects are specified. Any ideas?

Can you send a test case ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain