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-05-18 17:00:43
|
Hello: >Bingo! >I believe that the problem is this same one... seen I not to have made any >alteration and I am using the port standard 3050. >Which alteration do I need to do to alter the port of Firebird? >How should the record be in the file SERVICES? > Review the "TCP Protocol Settings" section of the firebird.conf file, change the RemoteServicePort configuration (and remove the #), and try again. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro F. <ale...@ho...> - 2004-05-18 16:55:41
|
Dear Carlos, Bingo! I believe that the problem is this same one... seen I not to have made any alteration and I am using the port standard 3050. Which alteration do I need to do to alter the port of Firebird? How should the record be in the file SERVICES? Thanks! []s, Alessandro Ferreira "Carlos Guzmán Álvarez" <car...@te...> wrote in message news:c8daq0$gap$1...@ne...... > Hello: > > >The path is correct... I wandered in the moment of typing in this email. > >For tests, I copied the bank for a remote server where I have only the > >Firebird 1.5 installed... and accessing the bank in this server worked > >correctly. > > That is what i was thinking, but it's not bad to ask it in any case :) > > >However, in the machine where I have IB 7.1 and i FB1.5 turning > >simultâneamente, it happens him referred problem. > > > >Would you have some suggestion? > > Are both running at the same time, in that case in which port are > listening each one and what port are you using in the connection string ?? > > > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > ------------------------------------------------------- > This SF.Net email is sponsored by: SourceForge.net Broadband > Sign-up now for SourceForge Broadband and get the fastest > 6.0/768 connection for only $19.95/mo for the first 3 months! > http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From: <car...@te...> - 2004-05-18 16:10:02
|
Hello: >The path is correct... I wandered in the moment of typing in this email. >For tests, I copied the bank for a remote server where I have only the >Firebird 1.5 installed... and accessing the bank in this server worked >correctly. That is what i was thinking, but it's not bad to ask it in any case :) >However, in the machine where I have IB 7.1 and i FB1.5 turning >simultâneamente, it happens him referred problem. > >Would you have some suggestion? Are both running at the same time, in that case in which port are listening each one and what port are you using in the connection string ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro F. <ale...@ho...> - 2004-05-18 15:58:49
|
Dear Carlos, The path is correct... I wandered in the moment of typing in this email. For tests, I copied the bank for a remote server where I have only the Firebird 1.5 installed... and accessing the bank in this server worked correctly. However, in the machine where I have IB 7.1 and i FB1.5 turning simultâneamente, it happens him referred problem. Would you have some suggestion? Thanks, []s, Alessandro Ferreira. "Carlos Guzmán Álvarez" <car...@te...> wrote in message news:40A...@te...... > Hello: > > >Exception Details: FirebirdSql.Data.Firebird.FbException: file > >D:CadFirebird15\CADFB15.FDB is not a valid database > > > The database path is incorrect it should be: > > D:\CadFirebird15\CADFB15.FDB > > > In any case, are you sure that the database is being created through > firebird and not interbase ?? > > > > -- > best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > ------------------------------------------------------- > This SF.Net email is sponsored by: SourceForge.net Broadband > Sign-up now for SourceForge Broadband and get the fastest > 6.0/768 connection for only $19.95/mo for the first 3 months! > http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
|
From:
<car...@te...> - 2004-05-18 14:44:16
|
Hello: >I made the test using database to explorer that it comes with the Borland >Delphi 8 net, and I also made the configurations that come in the >BdpReadMe.txt archive to create borland data provider. Uh .... =-O .... you are testing the BDP ;) Sorry i haven't readed the BDP word in the Subject ;) Huuummmm that was working for me ... but the Bdp is under heavy development, in any case will be better for you to grab a copy of the latest CVS sources (I'm now testing it with an NUnit test suite), when you have done the check out of the sources ?? (i have done a little test with the Database Explorer and seems to be working for me, at least, for show tables and normal indexes, views and stored procedures) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-18 14:32:40
|
Hello: > I create a new ASP.NET application, I place a SQLconnection1 on a form. Huumm SQLConnection1 ?? If want to use the Firebird provider you will need to add the assembly components to the Delphi 8 toolbox (rigth click on the Toolbox add see if there are an option for add enw components). The FbConnection component has a designer for the Connection string. A sample connection string would be anything like this (Review the help of FbConnection.Connection string for see a complete list of allowed options): string connectionString = "DataSource=localhost;Database=mydatabase.fdb;User=SYSDBA;Password=masterkey"; or string connectionString = "Database=localhost/3050:mydatabase.fdb;User=SYSDBA;Password=masterkey"; -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-18 14:28:26
|
Hello: > It is possibile to use the more simple and direct <PROCEDURENAME> > without parameter list invocation? it cause me to write much more > redundant code (i have the data adapter construction in a xml file) Yes it's possible, you will need to set the command as an StoredProcedure (CommandType.StoredProcedure), and depending on what are you doing, you will need to use FbCommandBuilder.DeriveParameters. -- best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Dario C. A. S. <da...@al...> - 2004-05-18 14:18:43
|
With Provider version 1.5 (stable) the only way (or, more precisely, the raccomended way as i have seen) to call a stored procedure via Command is something like this: EXECUTE PROCEDURE DUMMY(<parameters>) It is possibile to use the more simple and direct <PROCEDURENAME> without parameter list invocation? it cause me to write much more redundant code (i have the data adapter construction in a xml file) best regards Dario Cecere - Albion Srl Mobile 32x38xxxxx (ask) - ICQ 11151997 da...@al... ALBION S.r.l. - www.albionweb.net |
|
From: Raigo <ra...@so...> - 2004-05-18 14:04:01
|
Environment is: Windows XP Pro, .NET1.1, Delphi 8 SP 2, Firebird 1.0.3, Firebird .Net Data Provider Version 1.6 Beta 3. How is the connection to FB made? I have read I must create a connection string, but how or what should it look like? I create a new ASP.NET application, I place a SQLconnection1 on a form. There is a ConnectionString property. What exaxtly should be written there? or is it like with ODBC that I must create data source first? Where should SQLconnection and SQLcommands placed? on Form or is there something like was Data Module in earlier Delphi versions? |
|
From: <pi...@lo...> - 2004-05-18 13:57:07
|
I made the test using database to explorer that it comes with the Borland Delphi 8 net, and I also made the configurations that come in the BdpReadMe.txt archive to create borland data provider. Claudio > Hello: > > > I am having a problem in netprovider16 BDP all time that I try to sho= w > > the data of a table this appearing this OBJECT message \"referencia > > NAO DEFINED FOR a INSTANCIA OF an OBJECT \ "what this making a mistak= e? > > Can you send a test case ?? > > > > > > > -- > Best regards > > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > |
|
From:
<car...@te...> - 2004-05-18 13:41:26
|
Hello: >I'm unable to see these components in the toolbox. I referenced >FirebirdSql.Data.Firebird in my solution. >Do I have to do something particular to install these components. > You need to configure it in the Toolbox, just make right click on the the toolbox it should have a menu option for add components to the toolbox (You will need to select the FirebirdSq.Data.Firebird.dll assembly). -- best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-18 13:33:43
|
Hello: >Exception Details: FirebirdSql.Data.Firebird.FbException: file >D:CadFirebird15\CADFB15.FDB is not a valid database > The database path is incorrect it should be: D:\CadFirebird15\CADFB15.FDB In any case, are you sure that the database is being created through firebird and not interbase ?? -- best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro F. <ale...@ho...> - 2004-05-18 13:24:15
|
Dears, I have Interbase 7.1 and Firebird 1.5 installed in my computer. I use the tool IBExpert Personal to make maintenance in my databases... because in this tool I can choose referring DLL Client that I am working, GDS32 (IB7) or FBCLIENT (FB1.5). I created a database Firebird 1.5, however, when I try to open this database using a FbConnection (1.6 Beta) I receive the error message: Exception Details: FirebirdSql.Data.Firebird.FbException: file D:CadFirebird15\CADFB15.FDB is not a valid database How do I solve this problem? Thanks, []s, Alessandro Ferreira |
|
From: Julien F. <jfk...@ne...> - 2004-05-18 13:11:30
|
On Tue, 18 May 2004 07:21:55 +0000 (UTC), Carlos Guzmán Álvarez wrote: > Hello: > >>OK >> >>So do have to do EVERYTHING by code or is there a way to use components >>like Delphi's TDataSet ? >> > The design time support in the provider is limited to FbConnection and > FbCommand > components. > I'm unable to see these components in the toolbox. I referenced FirebirdSql.Data.Firebird in my solution. Do I have to do something particular to install these components. Delphi looks simpler than VS.NEt .... but that's because I'm a newbie, I hope :) TIA Julien |
|
From:
<car...@te...> - 2004-05-18 12:06:21
|
Hello: > I am having a problem in netprovider16 BDP all time that I try to show > the data of a table this appearing this OBJECT message \"referencia > NAO DEFINED FOR a INSTANCIA OF an OBJECT \ "what this making a mistake? Can you send a test case ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: <pi...@lo...> - 2004-05-18 11:40:22
|
I am having a problem in netprovider16 BDP all time that I try to show = the data of a table this appearing this OBJECT message \"referencia NAO = DEFINED FOR a INSTANCIA OF an OBJECT \ "what this making a mistake? Claudio pi...@lo... |
|
From:
<car...@te...> - 2004-05-18 10:23:52
|
Hello: >Just tested and seen no differences, except for the pooled connection that >is served fast if I make subsequent opening. > That means that it's slow :) ?? in that case maybe we can use Nprof for try to see where is the bottleneck: http://sourceforge.net/projects/nprof/ -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2004-05-18 10:14:11
|
"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio news:40A...@te...... > Hello: > > > ok .... Huummm .... if you make a test using a Console > > App it takes too much time on connect too ?? > > If you can, please :), test with and without pooiling enabled > (if the problem gives wen the pooiling is enabled i will review the > connection pool implementation, at least, in 1.6 sources) Just tested and seen no differences, except for the pooled connection that is served fast if I make subsequent opening. Ciao, Alessandro Petrelli. |
|
From:
<car...@te...> - 2004-05-18 10:06:08
|
Hello: > ok .... Huummm .... if you make a test using a Console > App it takes too much time on connect too ?? If you can, please :), test with and without pooling enabled (if the problem gives wen the pooiling is enabled i will review the connection pool implementation, at least, in 1.6 sources) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-18 10:05:57
|
Hello: > ok .... Huummm .... if you make a test using a Console > App it takes too much time on connect too ?? If you can, please :), test with and without pooiling enabled (if the problem gives wen the pooiling is enabled i will review the connection pool implementation, at least, in 1.6 sources) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-05-18 09:56:54
|
Hello: >In the same machine (the web server box). > ok .... Huummm .... if you make a test using a Console App it takes too much time on connect too ?? (One uestion your app uses more than one thread ??) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2004-05-18 09:47:15
|
"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio news:40A...@te...... > Using 1.5 or 1.6 version of the provider ?? And of Firebird, are you Both version. > using Super Server or > Classic Server ?? (Classic should be better for the Dual machine if i' > not wrong). Classic Server on a Linux Dual Xeon Box. > >Other softwares, for example IBExpert, works as expected in both machines. > > > Working with it in the Xeon machine or connection from another one ?? In the same machine (the web server box). Ciao, Alessandro Petrelli. |
|
From:
<car...@te...> - 2004-05-18 09:18:42
|
Hello: >we've moved one web application from a single PIII machine to a Dual Xeon (4 >processors) server. >After some days spent on debugging we found out that connecting to the db >server always requires 4.5 seconds instead of a few milliseconds required by >the PIII machine. > Huummm .... that is too much time, of course. >Also some random lock-ups have been verified when connection pooling removes >unused connection. Disabling it solved the lock-ups but the situation is the >same (the application is quite unusable). > Using 1.5 or 1.6 version of the provider ?? And of Firebird, are you using Super Server or Classic Server ?? (Classic should be better for the Dual machine if i' not wrong). >Other softwares, for example IBExpert, works as expected in both machines. > Working with it in the Xeon machine or connection from another one ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2004-05-18 09:08:23
|
Hola Carlos, we've moved one web application from a single PIII machine to a Dual Xeon (4 processors) server. After some days spent on debugging we found out that connecting to the db server always requires 4.5 seconds instead of a few milliseconds required by the PIII machine. Also some random lock-ups have been verified when connection pooling removes unused connection. Disabling it solved the lock-ups but the situation is the same (the application is quite unusable). Other softwares, for example IBExpert, works as expected in both machines. If it can help the number of users is about 120, doing at least 200.000 and more transactions per day. I have access to this server for a few days more, so if you have an idea, or want ot make some tests, let me know. Meanwhile I'll continue investigating.... Thanks. Ciao, Alessandro Petrelli. |
|
From:
<car...@te...> - 2004-05-18 07:49:16
|
Hello: >OK > >So do have to do EVERYTHING by code or is there a way to use components >like Delphi's TDataSet ? > The design time support in the provider is limited to FbConnection and FbCommand components. >Where can I find a good tutorial for ADO.Net (or, even better, for Firebird >with ADO.Net) ? > Review the .NET Framework docs. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
211 messages has been excluded from this view by a project administrator.
