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...> - 2003-11-07 19:57:35
|
Hello:
> when i try open a table with 5.000 records the operation is slower
> than for OBDC,DataSnap,IbExpert,Delphi,IbX....
With the sample database you have sent to my private email and the
latest sources from CVS it takes 3-4 seconds, including the connection,
probably you are adding to the result the time that the .NET runtime
gets on startup.
Here is my sample code:
DateTime start = DateTime.Now;
FbConnection connection = new FbConnection(connectionString);
connection.Open();
FbCommand select = new FbCommand("select * from FUT_T01", connection);
FbDataReader reader = select.ExecuteReader();
while (reader.Read())
{
}
reader.Close();
connection.Close();
Console.WriteLine(DateTime.Now - start);
Console.Read();
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2003-11-07 17:00:11
|
Hello: > when i try open a table with 5.000 records the operation is slower > than for OBDC,DataSnap,IbExpert,Delphi,IbX.... > > .Net Provider B3 = 15 Secs > Others = 2 or 3 Secs Can you send the test case you have used ?? > PD : Sorry for bad english ? No problem i have very bad english too :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: IngSoft (Yahoo) <loi...@ya...> - 2003-11-07 16:43:14
|
Hi, when i try open a table with 5.000 records the operation is slower than for OBDC,DataSnap,IbExpert,Delphi,IbX.... .Net Provider B3 = 15 Secs Others = 2 or 3 Secs Why this diference ? Armando Arias PD : Sorry for bad english ? |
|
From:
<car...@te...> - 2003-11-04 10:25:37
|
Hello:
> I'm getting this error:
> when I'm trying to run this code: FbCommand is currently busy Open,
> Fetching.
>
> cnn.Open();
> FbTransaction trans = cnn.BeginTransaction();
> cmd = new FbCommand("SELECT USER_PASSWORD FROM USERS WHERE USER_NAME='" +
> uid + "'",cnn,trans);
> dr = cmd.ExecuteReader();
> trans.Commit();
> cnn.Close();
>
> Anybody got an idea what i'm doing wrong?
This exception gives when you try to use the FbTransaction class and the
connection
has an open DataReader, try this:
cnn.Open();
FbTransaction trans = cnn.BeginTransaction();
cmd = new FbCommand("SELECT USER_PASSWORD FROM USERS WHERE USER_NAME='" +
uid + "'",cnn,trans);
dr = cmd.ExecuteReader();
dr.Close(); <--------------------
trans.Commit();
cnn.Close();
--
Best regards
Carlos Guzmán álvarez
Vigo-Spain
|
|
From: Tom F. <tom...@gr...> - 2003-11-04 10:15:05
|
Hi,
I'm getting this error:
when I'm trying to run this code: FbCommand is currently busy Open,
Fetching.
cnn.Open();
FbTransaction trans = cnn.BeginTransaction();
cmd = new FbCommand("SELECT USER_PASSWORD FROM USERS WHERE USER_NAME='" +
uid + "'",cnn,trans);
dr = cmd.ExecuteReader();
trans.Commit();
cnn.Close();
Anybody got an idea what i'm doing wrong?
thx,
tom
|
|
From:
<car...@te...> - 2003-10-31 15:09:35
|
Hello: > Ok, I will send it today (code or where can I sennd an attachment?) You can send it to my private email, or to the list if it's little test case -- Best regards Carlos Guzmán Álvarez Vuigo-Spain |
|
From: Mirek S. <m.s...@tr...> - 2003-10-31 15:07:02
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html;charset=3DISO-88= 59-2"> <title></title> </head> <body text=3D"#000000" bgcolor=3D"#ffffff"> <meta content=3D"text/html;charset=3DISO-8859-1" http-equiv=3D"Content-Ty= pe"> <title></title> Hi,<br> I'm starting work with Firebird .NET provider in Visual Studio .NET.<br> I analyzed sample sources atached to Firebird.NET package, but maybe someone has simple example solution in Visual Studio .NET.<br> Which contain one dbgrid and has insert, update and delete capabilities. <br> <br> If someone can share with his source, I will be very=A0 thankful.<br> You can mailto my email box.<br> <br> Thanks in advance Mirek<br> <br> </body> </html> |
|
From: nicoya n. <nic...@ho...> - 2003-10-31 14:18:57
|
> >Hello: > > > Thats it, I add my fbcommands to a hastable but when I unboxing object > > --> fbcommand somethisg happen but the command dont works this time. > > >Can you send a test case ?? > > Ok, I will send it today (code or where can I sennd an attachment?) _________________________________________________________________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/ |
|
From:
<car...@te...> - 2003-10-30 17:46:18
|
Hello: > Thats it, I add my fbcommands to a hastable but when I unboxing object > --> fbcommand somethisg happen but the command dont works this time. Can you send a test case ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: nicoya n. <nic...@ho...> - 2003-10-30 16:30:56
|
Thats it, I add my fbcommands to a hastable but when I unboxing object --> fbcommand somethisg happen but the command dont works this time. Thank you! Luis Ruiz _________________________________________________________________ ¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/ |
|
From: Derek E. <de...@sp...> - 2003-10-28 21:07:28
|
Really strange, but it is working today.
Thanks for your help
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...] On Behalf Of
Carlos Guzm=E1n =C1lvarez
Sent: Tuesday, 28 October 2003 11:15 p.m.
To: Derek Ekins
Cc: fir...@li...
Hello:
It's working for me (.net 1.0).
A more correct version :
CREATE PROCEDURE SELECT_DATA
RETURNS (
INT_FIELD INTEGER,
VARCHAR_FIELD VARCHAR(100),
DECIMAL_FIELD DECIMAL(15,2))
AS
begin
FOR SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM=20
TEST_TABLE_01 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD
DO
SUSPEND;
end
This is bad:
Console.WriteLine("(0) {1}", reader.GetValue(0), =
reader.GetValue(1));
needs to be:
Console.WriteLine("{0} {1}", reader.GetValue(0), =
reader.GetValue(1));
--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain
-------------------------------------------------------
This SF.net email is sponsored by: The SF.net Donation Program.
Do you like what SourceForge.net is doing for the Open
Source Community? Make a contribution, and help us add new
features and functionality. Click here: http://sourceforge.net/donate/
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
|
|
From:
<car...@te...> - 2003-10-28 10:19:57
|
Hello:
It's working for me (.net 1.0).
A more correct version :
CREATE PROCEDURE SELECT_DATA
RETURNS (
INT_FIELD INTEGER,
VARCHAR_FIELD VARCHAR(100),
DECIMAL_FIELD DECIMAL(15,2))
AS
begin
FOR SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM
TEST_TABLE_01 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD
DO
SUSPEND;
end
This is bad:
Console.WriteLine("(0) {1}", reader.GetValue(0), reader.GetValue(1));
needs to be:
Console.WriteLine("{0} {1}", reader.GetValue(0), reader.GetValue(1));
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Derek E. <de...@sp...> - 2003-10-28 10:08:36
|
Yup that=92s it.
-----Original Message-----
From: Carlos Guzm=E1n =C1lvarez [mailto:car...@te...]=20
Sent: Tuesday, 28 October 2003 10:54 p.m.
To: Derek Ekins
Cc: fir...@li...
Hello:
> 1.1
> Don't have the exact code handy at the moment (its at work).
> However here is what it does. Declared two output parameters (id - =
integer
> and name - char(100)) and does the select id, name from test into :id, =
> :name
> I am not even sure if my proc is using the correct syntax as it seems=20
> a very
> strange way of doing things.
Looks like this ??
CREATE PROCEDURE SELECT_DATA
RETURNS (
INT_FIELD INTEGER,
VARCHAR_FIELD VARCHAR(100),
DECIMAL_FIELD DECIMAL(15,2))
AS
begin
SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM TEST_TABLE_01 =20
WHERE INT_FIELD =3D 2 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD;
suspend;
end
--
Best regards
Carlos Guzm=E1n =C1lvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2003-10-28 09:55:13
|
Hello:
> 1.1
> Don't have the exact code handy at the moment (its at work).
> However here is what it does. Declared two output parameters (id - integer
> and name - char(100)) and does the select id, name from test into :id,
> :name
> I am not even sure if my proc is using the correct syntax as it seems
> a very
> strange way of doing things.
Looks like this ??
CREATE PROCEDURE SELECT_DATA
RETURNS (
INT_FIELD INTEGER,
VARCHAR_FIELD VARCHAR(100),
DECIMAL_FIELD DECIMAL(15,2))
AS
begin
SELECT INT_FIELD, VARCHAR_FIELD, DECIMAL_FIELD FROM TEST_TABLE_01
WHERE INT_FIELD = 2 INTO :INT_FIELD, :VARCHAR_FIELD, :DECIMAL_FIELD;
suspend;
end
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From: Derek E. <de...@sp...> - 2003-10-28 09:36:24
|
1.1 Don't have the exact code handy at the moment (its at work). However here is what it does. Declared two output parameters (id - = integer and name - char(100)) and does the select id, name from test into :id, = :name I am not even sure if my proc is using the correct syntax as it seems a = very strange way of doing things. Thanks -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of Carlos Guzm=E1n =C1lvarez Sent: Tuesday, 28 October 2003 9:34 p.m. To: Derek Ekins Cc: fir...@li... Hello: > > Am I doing something wrong, or is this a bug?? > I am using Firebird 1.5.0 (Win32) and Dot Net Provider Beta 3 Seems to be correct, are you using .net 1.0 or 1.1 ?? can you send the sp code ?? -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- This SF.net email is sponsored by: The SF.net Donation Program. Do you like what SourceForge.net is doing for the Open Source Community? Make a contribution, and help us add new features and functionality. Click here: http://sourceforge.net/donate/ _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
|
From:
<car...@te...> - 2003-10-28 08:34:36
|
Hello: > > Am I doing something wrong, or is this a bug?? > I am using Firebird 1.5.0 (Win32) and Dot Net Provider Beta 3 Seems to be correct, are you using .net 1.0 or 1.1 ?? can you send the sp code ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Derek E. <de...@sp...> - 2003-10-27 23:20:56
|
After executing ExecuteReader on a command object I am trying to loop =
over
the results and write them to the Console.
However when I execute reader.Read() the program gives no response and
basically hangs.
=20
Here is the code that I am using (the sproc is just a select statement
returning two columns)
=20
FbConnection conn =3D new FbConnection(connstring);
FbCommand cmd =3D new FbCommand( "GetResults", conn );
cmd.CommandType =3D CommandType.StoredProcedure;
conn.Open();
FbDataReader reader =3D cmd.ExecuteReader();
=20
while (reader.Read())
{
Console.WriteLine("(0) {1}", reader.GetValue(0), =
reader.GetValue(1));
}
=20
Am I doing something wrong, or is this a bug??
I am using Firebird 1.5.0 (Win32) and Dot Net Provider Beta 3
=20
Thanks,
Derek
|
|
From:
<car...@te...> - 2003-10-27 21:55:39
|
Hello: Seems that things in ADO.NET are going to change a lot ;) : http://longhorn.msdn.microsoft.com/portal_nav.htm -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2003-10-27 11:53:21
|
Hello: Roadmap ------- * Next version will be Beta 4 after this release rc stage will be started, i have in mind to release at least 3 release candidates before 1.5 final release. Latest CVS changes ------------------ * There are some changes for improve performance of array datatype parameters (Thanks to Jesus for his feedback) and for allow partial updates of array datatype fields. * There are a few change on FbCommand class on blob parameters handling. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2003-10-24 13:47:26
|
Hello: > When i try to instal the FirebirdNETprovider1.5-beta3-net1.1 in > spanish i get the following message: > "no se encuentra la biblioteca de vinculos dinamicos MSVCR70.dll en la > ruta especificada > c:|docume-1\gigles-\config-1\temp\1bl4k0ff\FirebirdNETprovider1.5-beta3-net1.1 > ;.;c;\winnt\system32;c:\winnt\system;c:\winnt;c:\winnt\system32;c:\winnt;c:\winnt\system32\wbem" > (translated is that cant find dinamic link library MSVCR70.dll in the > above paths). > I have downloaded the 1.1 net framework , and i have visual basic.net > standard 2003 (but in another hard disk, i dont know if that matters) > I m quite a newbie to both firebird and .net, so im probably failing > in something very simple. I hope i had given enough info. Thx in advance. From the KNOWN.TXT file: Problem with MSVCR70.dll ------------------------ Solution from an answer of Andrew C. Goodall in the developement lis: Do a file search on the pc/server where you installed .net framework The dll is there but it's in a temp folder and needs to be copied to the main .net folder. my msvcr70.dll was in C:\WINNT\SYSTEM32\URTTemp I copied it to C:\WINNT\Microsoft.NET\Framework\v1.0.3705 Then I re-installed Firebird .NET provider and all was well in the world. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: gustavo i. <sup...@ho...> - 2003-10-24 03:36:00
|
When i try to instal the FirebirdNETprovider1.5-beta3-net1.1 in spanish = i get the following message:=20 "no se encuentra la biblioteca de vinculos dinamicos MSVCR70.dll en la = ruta especificada = c:|docume-1\gigles-\config-1\temp\1bl4k0ff\FirebirdNETprovider1.5-beta3-n= et1.1 = ;.;c;\winnt\system32;c:\winnt\system;c:\winnt;c:\winnt\system32;c:\winnt;= c:\winnt\system32\wbem" (translated is that cant find dinamic link library MSVCR70.dll in the = above paths). I have downloaded the 1.1 net framework , and i have visual basic.net = standard 2003 (but in another hard disk, i dont know if that matters) I m quite a newbie to both firebird and .net, so im probably failing in = something very simple. I hope i had given enough info. Thx in advance. |
|
From:
<car...@te...> - 2003-10-23 10:56:24
|
Hello: > Probably it's my bug, sorry :( No problem, probably was only the CVS update delay :) for pserver connections. > I download last CVS. Now it works. Great thanks!!! :) Great !! :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: olegmad <ol...@ya...> - 2003-10-23 10:19:31
|
> It's working for me, are you sure you have got the latest CVS sources ?? Probably it's my bug, sorry :( I download last CVS. Now it works. Great thanks!!! :) Bye. |
|
From:
<car...@te...> - 2003-10-21 23:43:29
|
Hello: Firebird .NET Data Provider Beta 3 available for download. You can view the complete changelog at: https://sourceforge.net/project/shownotes.php?release_id=192388 Downloads --------- You can download binarys for .NET Framework 1.0 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta3-Net1.0.exe?download You can download binarys for .NET Framework 1.1 at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta3-Net1.1.exe?download You can download sources at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta3-Src.zip?download You can download documentation at: http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-Beta3-Doc.zip?download CVS Tag: NP_15_Beta_3 -- Best regards Carlos Guzmán Álvarez Vigo-Spain P.S: I have both versions of the .net framework installed now, if you have problems with installers, please, try to build the sources or comment the problem in the developement list. |
|
From:
<car...@te...> - 2003-10-21 17:57:02
|
Hello:
> Sorry Firebird.Net Provider Beta 2 works fine on .NET Framework 1.1
> with conection and Commandbuilder.Deriveparameters. I make a litte
> VS.NET 2002 to be sure. It maybe was when I unbox from
> System.Data.IDbCommand, but I need to chek it more.
> But it still give an exception ("Index was out of range. Mus be
> non-negative and less of the soze of the collection. Parameter name:
> index" in FDA.Fill(DS) line) wen performs the followind code:
I'm testing this without problem, can you send to me the table structure ??
And one question this:
FCD.Parameters[0].Value = 1;
FCD.Parameters[2].Value = 1;
should be:
FCD.Parameters[0].Value = 1;
FCD.Parameters[1].Value = 1;
If you want you can try it with Beta 3 too.
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
211 messages has been excluded from this view by a project administrator.
