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:
<car...@te...> - 2004-04-22 10:44:37
|
Hello: The Firebird ADO.NET 1.6 Beta 2 is available for download. Beta 2 ( 2004-04-22 ) ---- - - ---- -- -- - (Please review the changelog for details) - Bug fixes. - Some bug fixes for the new connection pooling implementation. - Fixed numeric and decimal data types handling. - Improved CommandBuilder implementation. - Some improvements and bug fixes in the database schema stuff. - Initial implementation of the input parameters descriptor generator without making calls, when possible, to the server for describe the input parameters. You can read the Changelog here: http://sourceforge.net/project/shownotes.php?release_id=232994 You can download the sources here: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Beta2-Src.zip?download You can download the documentation here: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Beta2-Doc.zip?download You can download the .NET 1.1 installation here: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Beta2-NET1.1.exe?download You can download the .NET 1.0 installation here: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.6-Beta2-NET1.0.exe?download -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Mike S. <mi...@mi...> - 2004-04-22 09:36:12
|
Hi Michael Transform your input data into fixed width format then open it in Firebird as an external file and do a select from it into your Firebird table. Search the Interbase 6.0 docs for "external file" but specifically see the Interbase Data Definition Guide, page 107. Cheers, Mike. Michael She wrote: > Hi all, > > This is somewhat off topic, but has anyone found a way to bulk load > 55,000 > rows into Firebird quickly? > > I'm currently doing it via a dataadapter.update with a custom > InsertCommand, > but it's taking almost 20 minutes. > > So, in short... what's the easiest way to load 55,000 rows into Firebird. > Each row is only about <300 bytes. > > My table has 8 columns w/ 1 auto number column, and no indexes. > > Thanks! |
|
From:
<car...@te...> - 2004-04-22 08:59:16
|
Hello: > This is somewhat off topic, but has anyone found a way to bulk load > 55,000 > rows into Firebird quickly? > > I'm currently doing it via a dataadapter.update with a custom > InsertCommand, > but it's taking almost 20 minutes. > > So, in short... what's the easiest way to load 55,000 rows into Firebird. > Each row is only about <300 bytes. Huummm have you tested it with prepared statements ?? Can you post a snippet of the code you are using ?? Are you using 1.5 or 1.6 version ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Dmitry A. <fd...@ua...> - 2004-04-22 08:20:46
|
Hello Michael,
Thursday, April 22, 2004, 5:25:29 AM, you wrote:
MS> This is somewhat off topic, but has anyone found a way to bulk load 55,000
MS> rows into Firebird quickly?
MS> I'm currently doing it via a dataadapter.update with a custom InsertCommand,
MS> but it's taking almost 20 minutes.
MS> So, in short... what's the easiest way to load 55,000 rows into Firebird.
MS> Each row is only about <300 bytes.
MS> My table has 8 columns w/ 1 auto number column, and no indexes.
Any way if you want maximal performance in firebird - you must
execute inserts in one transaction per 200-500-1000 records, no
more.
--
Best regards,
Dmitry mailto:fd...@ua...
|
|
From: Michael S. <ms...@ro...> - 2004-04-22 02:26:39
|
Hi all, This is somewhat off topic, but has anyone found a way to bulk load 55,000 rows into Firebird quickly? I'm currently doing it via a dataadapter.update with a custom InsertCommand, but it's taking almost 20 minutes. So, in short... what's the easiest way to load 55,000 rows into Firebird. Each row is only about <300 bytes. My table has 8 columns w/ 1 auto number column, and no indexes. Thanks! -- Michael She : mic...@bi... Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ |
|
From:
<car...@te...> - 2004-04-21 21:43:50
|
Hello: > Backup works fine if I use this path: c:\121212\myDB.gdb > > But if I use this path: C:\C:\12 12 12 - 12\myDB.gdb Do you mean: C:\12 12 12 - 12\myDB.gdb ?? The backup works using gbak.exe ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: bertherngreen <ber...@us...> - 2004-04-21 20:47:20
|
Hello,
Does anyone know if (and how) it is possible to list all database names on a
server with the FBServerProperties.DatabasesInfo property?
Like
srv.Connect(this.cboServers.SelectedItem.ToString(),this.txtUser.Text,this.t
xtPassword.Text);
foreach(SQLDMO.Database db in srv.Databases)
{
if(db.Name!=null)
this.cboDatabase.Items.Add(db.Name);
with SQLDMO
Bert
|
|
From: Thomas <ja...@ma...> - 2004-04-21 13:28:09
|
Using v. 1.5.1541.23864. Backup works fine if I use this path: c:\121212\myDB.gdb But if I use this path: C:\C:\12 12 12 - 12\myDB.gdb I get this error: No message for code 401 found.\nNo message for code = 384 found.\nNo message for code 386 found.\n" An if I use this path: "C:\C:\12 12 12 - 12\myDB.gdb" (incl. the " sign) I get this error:"No message for code 24 found.\nNo message for code 414 = found.\n" Has anyone tested this? Regards Thomas |
|
From: benny <be...@ch...> - 2004-04-21 09:49:30
|
Carlos wrote:- > I have tested 1.6 CVS sources using a SELECT FIRST 1 ... query and works > nice for , what problem do > you have with 1.6 Beta 1 ?? > > Hi, My problem is I din have any row result on my datagrid using a SELECT FIRST 1 ... query on 1.6 Beta 1 .. any mistake I might have made? Last time I heard u are going to release new version on Firebird.net data provider, but since you haven't released perhaps u could send me the dll CVS built version for me to tried? TIA regards, benny ;) |
|
From:
<car...@te...> - 2004-04-21 09:34:33
|
Hello: > Iam totally with this .net stuff. While Iam not new to firebird, I am > trying to learn C# to develop a web application. I want to develop a > web database aplication using Firebird. Is the Firebird .Net provider > a component which is to be install in Visual C# so that I can connect > to the database Yes. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-04-21 08:55:29
|
Hello: > I am using firebird.net data provider 1.6 Beta, I could load the > data to datagrid using sql: select * from tableA where it show more > than one row in the datagrid. But, currently I want to have result of > one row using select first 1 * from tableA where this is a valid sql > statement while trying on Firebird1.5 final release... > What I had miss out? Or what other ways I could reach my purpose > by having first row on my datagrid? I have tested 1.6 CVS sources using a SELECT FIRST 1 ... query and works nice for , what problem do you have with 1.6 Beta 1 ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: benny <be...@ch...> - 2004-04-21 05:55:32
|
Hi, I am using firebird.net data provider 1.6 Beta, I could load the data = to datagrid using sql: select * from tableA where it show more than one = row in the datagrid. But, currently I want to have result of one row = using select first 1 * from tableA where this is a valid sql statement = while trying on Firebird1.5 final release... What I had miss out? Or what other ways I could reach my purpose by = having first row on my datagrid? my code was=20 .... FbDAdOrder.SelectCommand :=3D FbCommOrder; FbDAdOrder.Fill(dsOrder, 'TempInfo'); DataGrid.DataSource :=3D dsOrder.Tables['TempInfo']; DataGrid.DataBind; where FbDAdOrder is FbAdapter and FbCommOrder is FbCommand .. TIA=20 regards, benny :) |
|
From: James <jam...@tr...> - 2004-04-21 02:48:09
|
Good day. Iam totally with this .net stuff. While Iam not new to firebird, I am trying to learn C# to develop a web application. I want to develop a web database aplication using Firebird. Is the Firebird .Net provider a component which is to be install in Visual C# so that I can connect to the database and work just like Delphi is to Visual C# and IB Object is to Firebird .Net Provider? If Iam mistaken can anybody give a notes on this thing? Thanks a lot. regards, james |
|
From:
<car...@te...> - 2004-04-20 14:08:46
|
Hello: >When I set on pooling, I can't close connection. > Can you make a test with latest CVS version ?? I can send to you a new assembly if you want (only tell to me if it's for .NET 1.0 or 1.1) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Dmitry A. <fd...@ua...> - 2004-04-20 11:30:08
|
Hello work,
Tuesday, April 20, 2004, 2:11:35 PM, you wrote:
w> For example (it's real code):
w> private string sСonnectionString =
^ - this is russian letter С ;)
w> The error message is: "Object reference not set to an instance of an
w> object".
Hummm... you have CVS access? Can you try latest cvs version?
Because it's code works fine at me...
--
Best regards,
Dmitry mailto:fd...@ua...
|
|
From: work <she...@fo...> - 2004-04-20 11:11:55
|
Hello!
When I set on pooling, I can't close connection.
For example (it's real code):
private string sСonnectionString =
"User=sysdba;"+
"Password=masterkey;" +
"Database=testbase;" +
"DataSource=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=WIN1251;" +
"Connection lifetime=15;" +
"Pooling=true;" + // !!!!!!!!!!!!!!!!!
"Packet Size=8192";
public short MayWork(string sUniqKey)
{
short stResult=0;
FbConnection Connect=new FbConnection(sСonnectionString);
try
{
Connect.Open();
try
{
FbTransaction Transact=Connect.BeginTransaction(FbTransactionOptions.Read|FbTransactionOptions.NoWait|FbTransactionOptions.ReadCommitted|FbTransactionOptions.RecVersion);
try
{
FbCommand Command=new FbCommand();
Command.Connection=Connect;
Command.Transaction=Transact;
Command.CommandType=CommandType.StoredProcedure;
Command.CommandText="MayWorkForos4User";
Command.Parameters.Add("@CUNIQKEY",FbDbType.Char,32).Value=sUniqKey;
Command.Parameters.Add("@IRESULT",FbDbType.SmallInt);
Command.Parameters[1].Direction=ParameterDirection.ReturnValue;
Command.ExecuteNonQuery();
stResult=Convert.ToInt16(Command.Parameters[1].Value);
Transact.Commit();
Command.Dispose();
}
catch(Exception ex)
{
stResult=2;
Transact.Rollback();
}
}
finally
{
Connect.Close(); // ERROR!!!!!!!!!!!!!!!!!!!!!!!!
Connect.Dispose();
}
}
catch(Exception e)
{
stResult=2;
}
return stResult;
}
The error message is: "Object reference not set to an instance of an
object".
Best regards, Alex Shevelev mailto:she...@fo...
|
|
From: Sharan B. <jwe...@co...> - 2004-04-19 18:34:03
|
sofa laborious defective nonunion merbromine proteales boisterous spitefully toothlike cellulite candor damsel innovative shar frosted decuple adhere preachment farce excited dacron supplement house saxe tightness coffer vanished riprap untraced longways deficient |
|
From:
<car...@te...> - 2004-04-19 08:59:49
|
Hello: > I would like to connect to the embedded database and create a new DB > without > specifying the name before hand. You can't, if you want to create a database you can use FbConnection.CreateDatabase method -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Michael S. <ms...@ro...> - 2004-04-19 00:18:13
|
Hello, I just started to use the Embedded Firebird Server with a VB.NET project. Is it possible to connect to an embedded server without specifying the startup database name? My current connect string is: Database=EMPLOYEE.FDB;User=SYSDBA;Password=masterkey;Dialect=3;ServerType=1; Without Database=EMPLOYEE.FDB I get an error saying that it is an invalid connection string. I would like to connect to the embedded database and create a new DB without specifying the name before hand. Thanks. -- Michael She : mic...@bi... Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ |
|
From: JS.staff <jsp...@ec...> - 2004-04-17 15:23:13
|
WWVzLCBJIGFtIHVzaW5nIDEuNSB3aXRoIGV4cGxpY2l0IHRyYW5zYWN0aW9ucy4gSSdsbCB0cnkg aW4gb24gMS42IGFzIHNvb24gYXMgSSBjYW4gKHdoZW4gSSBnZXQgYWNjZXNzIHRvIHRoZSBtdWx0 aS1wcm9jZXNzb3IgUEMgbmV4dCB3ZWVrKS4NCiANClRoYW5rcywNCiANCkpvaG4NCg0KCS0tLS0t T3JpZ2luYWwgTWVzc2FnZS0tLS0tIA0KCUZyb206IENhcmxvcyBHdXptw6FuIMOBbHZhcmV6IFtt YWlsdG86Y2FybG9zZ2FAdGVsZWZvbmljYS5uZXRdIA0KCVNlbnQ6IFNhdCAxNy8wNC8yMDA0IDE0 OjU2IA0KCVRvOiBKUy5zdGFmZiANCglDYzogDQoJU3ViamVjdDogUmU6IFtGaXJlYmlyZC1uZXQt cHJvdmlkZXJdIHRocmVhZGRpbmcgcXVlc3Rpb25bU2Nhbm5lZF0NCgkNCgkNCg0KCUhlbGxvOg0K CQ0KCT5TaG91bGQgSSBoYXZlIHRvIGRvIHRoaXM/IG1heWJlIHRoZSBwYXJlbnQgdGhyZWFkIGlz IGRvaW5nIHNvbWV0aGluZyB0byBGYkNvbW1hbmQgb2JqZWN0IHdoZW4gdGhlIHBhcmVudCB0cmFu c2FjdGlvbiBpcyBjb21taXR0ZWQsIHdoaWNoIGlzIHNjcmV3aW5nIHVwIHRoZSBvcGVyYXRpb24g b2Y6DQoJPg0KCT5jb21tYW5kLlRyYW5zYWN0aW9uID0gbXlzZWNvbmR0cmFuczsNCgk+DQoJPmlu IHRoZSBjaGlsZCB0aHJlYWQ/Pz8NCgk+DQoJDQoJQXJlIHlvdSB1c2luZyAxLjUgYW5kIGV4cGxp Y2l0IHRyYW5zYWN0aW9ucyA/PyBhbSBpIHJpZ2h0ID8/IGlmIHllcyBjYW4NCgl5b3UgZ2l2ZSBh IHRyeSB0byB0aGlzIHdpdGggMS42ID8/DQoJDQoJDQoJDQoJDQoJDQoJLS0NCgliZXN0IHJlZ2Fy ZHMNCgkNCglDYXJsb3MgR3V6bcOhbiDDgWx2YXJleg0KCVZpZ28tU3BhaW4NCgkNCg0K |
|
From: Dmitry A. <fd...@ua...> - 2004-04-16 16:49:57
|
Hello Carlos, Friday, April 16, 2004, 7:43:39 PM, you wrote: CGÁ> I'm thinking on create a FAQ for the provider, what questions do CGÁ> you think that will be useful to add to it ?? In my practic provider works like SqlClient provider and 90% all questions - it's standard ADO.NET. Questions must be... huuummmm... about non-standard features, for what this implemented and why :) hummmm.... and may be some specific problems. All others questions -- it's commonly ADO... but samples (with realization of usable things -- it's will be good) :) hmmm... -- Best regards, Dmitry mailto:fd...@ua... |
|
From:
<car...@te...> - 2004-04-16 16:48:15
|
Hello: > Thanks for your answer. I started with Visual Studio, but now I >switched to SharpDevelop, the free IDE. > > You will need to a reference to the provder assembly and add to teh source files: using FirebirdSql.Data.Firebird; You can add the provider components to the SharpDevelop toolbox too -- Best regards Carlos Guzmán Álvarez vigo-Spain |
|
From:
<car...@te...> - 2004-04-16 16:44:05
|
Hello: I'm thinking on create a FAQ for the provider, what questions do you think that will be useful to add to it ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-04-16 14:56:28
|
Hello: >In the parent thread, before starting the child thread. > >Should I have to do this? maybe the parent thread is doing something to FbCommand object when the parent transaction is committed, which is screwing up the operation of: > >command.Transaction = mysecondtrans; > >in the child thread??? > > Hummm with waht version of the .NET provider ?? are you using implicit or implicit transactions ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-04-16 14:56:28
|
Hello: >In the parent thread, before starting the child thread. > >Should I have to do this? maybe the parent thread is doing something to FbCommand object when the parent transaction is committed, which is screwing up the operation of: > >command.Transaction = mysecondtrans; > >in the child thread??? > > Hummm with what version of the .NET provider ?? are you using implicit or implicit transactions ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
211 messages has been excluded from this view by a project administrator.
