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
|
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1
|
2
|
3
(7) |
4
(8) |
5
(15) |
6
(1) |
7
(5) |
8
|
9
(6) |
10
(3) |
11
(4) |
12
(16) |
13
(3) |
14
(5) |
15
(11) |
16
(1) |
17
|
18
|
19
(1) |
20
(8) |
21
(9) |
22
|
23
(5) |
24
|
25
(3) |
26
(5) |
27
(5) |
28
|
29
(1) |
30
(8) |
|
|
|
|
|
From: <ait...@gm...> - 2003-06-30 18:27:20
|
Thank you, I'll try it. -----Mensaje original----- De: fir...@li... [mailto:fir...@li...] En nombre de Carlos Guzman Alvarez Enviado el: lunes, 30 de junio de 2003 10:11 Para: Aitor G=F3mez Gonz=E1lez CC: Fir...@li... Asunto: Re: [Firebird-net-provider] Overwrite database in use Hello: > Thanks, I know that. May be I didn't explain well enough my question. >=20 > I have one and only one live connection. If I close this unique > connection (myConnection.Close()) I should be able to delete the=20 > database file in use (myDatabase.fdb), but this works only when=20 > connection pooling is disabled. Should I understand connection (my=20 > unique connection) is not really closed when I call=20 > "myConnection.Close()" and connection pooling is enabled? Using Connection Pooling the onnection is not closed until the pool=20 performs a cleanup yo can try to add a Thread.Sleep to=20 DoRestoreDatabaseBackup(); or try to change the "Connection lifetime"=20 value in Connection String --=20 Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Carlos G. A. <car...@te...> - 2003-06-30 08:12:07
|
Hello: > Thanks for the feedback. Asp.net is enough new technology for me right > now. After much thought, I decided to upgrade production box to > Firebird anyway, and now my site is up and running. Great !! I think it's the best option because Interbase 4.0 is an old product :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Carlos G. A. <car...@te...> - 2003-06-30 08:11:11
|
Hello: > Thanks, I know that. May be I didn't explain well enough my question. > > I have one and only one live connection. If I close this unique > connection (myConnection.Close()) I should be able to delete the > database file in use (myDatabase.fdb), but this works only when > connection pooling is disabled. Should I understand connection (my > unique connection) is not really closed when I call > "myConnection.Close()" and connection pooling is enabled? Using Connection Pooling the onnection is not closed until the pool performs a cleanup yo can try to add a Thread.Sleep to DoRestoreDatabaseBackup(); or try to change the "Connection lifetime" value in Connection String -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Alan M. <al...@me...> - 2003-06-30 01:37:18
|
It may not be in conformance but maybe there should be a parameter in= the connection string to force a single connection even when the pooling = on the driver is set to ON. I would never have thought to or wanted to do a restore via the old O= DBC connection setup and I suppose the .NET driver has some left over log= ic assocated with this kind of connection Alan > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf= Of > Alan McDonald > Sent: Monday, 30 June 2003 11:23 AM > To: Aitor G=F3mez Gonz=E1lez; Fir...@li...urcefor= ge.net > Subject: RE: [Firebird-net-provider] Overwrite database in use > > > Sorry if I misunderstood.. > I imagine that with connection pooling turned on, then there are ot= her > connections made by the driver at the time you make your single > connection. > With connection pooling turned on, there is also the timeout to > consider on > connection made, not used and expired... > > Alan > > > -----Original Message----- > > From: Aitor G=F3mez Gonz=E1lez [mailto:ait...@gm...] > > Sent: Monday, 30 June 2003 9:13 AM > > To: 'Alan McDonald' > > Subject: RE: [Firebird-net-provider] Overwrite database in use > > > > > > Hi Alan, > > > > Thanks, I know that. May be I didn't explain well enough my ques= tion. > > > > I have one and only one live connection. If I close this unique > > connection (myConnection.Close()) I should be able to delete the > > database file in use (myDatabase.fdb), but this works only when > > connection pooling is disabled. Should I understand connection (= my > > unique connection) is not really closed when I call > > "myConnection.Close()" and connection pooling is enabled? > > > > > > Regards, > > Aitor. > > > > > > -----Mensaje original----- > > De: Alan McDonald [mailto:al...@me...] > > Enviado el: lunes, 30 de junio de 2003 0:30 > > Para: Aitor G=F3mez Gonz=E1lez > > Asunto: RE: [Firebird-net-provider] Overwrite database in use > > > > > > you can't do a restore with more than one live connection. It's t= here to > > protect the database since a second connection means someone else= is > > currently using the DB. You can backup with many connections but > > restoring is an amdin function carried out with only one connecti= on. > > Alan > > > > > -----Original Message----- > > > From: fir...@li... > > > [mailto:fir...@li...]On Be= half Of > > > > > Aitor G=F3mez Gonz=E1lez > > > Sent: Monday, 30 June 2003 7:29 AM > > > To: Fir...@li... > > > Subject: [Firebird-net-provider] Overwrite database in use > > > > > > > > > Hi, > > > > > > I'm trying to overwrite database in use for a "Restore database > > > backup" feature in a program, using "gbak -RESTORE_DATABASE" co= mmand. > > > > > My code is something like this: > > > > > > > > > myConnection.Close(); > > > DoRestoreDatabaseBackup(); > > > myConnection.Open(); > > > > > > > > > It works perfect with ConnectionPooling =3D false, but almost n= ever when > > > > > ConnectionPooling =3D true, even if "myConnection" is the only > > > connection opened across the application. It's not a problem f= or me > > > by now, I only need a connection, I'll work without ConnectionP= ooling, > > > > > but I'd like to know how could I do it in case of working with = more > > > than one connection. > > > > > > > > > Thanks in advance, > > > Aitor. > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email sponsored by: Free pre-built ASP.NET sites in= cluding > > > > > Data Reports, E-commerce, Portals, and Forums are available now= . > > > Download today and enter to win an XBOX or Visual Studio .NET. > > > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061= 203_01/ > > > 01 > > > _______________________________________________ > > > Firebird-net-provider mailing list > > > Fir...@li... > > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provi= der > > > > > > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites includ= ing > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_= 01/01 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Alan M. <al...@me...> - 2003-06-30 01:22:09
|
Sorry if I misunderstood.. I imagine that with connection pooling turned on, then there are other connections made by the driver at the time you make your single connection. With connection pooling turned on, there is also the timeout to consider on connection made, not used and expired... Alan > -----Original Message----- > From: Aitor Gómez González [mailto:ait...@gm...] > Sent: Monday, 30 June 2003 9:13 AM > To: 'Alan McDonald' > Subject: RE: [Firebird-net-provider] Overwrite database in use > > > Hi Alan, > > Thanks, I know that. May be I didn't explain well enough my question. > > I have one and only one live connection. If I close this unique > connection (myConnection.Close()) I should be able to delete the > database file in use (myDatabase.fdb), but this works only when > connection pooling is disabled. Should I understand connection (my > unique connection) is not really closed when I call > "myConnection.Close()" and connection pooling is enabled? > > > Regards, > Aitor. > > > -----Mensaje original----- > De: Alan McDonald [mailto:al...@me...] > Enviado el: lunes, 30 de junio de 2003 0:30 > Para: Aitor Gómez González > Asunto: RE: [Firebird-net-provider] Overwrite database in use > > > you can't do a restore with more than one live connection. It's there to > protect the database since a second connection means someone else is > currently using the DB. You can backup with many connections but > restoring is an amdin function carried out with only one connection. > Alan > > > -----Original Message----- > > From: fir...@li... > > [mailto:fir...@li...]On Behalf Of > > > Aitor Gómez González > > Sent: Monday, 30 June 2003 7:29 AM > > To: Fir...@li... > > Subject: [Firebird-net-provider] Overwrite database in use > > > > > > Hi, > > > > I'm trying to overwrite database in use for a "Restore database > > backup" feature in a program, using "gbak -RESTORE_DATABASE" command. > > > My code is something like this: > > > > > > myConnection.Close(); > > DoRestoreDatabaseBackup(); > > myConnection.Open(); > > > > > > It works perfect with ConnectionPooling = false, but almost never when > > > ConnectionPooling = true, even if "myConnection" is the only > > connection opened across the application. It's not a problem for me > > by now, I only need a connection, I'll work without ConnectionPooling, > > > but I'd like to know how could I do it in case of working with more > > than one connection. > > > > > > Thanks in advance, > > Aitor. > > > > > > > > ------------------------------------------------------- > > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > > > Data Reports, E-commerce, Portals, and Forums are available now. > > Download today and enter to win an XBOX or Visual Studio .NET. > > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ > > 01 > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > |
From: Alan M. <al...@me...> - 2003-06-30 01:21:45
|
you can't do a restore with more than one live connection. It's there to protect the database since a second connection means someone else is currently using the DB. You can backup with many connections but restoring is an amdin function carried out with only one connection. Alan > > > -----Original Message----- > > From: fir...@li... > > [mailto:fir...@li...]On Beha= lf Of > > Aitor G=F3mez Gonz=E1lez > > Sent: Monday, 30 June 2003 7:29 AM > > To: Fir...@li... > > Subject: [Firebird-net-provider] Overwrite database in use > > > > > > Hi, > > > > I'm trying to overwrite database in use for a "Restore database b= ackup" > > feature in a program, using "gbak -RESTORE_DATABASE" command. My= code > > is something like this: > > > > > > myConnection.Close(); > > DoRestoreDatabaseBackup(); > > myConnection.Open(); > > > > > > It works perfect with ConnectionPooling =3D false, but almost nev= er when > > ConnectionPooling =3D true, even if "myConnection" is the only co= nnection > > opened across the application. It's not a problem for me by now,= I only > > need a connection, I'll work without ConnectionPooling, but I'd l= ike to > > know how could I do it in case of working with more than one conn= ection. > > > > > > Thanks in advance, > > Aitor. > > > > > > > > ------------------------------------------------------- > > This SF.Net email sponsored by: Free pre-built ASP.NET sites incl= uding > > Data Reports, E-commerce, Portals, and Forums are available now. > > Download today and enter to win an XBOX or Visual Studio .NET. > > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_06120= 3_01/01 > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provide= r |
From: <ait...@gm...> - 2003-06-30 00:16:19
|
Hi Alan, Thanks, I know that. May be I didn't explain well enough my question. I have one and only one live connection. If I close this unique connection (myConnection.Close()) I should be able to delete the database file in use (myDatabase.fdb), but this works only when connection pooling is disabled. Should I understand connection (my unique connection) is not really closed when I call "myConnection.Close()" and connection pooling is enabled? Regards, Aitor. -----Mensaje original----- De: Alan McDonald [mailto:al...@me...]=20 Enviado el: lunes, 30 de junio de 2003 0:30 Para: Aitor G=F3mez Gonz=E1lez Asunto: RE: [Firebird-net-provider] Overwrite database in use you can't do a restore with more than one live connection. It's there to protect the database since a second connection means someone else is currently using the DB. You can backup with many connections but restoring is an amdin function carried out with only one connection. Alan > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf Of > Aitor G=F3mez Gonz=E1lez > Sent: Monday, 30 June 2003 7:29 AM > To: Fir...@li... > Subject: [Firebird-net-provider] Overwrite database in use > > > Hi, > > I'm trying to overwrite database in use for a "Restore database > backup" feature in a program, using "gbak -RESTORE_DATABASE" command. > My code is something like this: > > > myConnection.Close(); > DoRestoreDatabaseBackup(); > myConnection.Open(); > > > It works perfect with ConnectionPooling =3D false, but almost never = when > ConnectionPooling =3D true, even if "myConnection" is the only=20 > connection opened across the application. It's not a problem for me=20 > by now, I only need a connection, I'll work without ConnectionPooling, > but I'd like to know how could I do it in case of working with more=20 > than one connection. > > > Thanks in advance, > Aitor. > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now.=20 > Download today and enter to win an XBOX or Visual Studio .NET.=20 > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/ > 01 > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From: Andrew G. <And...@Bu...> - 2003-06-30 00:01:48
|
Carlos Guzm=E1n =C1lvarez wrote on Fri 6/27/2003 10:11 AM > Hello: >> Does firebird-net-provider work with IB 4.0? If not, any suggestions >> what I might try to connect to the db via asp.net? Unfortunately, >> upgrading from IB 4.0 is not an option. > Huumm at this moment no for connection to the firebird server the=20 > provider is sending PROTOCOL_VERSION10 as protocol version i can suggest=20 > you to modify this by the protocol version used by Interbase 4, in=20 > GDS.CS line 2150, recompile the provider sources ( using NAnt=20 > nant.sourceforge.net) and try it, with your app or using the NUnit test=20 > suite, and if you can please comment here the results of your test :). Thanks for the feedback. Asp.net is enough new technology for me right now. After much thought, I decided to upgrade production box to Firebird anyway, and now my site is up and running. =20 Andy |
From: <ait...@gm...> - 2003-06-29 21:32:25
|
Hi, I'm trying to overwrite database in use for a "Restore database backup" feature in a program, using "gbak -RESTORE_DATABASE" command. My code is something like this: myConnection.Close(); DoRestoreDatabaseBackup(); myConnection.Open(); It works perfect with ConnectionPooling = false, but almost never when ConnectionPooling = true, even if "myConnection" is the only connection opened across the application. It's not a problem for me by now, I only need a connection, I'll work without ConnectionPooling, but I'd like to know how could I do it in case of working with more than one connection. Thanks in advance, Aitor. |
From: Carlos G. A. <car...@te...> - 2003-06-27 14:10:40
|
Hello: > Does firebird-net-provider work with IB 4.0? If not, any suggestions > what I might try to connect to the db via asp.net? Unfortunately, > upgrading from IB 4.0 is not an option. Huumm at this moment no for connection to the firebird server the provider is sending PROTOCOL_VERSION10 as protocol version i can suggest you to modify this by the protocol version used by Interbase 4, in GDS.CS line 2150, recompile the provider sources ( using NAnt nant.sourceforge.net) and try it, with your app or using the NUnit test suite, and if you can please comment here the results of your test :). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Andrew G. <And...@Bu...> - 2003-06-27 12:54:47
|
Hi, My development machine is Win XP, Firebird 1.03, .net 1.1, FBNetProv 1.1. The production box is Win 2k Server, Interbase 4.0 (sic), .net 1.1, FBNetProv 1.1. The ASP.NET project works great on the development box. But when I try to run it on production (IB 4.0), I get GDSException: Exception of type FirebirdSql.Data.INGDS.GDSException was thrown ... FbException: connection rejected by remote interface trying to open an FbConnection. The connect string is public connStr As String = "User=xxx; Password=xxx;" & _ "Database=C:\\db\\xxx.gdb;" & _ "Server=localhost;Port=3050;Dialect=1;Charset=NONE;Role=;Connection" & _ "lifetime=15;Pooling=true;Packet Size=8192" I can connect to IB 4.0 db's via ISAPI DLL's using http on the same web site. Does firebird-net-provider work with IB 4.0? If not, any suggestions what I might try to connect to the db via asp.net? Unfortunately, upgrading from IB 4.0 is not an option. Thanks, Andy |
From: Carlos G. A. <car...@te...> - 2003-06-27 11:28:20
|
Hello: > Can I use the provider on Pocket Windows (using the .NET compact framework)? As i know there are people using it with the .NET Compact Framework and VS 2003, but personally i have no tested it because i don't have the VS 2003, if you want, try it and tell us the problems you have using it with on a Pocket :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Karsten S. <st...@ai...> - 2003-06-27 10:11:17
|
Can I use the provider on Pocket Windows (using the .NET compact framework)? Thanks Karsten |
From: Karsten S. <st...@ai...> - 2003-06-27 10:10:58
|
Can I use the provider on Pocket Windows (using the .NET compact framework)? Thanks Karsten |
From: Alan M. <al...@me...> - 2003-06-26 21:59:29
|
Why is it at freshmeat? Is it no longer going to be at sourceforge? Alan > -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf= Of > Carlos Guzman Alvarez > Sent: Friday, 27 June 2003 4:17 AM > To: Firebird .Net Provider > Subject: [Firebird-net-provider] [ANN] Firebird .NET Data Provider > Announced in FreshMeat > > > Hello: > > The last release of the .NET Data Provider was announced at FreshMe= at > you can see it here (thanks to Marius Popa Adrian for his feedback)= : > > > http://freshmeat.net/projects/firebird.netdataprovider/?topic_id= =3D66 > > > > > > > -- > Best regards > > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: INetU > Attention Web Developers & Consultants: Become An INetU Hosting Par= tner. > Refer Dedicated Servers. We Manage Them. You Get 10% Monthly Commis= sion! > INetU Dedicated Managed Hosting http://www.inetu.net/partner/index.= php > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From: Carlos G. A. <car...@te...> - 2003-06-26 21:53:04
|
Hello: > Why is it at freshmeat? Is it no longer going to be at sourceforge? It's and will be at sourceforge, at freshmeat will be only a new place for announces of new releases ( if you see the annopunce at fresmeat has links to sourceforge :D ). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Carlos G. A. <car...@te...> - 2003-06-26 18:17:25
|
Hello: The last release of the .NET Data Provider was announced at FreshMeat you can see it here (thanks to Marius Popa Adrian for his feedback): http://freshmeat.net/projects/firebird.netdataprovider/?topic_id=66 -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <CAR...@te...> - 2003-06-26 10:53:17
|
Hello=3A =3E I can=27t post the exact code (non-disclosure contracts =3E prevent me)=2C but here=27s the =22psuedo-code=22 example =3E (unchecked=2C so I don=27t even know if this actually =3E compiles) of what=27s happening=3A No problem=2C with the sample code you have sent is more than needed =3A)= =3E Once I get the datatable (similar to your C=23 example)=2C =3E I have this=3A =3E = =3E for (short c=3D0=3Bc=3Cc=5Fcount=3Bc++) =3E =7B =3E DataColumn * col =3D columns-=3Eget=5FItem( c )=3B =3E Object *o =3D row-=3Eget=5FItem( col )=3B =3E = =3E switch( Type=3A=3AGetTypeCode( o-=3EGetType() ) ) =3E =7B =3E =2E=2E=2E// enumerating the various typecodes from =3E TypeCode=3A=3ADecimal=2C etc=2E (they all work as expected) =3E = =3E =2E=2E// for the =22DataType=22 column=2C this case fires=2E=2E=2E =3E = =3E case TypeCode=3A=3AObject=3A =3E =7B Type *t =3D o-=3EGetType()=3B =3E n =3D Type=3A=3AGetTypeCode(t)=3B =3E // n is always 1 =3E =7D =3E break=3B Huummm i can=27t test it now ( i will try it later today )=2C but in firs= t = place think in that DataType column already has a Type value ( = System=2EString=2C System=2EArray=2C System=2EInt32=2C etc=2E=2E=2E) -- Best regards Carlos Guzm=E1n =C1lvarez Vigo-Spain |
From: Jason V. <jas...@ya...> - 2003-06-26 04:18:41
|
From your previous answer, which now that I look at it I should have been able to find myself, using the FbType enumeration corrects the problem for me. However, I'm writing in C++, using the interop services within a single managed C++ module (the rest of the application is unmanaged), so the behavior could be different because of this. I can't post the exact code (non-disclosure contracts prevent me), but here's the "psuedo-code" example (unchecked, so I don't even know if this actually compiles) of what's happening: Once I get the datatable (similar to your C# example), I have this: for (short c=0;c<c_count;c++) { DataColumn * col = columns->get_Item( c ); Object *o = row->get_Item( col ); switch( Type::GetTypeCode( o->GetType() ) ) { ...// enumerating the various typecodes from TypeCode::Decimal, etc. (they all work as expected) ..// for the "DataType" column, this case fires... case TypeCode::Object: { Type *t = o->GetType(); n = Type::GetTypeCode(t); // n is always 1 } break; } In this example, what I get is an "Object", from which I get a type, and then a typecode. I'm not sure why - it's the only field that does this (the ProviderType gives me a number, as expected), and I've not yet checked the MsSQL2000 version (I'm doing both side by side) to see if it does the same thing - I think it does (which would suggest the problem isn't your provider). __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com |
From: Carlos G. A. <car...@te...> - 2003-06-25 15:30:36
|
Hello: > Indeed, it appears to provide "Object" which is then > used to get a "Type" and from that I call > "GetTypeCode" = always returns 1 on the sample > databases that come with Firebird (Employee.gdb). I'm making a test and all seems to work as expected, can you tell me if this is a correct test case: FbConnection connection = new FbConnection(connectionString); connection.Open(); FbTransaction transaction = connection.BeginTransaction(); FbCommand command = new FbCommand("Select * from test_table_01", connection, transaction); FbDataReader reader = command.ExecuteReader(CommandBehavior.KeyInfo|CommandBehavior.SchemaOnly); DataTable schema = reader.GetSchemaTable(); foreach (DataRow row in schema.Rows) { foreach (DataColumn column in schema.Columns) { Console.WriteLine("{0} = {1}", column.ColumnName, row[column.Ordinal]); } } connection.Close(); In my test: "DataType" column has the correct System type. "ProviderType" column has the correct FbType value. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Carlos G. A. <car...@te...> - 2003-06-25 11:06:05
|
Hello: > DataType seems to be 1 in all cases, I will try to see this later today. > What table of types should I be using? Try using FbType -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Jason V. <jas...@ya...> - 2003-06-25 09:34:37
|
When I perform the "ExecuteReader" with behavior options set to "SchemaOnly | KeyInfo", I get a DataTable that lists all the columns resulting for a query, but I can't make sense out of the "DataType" and "ProviderType" entries. DataType seems to be 1 in all cases, whereas I get various values for "ProviderType" - but that doesn't seem to correctly match values from the DbType or TypeCode enumerations. What table of types should I be using? __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com |
From: Carlos G. A. <car...@te...> - 2003-06-23 18:13:31
|
Hello: > You have to register the project on the fresmeat (first create a user for that) > and after they aproove it you can announce the new releases I'm registered yet i will submit the project info later today, thanks very much :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Carlos G. A. <car...@te...> - 2003-06-23 18:06:07
|
Hello: > You have to register the project on the fresmeat (first create a user for that) > and after they aproove it you can announce the new releases Ok , thanks very much. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Marius P. A. <ma...@re...> - 2003-06-23 17:56:30
|
You have to register the project on the fresmeat (first create a user for = that) and after they aproove it you can announce the new releases =20 On Mon, 23 Jun 2003 19:30:57 +0200 Carlos Guzman Alvarez <car...@te...> wrote: > Hello: >=20 > > do you have a freshmeat project where to put the news ?=20 > > it could be nice to have a page there :)=20 >=20 > There are any special to do for announce the new version of Firebird=20 > .NET Data provider ( 1.1 Alpha 2 ) at freshmeat ?? :D >=20 >=20 >=20 > Thanks in advance >=20 >=20 >=20 > --=20 > Best regards >=20 > Carlos Guzm=E1n =C1lvarez > Vigo-Spain |