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-02-18 12:40:45
|
Hello: > I would like to know, how optimize "Select". > > Example, if I have 10000 lines, "Select *" in Datagrid uses 30 second. > > Is there a way faster to do it? Alan McDonald and Alessandro Petrelli has give yes a ( or the ;) ) solution, as an addition if you are using version 1.0 of the provider you can try it with the 1.5 version that has some performance improvements. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: JS.staff <jsp...@ec...> - 2004-02-18 12:15:42
|
Hi all, I'm experimenting with the .NET provider for Firebird (provider 1.5 RC5) and MS VS 2003 (Windows 2000, FB 1.5 RC7). I can fill a dataset, and update/insert manually using FbCommands, but am having problems with FbDataAdapter. When I do a .Fill(x,y) I get the following exception: "NullReferenceException: object not set to an instance of an object" Both Update and Insert command objects are specified. Any ideas? Thanks, John |
|
From: Alessandro P. <pet...@in...> - 2004-02-18 12:04:37
|
""Paola"" <pa...@sa...> ha scritto nel messaggio news:104...@ne...... > This is a multi-part message in MIME format. > > ------=_NextPart_000_0000_01C3F617.5C5AA170 > Content-Type: text/plain; > charset="us-ascii" > Content-Transfer-Encoding: 7bit > > Hi all! > > Sorry my English, I'm Italian > > I would like to know, how optimize "Select". > > Example, if I have 10000 lines, "Select *" in Datagrid uses 30 second. > > Is there a way faster to do it? Paola, you need to limit your query by using "SELECT FIRST n SKIP j * FROM MYTABLE", where n is the number of record you want to select and j is the number of record you want to skip. Ciao, Alessandro Petrelli. |
|
From: Alan M. <al...@me...> - 2004-02-18 11:42:29
|
Yes, Use a WHERE clause to limit the query Alan -----Original Message----- From: fir...@li... [mailto:fir...@li...]On Behalf Of Paola Sent: Wednesday, February 18, 2004 10:04 PM To: fir...@li... Subject: [Firebird-net-provider] select quick Hi all! Sorry my English, I'm Italian I would like to know, how optimize "Select". Example, if I have 10000 lines, "Select *" in Datagrid uses 30 second. Is there a way faster to do it? Thanks. Hi. |
|
From: Paola <pa...@sa...> - 2004-02-18 11:09:23
|
Hi all! Sorry my English, I'm Italian I would like to know, how optimize "Select". Example, if I have 10000 lines, "Select *" in Datagrid uses 30 second. Is there a way faster to do it? Thanks. Hi. |
|
From: lams_yi <la...@ho...> - 2004-02-18 09:37:50
|
Thank you for your quick reply, Carlos. But I test the sqlCommand, it looks like it don't have this problem. Here is the code: string conString ="server=(local);Integrated Security=true;database=Northwind"; string sql = "update employees set PhotoPath = 'ta...@ho...' where EmployeeId = 9"; //memSQL.Text; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = sql; con.Open(); cmd.ExecuteNonQuery(); con.Close(); The Employees.PhotoPath can update to 'ta...@ho...' correctly. Because I am using Object-Mapping class to map my object to create the query on runtime. So parameterized query is not a good solution for me :-( > ----- Original Message ----- > From: "Carlos Guzmán Álvarez" <car...@te...> > To: "tao lin" <la...@ho...> > Cc: <fir...@li...> > Sent: Wednesday, February 18, 2004 12:02 PM > Subject: Re: [Firebird-net-provider] Does Fb .net provider support IB open > source 6.0.20? > > > > Hello: > > > > > Do I miss something or FbCommand can not handle well with the '@' > > > <mailto:'@'>? > > > > This is a problem with the named paraters support, you can solve it > > using parametrized querys. > > > > > > > > > > -- > > Best regards > > > > Carlos Guzmán Álvarez > > Vigo-Spain > > > > > > ------------------------------------------------------- > > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > > Build and deploy apps & Web services for Linux with > > a free DVD software kit from IBM. Click Now! > > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > |
|
From:
<car...@te...> - 2004-02-17 23:07:03
|
Hello: > Do I miss something or FbCommand can not handle well with the '@' > <mailto:'@'>? This is a problem with the named paraters support, you can solve it using parametrized querys. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: tao l. <la...@ho...> - 2004-02-17 22:37:04
|
Hi, all I am using WinXP, VS2003, Fb.net 1.5 RC5 and Interbase 6.0.2.0 open = source edition. I found the FbCommand.ExecuteNonQuery() can not handle the email type = string. Here is a simple example base on Employee.gdb string sql =3D "update customer set ADDRESS_LINE2 =3D 'bi...@xt...' = where CUST_NO =3D 1001"; FbCommand myCommand =3D new FbCommand(sql, fbConnection1); fbConnection1.Open(); myCommand.ExecuteNonQuery(); fbConnection1.Close(); When I view the result from IBConsole, the ADDRESS_LINE2 become = 'bill?.com'. But if I put one space behide the @, like "update customer = set ADDRESS_LINE2 =3D 'bill@ xtra.com' where CUST_NO =3D 1001", it get = the correct result.=20 Do I miss something or FbCommand can not handle well with the '@'? Regards, Tao |
|
From:
<car...@te...> - 2004-02-17 15:36:00
|
Hello: Sorry for the delay > I get this error: "no permission for read-write access to database > c:\db\myDB.GDB" If i'm not wrong the mebedded server needs exclusive access to the database, are you sure the database is not in use by other firebird instance ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Thomas <ja...@ma...> - 2004-02-16 20:49:11
|
Hi. I am trying to get access to a embedded Firebird database using Firebird .NET provider 1.6. Using ASP.NET & IIS 5. But when I make this call: myConnection.Open(); I get this error: "no permission for read-write access to database c:\db\myDB.GDB" codesnip: .... private FbConnection myConnection; private string myConnectionString = ""; ...... myConnectionString ="Database=C:\db\myDB.GDB;User="*****";Password="*****";Dialect=1;Charset=NO NE;Server=localhost; Pooling=true; Connection Lifetime=60; ServerType=1;" ...... myConnection = new FbConnection(myConnectionString); ......... myConnection.Open(); (The c:\db folder is shared for web and access is given to the ASP.NET user) Any help? Regards Thomas |
|
From:
<car...@te...> - 2004-02-15 20:32:19
|
Hello: > if the page size refers to how data is stored > in the base, Correct > and packet size at what size it transits on the wire ? Correct -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Pierre A. <pie...@op...> - 2004-02-15 16:53:29
|
Hello Carlos,
I updated my code to use the new version of CreateDatabase in 1.5 RC5,
which takes a hashtable as its only parameter. I compared the parameters
with the one passed in the connection string.
I wonder if CreateDatabase "PageSize" is the same as the connection
string "Packet Size", or if the page size refers to how data is stored
in the base, and packet size at what size it transits on the wire ?
Can you shed some light on this matter ?
Kind regards.
Pierre
|
|
From: Fredrick <ma...@t-...> - 2004-02-15 03:40:07
|
<img src="cid:5C0D994C.E8585111.660C9351.D13CA3F4_csseditor"> |
|
From:
<car...@te...> - 2004-02-14 09:43:31
|
Hello:
Firebird .NET Data Provider 1.5 Release Candidate 5 available for download.
Release Changes:
- Bug fixes.
---------------------------------------------------
You can read the Changelog at:
https://sourceforge.net/project/shownotes.php?release_id=216995
You can download binarys for .NET 1.0 at:
http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC5-NET1.0.exe?download
You can download binarys for .NET 1.1 at:
http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC5-NET1.1.exe?download
You can download sources at:
http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC5-Src.zip?download
You can download documentation at:
http://prdownloads.sourceforge.net/firebird/FirebirdNETProvider1.5-RC5-Doc.zip?download
CVS Tag: NP_1_5_RC5
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
|
|
From:
<car...@te...> - 2004-02-14 09:13:56
|
Hello: > Huummm good point :) i will try to do a test and i will comment the > result. It seems to be working for me, i'm going to release the RC5 with te control done by trying to connect to the database. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-02-13 10:18:18
|
Hello: As i have a fix in my local tree for fix a problem in the named parameters support reported by Zsombor Cserna, i'm going to release a new RC this weekend, if all goes well during the next week, i will do the release of the 1.5 final next weekend. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-02-13 09:03:47
|
Hello: > I got an error message when running the Csharp example > ConnectionPooling.cs. > The error occured when the program was trying to > open the connections. The error said "Invalid PInvoke > metadata format". > Does anybody have any suggestion? Huummm waht version of the .net framework are you using and what version of the Firebird .NET Data Provider ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Doanh P. <do...@ya...> - 2004-02-13 03:53:18
|
Hi: I got an error message when running the Csharp example ConnectionPooling.cs. The error occured when the program was trying to open the connections. The error said "Invalid PInvoke metadata format". Does anybody have any suggestion? Thanks, Doanh Pham __________________________________ Do you Yahoo!? Yahoo! Finance: Get your refund fast by filing online. http://taxes.yahoo.com/filing.html |
|
From:
<car...@te...> - 2004-02-12 23:08:44
|
Hello: I'm thinking on remove the actual implementation the Firebird Events from 1.6 sources. This is the only thing that i'm sure it's not working properly at this moment ( even in 1.5 ), and i want to remove the code until i got time for doing a complete rewrite but i want to know opinions before do it :) -- BEst regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Carlos G.A. <car...@te...> - 2004-02-12 14:59:03
|
Hello: > And what if the db has been shutdown due to maintenance? ;-) Huummm good point :) i will try to do a test and i will comment the result. > I can't see your message.... Maybe it's going to reach the list with delay, if tomorrow it's not in the list i will try to resend it. -- Best regards Carlos Guzm=C3=A1n =C3=81lvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2004-02-12 13:30:11
|
"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio news:402...@te...... > I have an initial implementation for this in my local tree (for both 1.5 > and 1.6), it will be possible to tell if you want to overwrite an > existing database using a Overwrite value in the hashtable, the > CreateDatabase method will try to connect to the database if no > overwrite is allowed and throw an exception if the connection was succeful. And what if the db has been shutdown due to maintenance? ;-) > In any case i will wait for a response to my message to firebird-devel > before commit it. I can't see your message.... Ciao, Alessandro Petrelli. |
|
From:
<car...@te...> - 2004-02-12 12:50:25
|
Hello: > I agree with you but a client check would not prevent malicious attack and > this issue is falling right into this. I have an initial implementation for this in my local tree (for both 1.5 and 1.6), it will be possible to tell if you want to overwrite an existing database using a Overwrite value in the hashtable, the CreateDatabase method will try to connect to the database if no overwrite is allowed and throw an exception if the connection was succeful. In any case i will wait for a response to my message to firebird-devel before commit it. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From:
<car...@te...> - 2004-02-12 10:05:54
|
Hello: > I agree with you but a client check would not prevent malicious attack and > this issue is falling right into this. I Agree :) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
|
From: Alessandro P. <pet...@in...> - 2004-02-12 09:47:07
|
"Carlos Guzmán Álvarez" <car...@te...> ha scritto nel messaggio news:402...@te...... Carlos, > > This is very very dangerous! Is it a bug in the provider or in the FB > > engine? > > Huuummm just my opinion but database creation has a "restricted" use in > applications and we can check for database existance trying to connect > to it, for example. I agree with you but a client check would not prevent malicious attack and this issue is falling right into this. I'll follow the thread you started in the other list. Thank you! Ciao, Alessandro Petrelli. |
|
From: Alan M. <al...@me...> - 2004-02-12 09:46:12
|
> In admin tools you have a check box to overwrite the existing database, > which it will if there is no lock on the file being overwritten, otherwise > an exception will be raised as it will now tieh the provider but since the > other admin tools offer this as a switch, perhaps the switch needs to be > offered in the provider too? > Alan > > or maybe I'm thinking of restore Alan |
211 messages has been excluded from this view by a project administrator.
