Menu
▾
▴
firebird-net-provider — All about development of the MS .Net provider
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(10) |
Nov
(55) |
Dec
(36) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(38) |
Feb
(108) |
Mar
(79) |
Apr
(95) |
May
(64) |
Jun
(130) |
Jul
(146) |
Aug
(121) |
Sep
(96) |
Oct
(149) |
Nov
(161) |
Dec
(113) |
| 2004 |
Jan
(113) |
Feb
(163) |
Mar
(248) |
Apr
(132) |
May
(157) |
Jun
(160) |
Jul
(236) |
Aug
(284) |
Sep
(293) |
Oct
(277) |
Nov
(257) |
Dec
(356) |
| 2005 |
Jan
(203) |
Feb
(190) |
Mar
(220) |
Apr
(165) |
May
(124) |
Jun
(160) |
Jul
(190) |
Aug
(142) |
Sep
(152) |
Oct
(189) |
Nov
(187) |
Dec
(159) |
| 2006 |
Jan
(170) |
Feb
(151) |
Mar
(212) |
Apr
(262) |
May
(226) |
Jun
(196) |
Jul
(223) |
Aug
(165) |
Sep
(163) |
Oct
(348) |
Nov
(225) |
Dec
(141) |
| 2007 |
Jan
(261) |
Feb
(161) |
Mar
(222) |
Apr
(193) |
May
(121) |
Jun
(157) |
Jul
(151) |
Aug
(159) |
Sep
(61) |
Oct
(123) |
Nov
(172) |
Dec
(96) |
| 2008 |
Jan
(104) |
Feb
(138) |
Mar
(131) |
Apr
(131) |
May
(74) |
Jun
(107) |
Jul
(89) |
Aug
(89) |
Sep
(172) |
Oct
(158) |
Nov
(119) |
Dec
(86) |
| 2009 |
Jan
(52) |
Feb
(84) |
Mar
(78) |
Apr
(83) |
May
(54) |
Jun
(79) |
Jul
(60) |
Aug
(62) |
Sep
(50) |
Oct
(147) |
Nov
(50) |
Dec
(70) |
| 2010 |
Jan
(135) |
Feb
(113) |
Mar
(74) |
Apr
(93) |
May
(35) |
Jun
(71) |
Jul
(33) |
Aug
(110) |
Sep
(47) |
Oct
(18) |
Nov
(61) |
Dec
(34) |
| 2011 |
Jan
(46) |
Feb
(47) |
Mar
(25) |
Apr
(24) |
May
(21) |
Jun
(22) |
Jul
(20) |
Aug
(51) |
Sep
(31) |
Oct
(42) |
Nov
(22) |
Dec
(22) |
| 2012 |
Jan
(31) |
Feb
(19) |
Mar
(25) |
Apr
(55) |
May
(16) |
Jun
(28) |
Jul
(33) |
Aug
(25) |
Sep
(32) |
Oct
(25) |
Nov
(52) |
Dec
(35) |
| 2013 |
Jan
(43) |
Feb
(18) |
Mar
(36) |
Apr
(45) |
May
(22) |
Jun
(13) |
Jul
(31) |
Aug
(24) |
Sep
(19) |
Oct
(59) |
Nov
(47) |
Dec
(25) |
| 2014 |
Jan
(27) |
Feb
(15) |
Mar
(38) |
Apr
(10) |
May
(15) |
Jun
(36) |
Jul
(24) |
Aug
(28) |
Sep
(16) |
Oct
(6) |
Nov
(44) |
Dec
(40) |
| 2015 |
Jan
(52) |
Feb
(22) |
Mar
(13) |
Apr
(17) |
May
(22) |
Jun
(36) |
Jul
(18) |
Aug
(41) |
Sep
(71) |
Oct
(60) |
Nov
(49) |
Dec
(43) |
| 2016 |
Jan
(60) |
Feb
(13) |
Mar
(21) |
Apr
(28) |
May
(23) |
Jun
(39) |
Jul
(17) |
Aug
(37) |
Sep
(33) |
Oct
(15) |
Nov
(22) |
Dec
(20) |
| 2017 |
Jan
(27) |
Feb
(40) |
Mar
(48) |
Apr
(19) |
May
(29) |
Jun
(2) |
Jul
(19) |
Aug
(36) |
Sep
(18) |
Oct
(10) |
Nov
(11) |
Dec
(5) |
| 2018 |
Jan
(5) |
Feb
(4) |
Mar
(5) |
Apr
(3) |
May
(4) |
Jun
(17) |
Jul
(7) |
Aug
(7) |
Sep
(12) |
Oct
(8) |
Nov
(2) |
Dec
|
| 2019 |
Jan
(8) |
Feb
(5) |
Mar
(3) |
Apr
(5) |
May
(3) |
Jun
(2) |
Jul
(8) |
Aug
(7) |
Sep
(3) |
Oct
(12) |
Nov
(7) |
Dec
(1) |
| 2020 |
Jan
(8) |
Feb
(3) |
Mar
(7) |
Apr
(1) |
May
(2) |
Jun
(1) |
Jul
(3) |
Aug
(25) |
Sep
(5) |
Oct
(3) |
Nov
(7) |
Dec
(16) |
| 2021 |
Jan
(11) |
Feb
(10) |
Mar
(16) |
Apr
(8) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Gianni Di P. <g.d...@ca...> - 2004-03-19 06:46:08
|
There is an error in the installation of DataProvider 1.6 for .NET 1.1. FirebirdSql.Data.Firebird.dll is copied into temp folder and not in = program folder. Gianni |
|
From: Austin S. <aus...@sp...> - 2004-03-19 05:36:41
|
Thank you for your response. I have not had much experience with ADO. How can I use Visual Studio.NET with C# and access Firebird as the back = end SQL data base. =20 Thanks, Austin Sauls -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of fir...@li... Sent: Thursday, March 18, 2004 11:04 PM To: fir...@li... Subject: Firebird-net-provider digest, Vol 1 #374 - 2 msgs Send Firebird-net-provider mailing list submissions to fir...@li... To subscribe or unsubscribe via the World Wide Web, visit https://lists.sourceforge.net/lists/listinfo/firebird-net-provider or, via email, send a message with subject or body 'help' to fir...@li... You can reach the person managing the list at fir...@li... When replying, please edit your Subject line so it is more specific than "Re: Contents of Firebird-net-provider digest..." Today's Topics: 1. Re: Visual Studio.NET and C#. (=3D?ISO-8859-1?Q?Carlos_Guzm=3DE1n_=3DC1lvarez?=3D) 2. RE: Visual Studio.NET and C#.[Scanned] (JS.staff) --__--__-- Message: 1 Date: Fri, 19 Mar 2004 00:03:55 +0100 From: =3D?ISO-8859-1?Q?Carlos_Guzm=3DE1n_=3DC1lvarez?=3D <car...@te...> To: fir...@li... Subject: Re: [Firebird-net-provider] Visual Studio.NET and C#. Hello: > The first tab is for Provider and there are only OLE DB providers in = the=20 > list. Maybe i am not wrong but if it shows only OleDb Drivers it will be not=20 possible to use it with the provider ( that is an ADO.NET provider not=20 an OldDb driver ) -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain --__--__-- Message: 2 Subject: RE: [Firebird-net-provider] Visual Studio.NET and C#.[Scanned] Date: Thu, 18 Mar 2004 23:37:57 -0000 From: "JS.staff" <jsp...@ec...> To: <fir...@li...> SGlhIEF1c3RpbiwNCiANCkknbSB1c2luZyB0aGUgcHJvdmlkZXIgd2l0aCBWUyAyMDAzLiBZb= 3Ug bmVlZCB0byBpbnN0YWxsIHRoZSBjb21wb25lbnRzIG9uIHRoZSB0b29sYmFyLCAoJ1Rvb2xzJ= yBt ZW51LCB0aGVuICdhZGQgcmVtb3ZlIHRvb2xib3ggaXRlbXMnLCB0aGVuIGZpbmQgdGhlIGFzc= 2Vt Ymx5IGZvciB0aGUgLm5ldCBwcm92aWRlciwgdXN1YWxseSBpbiBDOlxQcm9ncmFtIEZpbGVzX= EZp cmViaXJkTkVUUHJvdmlkZXIxLjUNCiANClRoZW4gc2VsZWN0IHRoZSAnRmlyZWJpcmRTcWwuR= GF0 YS5GaXJlYmlyZC5kbGwnIGZpbGUuIFRoaXMgc2hvdWxkIG1ha2UgdGhlIEZiQ29ubmVjdGlvb= iwg RmJDb21tYW5kIGV0YyBjb21wb25lbnRzIGFwcGVhciBpbiB0aGUgdG9vbGJveC4NCiANCkl0I= Hdv cmtzIGluZGVwZW5kZW50bHkgb2YgdGhlIE9MRSBEQiBjb21wb25lbnRzIC0gbm90aGluZyB0b= yBk byB3aXRoIHRoZW0uDQogDQpPaCwgYW5vdGhlciAnZ290Y2hhJyAtIHlvdSdsbCBuZWVkIHRvI= GFk ZCB0aGUgYXNzZW1ibHkgdG8gdGhlICdSZWZlcmVuY2VzJyBzZWN0aW9uIG9mIGVhY2ggcHJva= mVj dCB0aGF0IHVzZXMgaXQuIE90aGVyd2lzZSB5b3UgZ2V0IGFuIGVycm9yIHdoZW4geW91IGRyb= 3Ag dGhlIGNvbXBvbmVudHMgb250byB0aGUgZm9ybS4NCiANCklmIHlvdSBuZWVkIGhlbHAgbWFra= W5n IHR5cGVkIGRhdGFzZXRzLCBpdmUgZ290IHNvbWUgY29kZSB0byBtYWtlIGl0IGEgbGl0dGxlI= GVh c2llciAtIG5vdCBhcyBzbGljayBhcyB0aGUgU1FMIFNlcnZlciB0b29scyB0aG91Z2guDQogD= QpK b2huDQoNCgktLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBBdXN0aW4gU2F1b= HMg W21haWx0bzphdXN0aW5zYXVsc0BzcGVlY2gtc2VydmVyLmNvbV0gDQoJU2VudDogVGh1IDE4L= zAz LzIwMDQgMjI6MjkgDQoJVG86IGZpcmViaXJkLW5ldC1wcm92aWRlckBsaXN0cy5zb3VyY2Vmb= 3Jn ZS5uZXQgDQoJQ2M6IA0KCVN1YmplY3Q6IFtGaXJlYmlyZC1uZXQtcHJvdmlkZXJdIFZpc3Vhb= CBT dHVkaW8uTkVUIGFuZCBDIy5bU2Nhbm5lZF0NCgkNCgkNCg0KCUkgaGF2ZSBjcmVhdGVkIGEgR= mly ZWJpcmQgZGF0YWJhc2UgKEM6XENNRFJQVC5GREIpLg0KDQoJV2hlbiBJIGFtIGluIFZpc3Vhb= CBT dHVkaW8uTkVUIGFuZCB1c2luZyBDIywgSSBhbSB0cnlpbmcgdG8gYWRkIGEgZGF0YSBmb3JtL= g0K DQoJVGhlIGRhdGEgZm9ybSB3aXphcmQgYXNrcyBtZSBzb21lIHF1ZXN0aW9ucy4NCg0KCUl0I= Ghh cyBhIERhdGEgTGluayBQcm9wZXJ0aWVzIHBhZ2UuDQoNCglUaGUgZmlyc3QgdGFiIGlzIGZvc= iBQ cm92aWRlciBhbmQgdGhlcmUgYXJlIG9ubHkgT0xFIERCIHByb3ZpZGVycyBpbiB0aGUgbGlzd= C4N Cg0KCURvIEkgaGF2ZSB0byBwbGFjZSB0aGUgZmlyZWJpcmQgLm5ldCBkYXRhIHByb3ZpZGVyI= Glu dG8gYSBzcGVjaWFsIGZvbGRlciwgZXRjLg0KDQoJQWxzbyB0aGUgc2Vjb25kIHRhYiBvbiB0a= GUg RGF0YSBMaW5rIFByb3BlcnRpZXMgcGFnZSBpcyBhIGNvbm5lY3Rpb24gdGVzdC4NCg0KCUkgY= W0g dXNpbmcgc2VydmVyIG5hbWUgb2YgbG9jYWwgaG9zdCBhbmQgdXNpbmcg4oCcQzpcQ01EUlBUL= kZE QuKAnSBhcyB0aGUgZGF0YWJhc2Ugb24gdGhlIHNlcnZlci4NCg0KCUkgY2FuIG5vdCBjb25uZ= WN0 IHRvIHRoZSBGaXJlYmlyZCBEYXRhQmFzZS4NCg0KCVRoYW5rcywNCg0KCUF1c3RpbiBTYXVsc= w0K DQo=3D --__--__-- _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider End of Firebird-net-provider Digest |
|
From: JS.staff <jsp...@ec...> - 2004-03-18 23:45:25
|
SGlhIEF1c3RpbiwNCiANCkknbSB1c2luZyB0aGUgcHJvdmlkZXIgd2l0aCBWUyAyMDAzLiBZb3Ug bmVlZCB0byBpbnN0YWxsIHRoZSBjb21wb25lbnRzIG9uIHRoZSB0b29sYmFyLCAoJ1Rvb2xzJyBt ZW51LCB0aGVuICdhZGQgcmVtb3ZlIHRvb2xib3ggaXRlbXMnLCB0aGVuIGZpbmQgdGhlIGFzc2Vt Ymx5IGZvciB0aGUgLm5ldCBwcm92aWRlciwgdXN1YWxseSBpbiBDOlxQcm9ncmFtIEZpbGVzXEZp cmViaXJkTkVUUHJvdmlkZXIxLjUNCiANClRoZW4gc2VsZWN0IHRoZSAnRmlyZWJpcmRTcWwuRGF0 YS5GaXJlYmlyZC5kbGwnIGZpbGUuIFRoaXMgc2hvdWxkIG1ha2UgdGhlIEZiQ29ubmVjdGlvbiwg RmJDb21tYW5kIGV0YyBjb21wb25lbnRzIGFwcGVhciBpbiB0aGUgdG9vbGJveC4NCiANCkl0IHdv cmtzIGluZGVwZW5kZW50bHkgb2YgdGhlIE9MRSBEQiBjb21wb25lbnRzIC0gbm90aGluZyB0byBk byB3aXRoIHRoZW0uDQogDQpPaCwgYW5vdGhlciAnZ290Y2hhJyAtIHlvdSdsbCBuZWVkIHRvIGFk ZCB0aGUgYXNzZW1ibHkgdG8gdGhlICdSZWZlcmVuY2VzJyBzZWN0aW9uIG9mIGVhY2ggcHJvamVj dCB0aGF0IHVzZXMgaXQuIE90aGVyd2lzZSB5b3UgZ2V0IGFuIGVycm9yIHdoZW4geW91IGRyb3Ag dGhlIGNvbXBvbmVudHMgb250byB0aGUgZm9ybS4NCiANCklmIHlvdSBuZWVkIGhlbHAgbWFraW5n IHR5cGVkIGRhdGFzZXRzLCBpdmUgZ290IHNvbWUgY29kZSB0byBtYWtlIGl0IGEgbGl0dGxlIGVh c2llciAtIG5vdCBhcyBzbGljayBhcyB0aGUgU1FMIFNlcnZlciB0b29scyB0aG91Z2guDQogDQpK b2huDQoNCgktLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLSANCglGcm9tOiBBdXN0aW4gU2F1bHMg W21haWx0bzphdXN0aW5zYXVsc0BzcGVlY2gtc2VydmVyLmNvbV0gDQoJU2VudDogVGh1IDE4LzAz LzIwMDQgMjI6MjkgDQoJVG86IGZpcmViaXJkLW5ldC1wcm92aWRlckBsaXN0cy5zb3VyY2Vmb3Jn ZS5uZXQgDQoJQ2M6IA0KCVN1YmplY3Q6IFtGaXJlYmlyZC1uZXQtcHJvdmlkZXJdIFZpc3VhbCBT dHVkaW8uTkVUIGFuZCBDIy5bU2Nhbm5lZF0NCgkNCgkNCg0KCUkgaGF2ZSBjcmVhdGVkIGEgRmly ZWJpcmQgZGF0YWJhc2UgKEM6XENNRFJQVC5GREIpLg0KDQoJV2hlbiBJIGFtIGluIFZpc3VhbCBT dHVkaW8uTkVUIGFuZCB1c2luZyBDIywgSSBhbSB0cnlpbmcgdG8gYWRkIGEgZGF0YSBmb3JtLg0K DQoJVGhlIGRhdGEgZm9ybSB3aXphcmQgYXNrcyBtZSBzb21lIHF1ZXN0aW9ucy4NCg0KCUl0IGhh cyBhIERhdGEgTGluayBQcm9wZXJ0aWVzIHBhZ2UuDQoNCglUaGUgZmlyc3QgdGFiIGlzIGZvciBQ cm92aWRlciBhbmQgdGhlcmUgYXJlIG9ubHkgT0xFIERCIHByb3ZpZGVycyBpbiB0aGUgbGlzdC4N Cg0KCURvIEkgaGF2ZSB0byBwbGFjZSB0aGUgZmlyZWJpcmQgLm5ldCBkYXRhIHByb3ZpZGVyIGlu dG8gYSBzcGVjaWFsIGZvbGRlciwgZXRjLg0KDQoJQWxzbyB0aGUgc2Vjb25kIHRhYiBvbiB0aGUg RGF0YSBMaW5rIFByb3BlcnRpZXMgcGFnZSBpcyBhIGNvbm5lY3Rpb24gdGVzdC4NCg0KCUkgYW0g dXNpbmcgc2VydmVyIG5hbWUgb2YgbG9jYWwgaG9zdCBhbmQgdXNpbmcg4oCcQzpcQ01EUlBULkZE QuKAnSBhcyB0aGUgZGF0YWJhc2Ugb24gdGhlIHNlcnZlci4NCg0KCUkgY2FuIG5vdCBjb25uZWN0 IHRvIHRoZSBGaXJlYmlyZCBEYXRhQmFzZS4NCg0KCVRoYW5rcywNCg0KCUF1c3RpbiBTYXVscw0K DQo= |
|
From:
<car...@te...> - 2004-03-18 23:03:56
|
Hello: > The first tab is for Provider and there are only OLE DB providers in the > list. Maybe i am not wrong but if it shows only OleDb Drivers it will be not possible to use it with the provider ( that is an ADO.NET provider not an OldDb driver ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Austin S. <aus...@sp...> - 2004-03-18 22:29:43
|
I have created a Firebird database (C:\CMDRPT.FDB). When I am in Visual Studio.NET and using C#, I am trying to add a data form. The data form wizard asks me some questions. It has a Data Link Properties page. The first tab is for Provider and there are only OLE DB providers in the list. Do I have to place the firebird .net data provider into a special folder, etc. Also the second tab on the Data Link Properties page is a connection test. I am using server name of local host and using "C:\CMDRPT.FDB" as the database on the server. I can not connect to the Firebird DataBase. Thanks, Austin Sauls |
|
From:
<car...@te...> - 2004-03-18 20:09:13
|
Hello: > Any suggestions? In the development machine do you have the Firebird .NET provider assembly in the GAC ?? in that case are you making refernce to that assembly ?? if yes, maybe you need to install the Firebird .NET Data Provider in the GAC in the new computers. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Pascal P. <P.P...@eq...> - 2004-03-18 14:23:40
|
Hi,=20 =20 I use Delphi8. Programs using the firebird .NET driver run only on my development system.=20 What have to be done for running the program on other computers? Framework 1.1 is installed and the FirebirdSql.Data.Firebird.dll is available at the same path as the exe is.=20 But every time I try to run the program I get a fatal error.=20 =20 Any suggestions? =20 =20 Mit freundlichen Gr=FCssen - best regards =20 Pascal Potrafke Fachinformatiker EQUITANIA KG Das Programmierteam Hermann-Hesse-Strasse 56 75223 Niefern-=D6schelbronn Deutschland - Germany fon +49 (0) 7043 953493 fax +49 (0) 7043 953494 Support-Hotline: (0) 7233 941558 =20 <outbind://17-000000003A10D8F4A37FC44D9049F520A6A8AB7FE4082300/www.equit ania.de> www.equitania.de mailto:in...@eq... =20 |
|
From:
<car...@te...> - 2004-03-18 11:45:30
|
Hello: > This is part of a routine to store any dataset into the database, so I > create the SQL for the table as well (although the code is not yet > complete). > OK, here it is: Thanks i will try to review it soon :) -- Best regards Carlos Guzmán Álvarez vigo-Spain |
|
From: Peter M. <P.m...@de...> - 2004-03-18 11:36:19
|
.> I have had difficulties with large inserts (> 16000). Do you experience
.any?
.No, but i have tested large inserts ( using AS3AP benchmark, up to
.500000 inserts ) but no using DataSets, can you post a code snippet ??,
.i can try to a test if needed.
This is part of a routine to store any dataset into the database, so I
create the SQL for the table as well (although the code is not yet
complete).
OK, here it is:
string TableName = "TEST1";
string Message = String.Empty;
DataSet ds = new DataSet("ds"+ TableName);
DataTable dt;
dt = new DataTable(TableName);
dt.Columns.Add("TSTAMP",typeof(String));
dt.Columns.Add("ID",typeof(Int32));
dt.Columns.Add("MSG",typeof(String));
ds.Tables.Add(dt);
// ExecuteNonQuery("drop table " + TableName + ";");
bool first1 = true;
bool HasID = false;
string cmd = "create table " + TableName + "(";
for(int i=0; i < ds.Tables[0].Columns.Count; i++)
{
DataColumn dc = ds.Tables[0].Columns[i];
if( first1 ) first1 = false;
else
{
cmd += ",";
}
System.Text.StringBuilder fc = new
System.Text.StringBuilder(dc.ColumnName.ToUpper());
if( fc.Length < 1 )
{
Message = "Kolom zonder naam
gevonden";
return ;
}
if( !System.Char.IsLetter(fc[0]) ) fc = new
System.Text.StringBuilder("N"+ fc) ;
for( int k =0 ; k < fc.Length;k++)
{
if(
System.Char.IsLetterOrDigit(fc[k]) ) continue;
fc[k] = '_'; // maak van de rest
een underscore
}
if( fc.ToString() == "ID" )
{
HasID = true;
dc.AllowDBNull = false;
}
fc.Append(" ");
if( dc.DataType == typeof(System.DateTime))
fc.Append( "TIMESTAMP");
else if( dc.DataType ==
typeof(System.Int16)) fc.Append("INTEGER");
else if( dc.DataType ==
typeof(System.Int32)) fc.Append( "INTEGER");
else if( dc.DataType ==
typeof(System.Double)) fc.Append("DOUBLE PRECISION");
else if( dc.DataType ==
typeof(System.Object)) fc.Append( "BLOB");
else
{
fc.Append("VARCHAR(30)");
}
if( ! dc.AllowDBNull ) fc.Append( " not
null");
cmd += fc;
}
if( !HasID )
{
cmd += ",ID INTEGER NOT NULL";
}
cmd += ");";
db.ExecuteNonQuery(cmd);
// create primary keys: todo gebruik key van tabel
cmd = @"alter table " + TableName + " add constraint
PK1 primary key (ID);";
db.ExecuteNonQuery(cmd);
FbDataAdapter mDataAdapter = new
FbDataAdapter();
mDataAdapter.SelectCommand = new FbCommand("SELECT *
FROM " + TableName + ";", db.myConnection,db.txn);
FbCommandBuilder cb = new
FbCommandBuilder(mDataAdapter); // genereer de insert, etc
DataSet nds = new DataSet("ds" + TableName);
mDataAdapter.Fill(nds, TableName);
nds.Tables[0].TableName = TableName;
int id = 1;
int c = 0;
for(int j=0; j < 50000; j++){
DataRow dr = ds.Tables[0].NewRow();
dr["ID"] = id++;
dr["TSTAMP"] =
System.DateTime.Now.ToShortTimeString();
dr["MSG"] =
System.DateTime.Now.ToShortDateString();
ds.Tables[0].Rows.Add(dr);
}
mDataAdapter.Update(ds,TableName); // do it
db.Commit(); // retaining
}
This results in:
An unhandled exception of type 'FirebirdSql.Data.Firebird.FbException'
occurred in system.data.dll
Additional information: invalid request handle
If j is run up to 10000, it will execute fine.
Hope you can find anything.
Peter
|
|
From:
<car...@te...> - 2004-03-18 10:03:45
|
Hello: > I have had difficulties with large inserts (> 16000). Do you experience any? No, but i have tested large inserts ( using AS3AP benchmark, up to 500000 inserts ) but no using DataSets, can you post a code snippet ??, i can try to a test if needed. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Peter M. <P.m...@de...> - 2004-03-18 09:36:11
|
.> Is there a "quicker" way to insert many rows into a table via the .Net .> Provider? .Try using Prepared statements. I use datasets and the update command, so I let the Provider do the thinking :) I have had difficulties with large inserts (> 16000). Do you experience any? Peter |
|
From:
<car...@te...> - 2004-03-18 09:30:51
|
Hello: > Is there a "quicker" way to insert many rows into a table via the .Net > Provider? Try using Prepared statements. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: thomas h. <fir...@th...> - 2004-03-18 09:26:46
|
Hi,
=20
In my test case, i insert many (about 10'000) rows (row by row) into a
table:=20
=20
for (int il =3D 0; il < 10000; il++) {
myCommand->CommandText =3D String::Format("INSERT INTO =
punktetabelle(PTNR,
XP, YP, ZP) Values('{0}', '1.11', '2.22', '3.33')", il.ToString());
myCommand->ExecuteNonQuery();
}
=20
This is very slow (about 1 minute). When i do the same in a Stored =
Procedure
the speed is ok (about 1 second). Is this normal? I know that the .Net
Provider communicate always via TCP/IP.... do this 10000 =
insert-statement
produce so much overhead???
Is there a "quicker" way to insert many rows into a table via the .Net
Provider?
=20
thanks, thomas
=20
=20
|
|
From:
<car...@te...> - 2004-03-17 23:00:05
|
Hello: > Does DataAdapter localy make unique identifiers (on server defined with > triggers/generators)? Huummm can you confirm that the sample of the training session referes to the DataAdapter class and not the DataSet class ?? ( i have done a little test and the DataSet generates a new id for a new column if it have set AutoIncremement, AutoIncrementSeed and AutoIncrememtStep properties ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-17 10:12:02
|
Hello: > I built the FirebirdSql.Data.Firebird.dll finally, but why I din see > the FirebirdSql.Data.Firebird.UnitTest.dll ? Do you have NUNit 2.1 installed ?? >... and did nant actually > have add the assembly to > C:\Windows\assembly ?? Use gacutil.exe for install it in the GAC > And finally, I found a solution on the problem on 'FbDbType' by > replacing it using 'FbType' .... After that vbnetexample looks fine. > does it mean the sample have to be modified in order to work? No, FbType was defined only in 1.0, 1.5 and 1.6 have defined FbDbType. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: benny <be...@ch...> - 2004-03-17 10:01:28
|
Carlos wrote:- The ASP.NET samples directory has the VB.NET and C# samples, the=20 web.config file and a bin directory with the .NET provider assembly and = runs fine. Hi,=20 I built the FirebirdSql.Data.Firebird.dll finally, but why I din see = the FirebirdSql.Data.Firebird.UnitTest.dll ?... and did nant actually = have add the assembly to=20 C:\Windows\assembly ??=20 And finally, I found a solution on the problem on 'FbDbType' by = replacing it using 'FbType' .... After that vbnetexample looks fine. = does it mean the sample have to be modified in order to work? TIA regards, benny=20 =20 |
|
From: Dmitry A. <fd...@ua...> - 2004-03-16 12:08:18
|
Hello All!
Recently we have added the non-standard behaviour in class
FbCommandBuilder. But in principle there is else new features,
which wanted see! So for instance presently are completely
ignored type of the field NULLABLE/NOT NULL, and at building of
the request is considered that he NULLABLE, because of what
unjustified is built more heavy request, but exactly so works
SqlClient, which consider the standard.
However want to have a normal generator request, which could
work better :-) I offer to do the new class FbCommandBuilderEx,
which will possess all specific features (and standard too), but
standard FbCommandBuilder -- will remain only it is correct to
adjust FbCommandBuilderEx. Thereby we shall be able not breaking
standard ;) liberally add the new possibilities. :-)
Opinions?
--
Best regards,
Dmitry mailto:fd...@ua...
|
|
From:
<car...@te...> - 2004-03-16 10:56:50
|
Hello: > Great, thanks. > Is there also any raw timeframe one could expect a BDP-driver? a half > year, a year .... No, in first place it's going to be developed by Abel Eduardo Pereira, i will help too, it will depend in the time he has for doing it and the documentation on how to do it that is very poor ;) -- Best Regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-16 10:55:03
|
Hello: > - The Nant build file generates (inside framework version directory > net-1.0, net-1.1, ...): [does it mean I need to copy the file NAnt.exe > and NAnt.exe.config to > the folder where contain Build dos batch file??? ] No, the best is to add the nant-bin directory to the PATH and execute one of the .BAT files that are in the Firebird .NET provider sources directory. You can modify too the nant config file for set the default framework to the one you are using. -- Bets regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Johannes <n@n.com> - 2004-03-16 10:15:30
|
Carlos Guzmán Álvarez wrote: > Hello: > >> I wonder if there exists an Borland BDP driver for Firebird? > > > No yet. > >> If it doesn't exist then are there any plans for creating one? > > > Yes, there are plans for it. > > Great, thanks. Is there also any raw timeframe one could expect a BDP-driver? a half year, a year .... Regards Johannes |
|
From: benny <be...@ch...> - 2004-03-16 10:06:50
|
Hi, Too sad for me to say I still hadn't solve the problem... I tried in = another platform e.g. Win2k but unfortunely I still have the same = problem when I tried on the=20 FirebirdNETProvider1.5.1-NET1.1 on the vbnetexample....=20 I think of another alternative is to build the = FirebirdSql.Data.Firebird.dll using nant...[I had download the = FirebirdNETProvider1.5.1-Src.zip and nant-0.84.zip] But I am not = familiar with it plus what the readme.txt had mentioned:- For build it you only need to exececute nant on the same directory as = the build file. [Is it refer to FirebirdSql.Data.Firebird build file??] - The Nant build file generates (inside framework version directory = net-1.0, net-1.1, ...): [does it mean I need to copy the file NAnt.exe = and NAnt.exe.config to=20 the folder where contain Build dos batch file??? ]=20 I tried on using build command where located at C:\Program = Files\FirebirdNETProvider1.5\NETProvider\NETProvider_15\=20 and I put the NAnt.exe and NAnt.exe.config to there as well ... but I = have error ... then I tried to copy the whole file consist in bin folder :- = ..\nant-0.84\bin then it seem no error but I can't see the file e.g = FirebirdSql.Data.Firebird.dll .. and after that I still have problem of 'FbDbType' is not declared on = vbnetsample..=20 Could anyone show me some hints ? TIA regards, benny |
|
From:
<car...@te...> - 2004-03-16 09:33:31
|
Hello: > The moment ; is parsed by teh .NEt prov, it thinks that the command has > reached its end even though the ; is contained between 2 ' ' such as > 'Jimmy;s'. > > Please Help! Using what version of the .NET Data Provider ?? In any case I will try to make a test later today, with lartest 1.5 and 1.6 ( You can solve it using parameterized querys ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-03-16 09:30:08
|
Hello: > I am trying to fill a stream from a blob field using a DataReader. The > code is from the .Net BLOB examples. Below is the code I am using and > the exception. Could you look at this and help me figure out what I am > doing wrong? Are you sure that the field has data ?? can you add a check for null before read ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Samrat G. <sg...@he...> - 2004-03-16 05:08:29
|
Hello, If I have a ';' in a varchar attribute's data, then any command which involves that attribute fails. Is there a solution to this problem. This happens not just for ; but also for ' apostrophie contained in a attribute value. How am I supposed to write insert and update statements where attribute values contain such special characters. The moment ; is parsed by teh .NEt prov, it thinks that the command has reached its end even though the ; is contained between 2 ' ' such as 'Jimmy;s'. Please Help! Regards, Samrat. |
|
From: Bob L. <bo...@ta...> - 2004-03-16 00:49:52
|
Carols:
I am trying to fill a stream from a blob field using a DataReader. The =
code is from the .Net BLOB examples. Below is the code I am using and =
the exception. Could you look at this and help me figure out what I am =
doing wrong?
Thanks
Bob
Code:
private FileStream LoadFileStream ( FbDataReader aReader, out object[] =
aRecipeArray )
{
aRecipeArray =3D null;
BinaryWriter bw =3D null; // Streams the BLOB to the FileStream =
object.
FileStream fs =3D null;
int bufferSize =3D 100; // Size of the BLOB buffer.
byte[] outbyte =3D new byte[ bufferSize ]; // The BLOB byte[] buffer to =
be filled by GetBytes.
long retval; // The bytes returned from =
GetBytes.
long startIndex =3D 0; // The starting position in =
the BLOB output.
try
{
while ( aReader.Read() )=20
{
aRecipeArray =3D new object[ RecipeColCount ];
aReader.GetValues( aRecipeArray );
fs =3D new FileStream( RecipeWorkStreamPath, FileMode.OpenOrCreate, =
FileAccess.Write);
bw =3D new BinaryWriter( fs );
// Reset the starting byte for the new BLOB.
startIndex =3D 0;
// Read the bytes into outbyte[] and retain the number of bytes =
returned.
// exception here
retval =3D aReader.GetBytes( 1, startIndex, outbyte, 0, bufferSize);
Exception Code:
"System.InvalidCastException: Specified cast is not valid.\r\n =20
at FirebirdSql.Data.Firebird.FbDataReader.GetBytes(Int32 i, Int64 =
dataIndex, Byte[] buffer, Int32 bufferIndex, Int32 length)\r\n at =
DbUtility.DBUtilityForm.LoadFileStream(FbDataReader aReader, Object[]& =
aRecipeArray)
in d:\\dbutility\\form1.cs:line 637"
|
211 messages has been excluded from this view by a project administrator.
