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-05 11:47:22
|
Hello: > void ClearPools() Sorry this needs to be: void ClearAllPools() -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2004-02-05 10:27:18
|
Hello: I was reading the documentation of the SqlConnection class, in the .NET Framework 1.2, and it has two new static methods: void ClearPools() void ClearPool(SqlConnection connection) As these methods are going to be needed in the Firebird .NET Data Provider i'm thinking on implement them, at least in 1.6 sources. Opinions are wellcome!! -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2004-02-05 09:04:19
|
Hello: > I couldn't find API to clean up the pool. Can u just point that out? How > can I access all the connections in the pool to figure out that they are > open? There are no way at this moment, as i tell in my prior eamil i will try to review it for 1.6 version. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <meg...@ya...> - 2004-02-05 09:01:49
|
Hello, I couldn't find API to clean up the pool. Can u just point that out? How can I access all the connections in the pool to figure out that they are open? Thanx. Mahesh. >Hello: >> Can u think of some work around I can apply in 1.5? >The only valid thing seems to be to force the cleanup of the pool and/or >allow to check if there are connections opened in the pool, as seems >that this is going to be needed i will try to see it but for 1.6 ;) >-- >Best regards >Carlos Guzmán Álvarez >Vigo-Spain --------------------------------- BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 |
From: <meg...@ya...> - 2004-02-05 02:36:46
|
Hello Carlos, This is what I've found which is one step near to the guess I'd made in my first mail, i.e., some connections are alive when I try to backup the database. My connection string for the database was like this "user=<user>;password=<password>;database=<dbfile>;datasource=localhost;port=3050;Connection lifetime=5;Pooling=true" I changed the pooling from true to false, and now the backup worked(with and without the code u'd added), even after I'd made a successful query to the database, before this backup. Then I tried a'ain with pooling as true, but make a Thread.Sleep(6000), before using FbConfiguration.DatabaseShutdown(FbShutdownMode.Forced,0) and FbConfiguration.DatabaseOnline()(as per the code in previous mail). But this time 4 out of ten times it did fine and rest gave error, the error number being 152 along with 133 and 233. Hope now u can make what all this is for. Let me know in case any other test case is required. Just to confirm, if backup/restore are called without any prior connection, none error comes. Thanx. Mahesh. Carlos_Guzmán_Álvarez <car...@te...> wrote: Hello: > Can u give me any idea, why this could be happen? Huummmm .... Can you make a little test ?? anything like this: FbBackup objFbBackup = new FbBackup(); objFbBackup.UserName = user; objFbBackup.UserPassword = password; objFbBackup.Database = dbFile; objFbBackup.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbBackup.Options = FbBackupFlags.IgnoreLimbo; objFbBackup.Verbose = true; objFbBackup.Start(); while((lineOutput = objFbBackup.GetNextLine()) != null) { // Console.WriteLine(lineOutput); } objFbBackup.Close(); FbRestore objFbRestore = new FbRestore(); objFbRestore.UserName = user; objFbRestore.UserPassword = password; objFbRestore.Database = dbFile; objFbRestore.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbRestore.PageSize= 4096; objFbRestore.Options = FbRestoreFlags.Replace; objFbRestore.Verbose = true; objFbRestore.Start(); while((lineOutput = objFbRestore.GetNextLine()) != null) { // Console.WriteLine(lineOutput); } objFbRestore.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine("Finished!!"); Console.ReadLine(); -- Best regards Carlos Guzmán Álvarez Vigo-Spain --------------------------------- BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 |
From:
<car...@te...> - 2004-02-05 02:24:41
|
Hello: > And it works fine now - no hanging :) :) > How can I check, or what is the best method to see if a record has a lock? This is a good question for firebird-support list ;) ( 1.6 version of the provider will allow to use Firebird specific transaction parameters, this iwll allow to have better control over transactions. ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Matt H. <ma...@xp...> - 2004-02-04 16:33:34
|
Some people may have VS.NET 2k3, but there's a lot that won't have that and that won't have VS.NET 2k2, either. I think the best solution would be to make the installation not depend on either file, but there may not be an easy way to do that. ---Matt -----Original Message----- From: fir...@li... [mailto:fir...@li...] On Behalf Of C. P. Choo Sent: Wednesday, February 04, 2004 12:37 AM To: fir...@li... Subject: Re: AW: [Firebird-net-provider] MSVCR70.dll II Hi Carlos, I think in the next release of Firebird.Net Provider, you may need to compile a version based on MSVCR71.DLL, since most users will install directly into VS.NET 2003, which has this file only. Regards CP "Carlos Guzm=E1n =C1lvarez" <car...@te...> wrote in message news:3FD...@te...... > Hello: > > > I had already read that. Nevertheless thanks. > > My problem however is, that I have at all no msvcr70.dll on my PC. > > I have a msvcr71.dll. So how can I do all registrations with this file? > > I don't know what can be the problem, probably that i have generated the > installation packages with both frameworks installed, try to download > the sources and build them using nant (nant.sourceforge.net) > > > > > -- > Best regards > > Carlos Guzm=E1n =C1lvarez > Vigo-Spain > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ Firebird-net-provider mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-net-provider |
From:
<car...@te...> - 2004-02-04 15:23:01
|
Hello: > Can u think of some work around I can apply in 1.5? The only valid thing seems to be to force the cleanup of the pool and/or allow to check if there are connections opened in the pool, as seems that this is going to be needed i will try to see it but for 1.6 ;) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Andrew G. <ag...@jc...> - 2004-02-04 15:08:31
|
> Why would database workbench and ibconsole run the query, but through > asp.net it hangs? Ok I asked Database Workbench support what isolation level they use, and they said: "read committed", with "no wait" for deadlocks. However I could not find this as a valid option on System.Data.Isolation http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/ frlrfsystemdataisolationlevelclasstopic.asp Readuncommited is the option that will allow dirty reads and prevent deadlocking. So I used: myTxn = myConnection.BeginTransaction(IsolationLevel.Readuncommitted) And it works fine now - no hanging :) My next question is: In my asp.net page I want to pull up a single record but want to check to see if someone else Has this record uncommited first. If I use IsolationLevel.Readcommitted the webpage will hang if the record is locked, If I use IsolationLevel.Readuncommitted the page will load but the data will be ditry. How can I check, or what is the best method to see if a record has a lock? TIA Regards, Andrew C. Goodall |
From: <meg...@ya...> - 2004-02-04 13:38:38
|
Hello: So, the bottom line is that I can't execute FbBackup and FbRestore, before waiting for 10 seconds, irrespective of whether I make a call to FbConfiguration or not. Isn't? Also, even I try to call gbak.exe from my code(I tried to do that as well) after making a query and then nullifying everything, I can't do it, as there can be some connections still alive. In my application, I do pooling=true, but the connection string doesn't changes for a session, or we can say that all the connections to the dbfile have same connection string at any particular point of time. Can u think of some work around I can apply in 1.5? Thanx. Mahesh. > > Then I tried a'ain with pooling as true, but make a Thread.Sleep(6000), >> before using FbConfiguration.DatabaseShutdown(FbShutdownMode.Forced,0) >The problem here is that 1.5 has a single pool for all connections, and >a cleanup thread that runs at every 10 seconds this will work in >different way in 1.6, that will have a single pool for each different > connection string ( and a single clean up thread based on the >connection lifetime specified in the connection string ). >-- > Best regards >Carlos Guzmán Álvarez > Vigo-Spain --------------------------------- BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 |
From:
<car...@te...> - 2004-02-04 11:58:26
|
Hello: > Then I tried a'ain with pooling as true, but make a Thread.Sleep(6000), > before using FbConfiguration.DatabaseShutdown(FbShutdownMode.Forced,0) The problem here is that 1.5 has a single pool for all connections, and a cleanup thread that runs at every 10 seconds this will work in different way in 1.6, that will have a single pool for each different connection string ( and a single clean up thread based on the connection lifetime specified in the connection string ). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2004-02-04 08:24:57
|
Hello: > The deafult in .net provider is: > "Begins a new transaction with the default isolation level > IsolationLevel.ReadCommitted." Yes, ReadCommitted is the default Isolation Level. > I don't know about the subsets you mentioned. Review the Interbase 6 API documentation for see more information about them: http://www.ibphoenix.com/downloads/60ApiGuide.zip > Do you have an example code of how to change the isolation level? The isolation level is specified in FbConnection.BeginTransaction method and can't be canged ( querys using the implicit transaction support will use ReadCommitted ) -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From:
<car...@te...> - 2004-02-04 08:19:19
|
Hello: > But suppose I execute a query at the placeholder 1 in the above code, > the error comes. I realise that there may be some connection left open, > even when I Dispose() and nullify FbConnection and FbCommand objects. I > know that only when the GC executes, will this be freed, but then what > else could be done to execute backup/restore. > At the placeholder 2 in the above code, I tried this code as well. Try using Pooling=False in the connection string, by default the connection pooling is enabled, and connections are not really closed ( using FbConnection.Dipose or FbConnection.Close ). -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: C. P. C. <cc...@bc...> - 2004-02-04 06:37:02
|
Hi Carlos, I think in the next release of Firebird.Net Provider, you may need to compile a version based on MSVCR71.DLL, since most users will install directly into VS.NET 2003, which has this file only. Regards CP "Carlos Guzmán Álvarez" <car...@te...> wrote in message news:3FD...@te...... > Hello: > > > I had already read that. Nevertheless thanks. > > My problem however is, that I have at all no msvcr70.dll on my PC. > > I have a msvcr71.dll. So how can I do all registrations with this file? > > I don't know what can be the problem, probably that i have generated the > installation packages with both frameworks installed, try to download > the sources and build them using nant (nant.sourceforge.net) > > > > > -- > Best regards > > Carlos Guzmán Álvarez > Vigo-Spain > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From: <meg...@ya...> - 2004-02-04 05:30:28
|
Hello Carlos, Thanx for ur prompt reply. I also tried this code before posting my previous mail. But this also gives me the same error. If I execute this code in a simple commandline utility, it doesn't gives me any error. Sample : class FbBackupRestore { public static vois Main(){ // 1. // 2. // 3. Yesterday's posted code, with or without the changes u've added } } But suppose I execute a query at the placeholder 1 in the above code, the error comes. I realise that there may be some connection left open, even when I Dispose() and nullify FbConnection and FbCommand objects. I know that only when the GC executes, will this be freed, but then what else could be done to execute backup/restore. At the placeholder 2 in the above code, I tried this code as well. FbConfiguration objFbConfiguration = new FbConfiguration(); objFbConfiguration.UserName = user; objFbConfiguration.UserPassword = password; objFbConfiguration.Database = dbfile; objFbConfiguration.DatabaseShutdown(FbShutdownMode.Forced,0); Thread.Sleep(2000); objFbConfiguration.DatabaseOnline(); Now the first error number changes from 190 to 31 and the remaining error numbers(i.e. : 130 & 233) remains the same, with the same messages for all of them(i.e. : 'No message found for this error number'). Is anything else required to mount and unmount the database? Waiting for reply. Thanx once a'ain, Mahesh. Carlos_Guzmán_Álvarez <car...@te...> wrote: Hello: > Can u give me any idea, why this could be happen? Huummmm .... Can you make a little test ?? anything like this: FbBackup objFbBackup = new FbBackup(); objFbBackup.UserName = user; objFbBackup.UserPassword = password; objFbBackup.Database = dbFile; objFbBackup.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbBackup.Options = FbBackupFlags.IgnoreLimbo; objFbBackup.Verbose = true; objFbBackup.Start(); while((lineOutput = objFbBackup.GetNextLine()) != null) { // Console.WriteLine(lineOutput); } objFbBackup.Close(); FbRestore objFbRestore = new FbRestore(); objFbRestore.UserName = user; objFbRestore.UserPassword = password; objFbRestore.Database = dbFile; objFbRestore.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbRestore.PageSize= 4096; objFbRestore.Options = FbRestoreFlags.Replace; objFbRestore.Verbose = true; objFbRestore.Start(); while((lineOutput = objFbRestore.GetNextLine()) != null) { // Console.WriteLine(lineOutput); } objFbRestore.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } Console.WriteLine("Finished!!"); Console.ReadLine(); -- Best regards Carlos Guzmán Álvarez Vigo-Spain --------------------------------- BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 |
From: Andrew G. <ag...@jc...> - 2004-02-03 22:24:53
|
Carlos, I'm using 1.0.1220.28609, but I also tried 1.5.1491.18298 on my test server and the samething happens. I can't be bothered to change all my Fbtype to FBdbType right now :) The deafult in .net provider is: "Begins a new transaction with the default isolation level IsolationLevel.ReadCommitted." I don't know about the subsets you mentioned. Do you have an example code of how to change the isolation level? I'm not sure I was doing it right on my testing, as it said I needed to use an integer for the isolationlevel, and I could find no doc on that. Do you know what isolation level I should use? TIA Regards, Andrew C. Goodall Regards, |
From:
<car...@te...> - 2004-02-03 22:08:20
|
Hello: > Why would database workbench and ibconsole run the query, but through > asp.net it hangs? I think this needs to be an IsolationLevel issue, in the .net provider the isolation levels are mapped as ( IbExpert allows this to be configured i don't know what settings it use by default ): ReadCommitted isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_read_committed isc_tpb_no_rec_version Serializable isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_consistency RepeatableRead isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_concurrency ReadUncommitted isc_tpb_version3 isc_tpb_write isc_tpb_wait isc_tpb_read_committed isc_tpb_rec_version What version of the .NET Provider are you using ?? -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: Andrew G. <ag...@jc...> - 2004-02-03 21:33:21
|
The database in question is accessed via asp.net webpage and a delphi winapp. When the delphi winapp has a datagrid row(s) uncommited in a transaction, my asp.net readonly query hangs. I can run the same query from database workbench or ibconsole and it runs fine while the winapp has rows uncommitted, but in asp.net it hangs - so I think this is related to the firebird .net provider. I used the sysdba user to rule out any problem with user authority, I tried different isolation levels But made no difference. Why would database workbench and ibconsole run the query, but through asp.net it hangs? Also - it took me a while to figure out how to manually set the isolation level, you may want to add an example to the chm. ------ below is the code example I'm using ------------ <appSettings> <add key="connectionstring" value="Database=C:\\interbase\\xxx.GDB;User=xxx;Password=xxx;Dialect=3;Serve r=localhost;Pooling=False"/> </appSettings> Sub BindGrid() Dim mydataset As New DataSet() dataAdapter = new FbDataAdapter() myConnection = new FbConnection(myConnectionString) myConnection.Open() 'commented out --- Dim myiso As IsolationLevel = 3 'commented out --- myTxn = myConnection.BeginTransaction(myiso) myTxn = myConnection.BeginTransaction() selectCmd = "SELECT * FROM TBLTEST" myCommand = new FbCommand(selectCmd,myConnection,mytxn) Try dataAdapter.SelectCommand = myCommand dataAdapter.Fill(mydataset, "TempInfo") 'filldataset mydatagrid.DataSource = mydataset.Tables("TempInfo") mydatagrid.DataBind() dataAdapter.Dispose() Catch Exp As FbException Message.Style("color") = "red" Message.InnerHtml = "ERROR:" & Exp.Message & "<br>Code = " & Exp.ErrorCode Finally myTxn.Dispose() myCommand.Dispose() myConnection.Close() End Try mydataset.WriteXml(Server.MapPath("data\" & struser & myXMLfile),XmlWriteMode.WriteSchema) End Sub Regards, Andrew C. Goodall |
From:
<car...@te...> - 2004-02-03 13:19:37
|
Hello: > Is FbBackup.Start() asynchronous and there should be an explicit > Thread.Sleep() after backup? No. Maybe it's a problem with the FbRestoreFlags.Replace option i will try to review it later today. -- Best regards Carlos Guzmán Álvarez Vigo-Spain |
From: <meg...@ya...> - 2004-02-03 09:57:21
|
Hello All, I'm having some strange problem while using the Service classes of the Firebird provider. I'm using FbBackup and FbRestore. Here is the code : ------------------------------------------------------------------- try { FbBackup objFbBackup = new FbBackup(); objFbBackup.UserName = user; objFbBackup.UserPassword = password; objFbBackup.Database = dbFile; objFbBackup.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbBackup.Options = FbBackupFlags.IgnoreLimbo; objFbBackup.Start(); objFbBackup.Close(); FbRestore objFbRestore = new FbRestore(); objFbRestore.UserName = user; objFbRestore.UserPassword = password; objFbRestore.Database = dbFile; objFbRestore.BackupFiles.Add(new FbBackupFile(dbBackFile, 4096)); objFbRestore.PageSize = 4096; objFbRestore.Options = FbRestoreFlags.Replace; objFbRestore.Start(); objFbRestore.Close(); } catch(Exception ex) { //LogException(); } finally { /*Delete back up file.*/ System.IO.File.Delete(dbBackFile); } ------------------------------------------------------------------- This piece of code is working fine when I execute my project in Debug mode. But when I make an executable, this code gives error. The error message is (formatted) Message : No message for code 190 found. No message for code 133 found. No message for code 233 found. Source : FirebirdSql.Data.Firebird TargetSite : Void startTask() I couldn't make it, why this error would come. Is FbBackup.Start() asynchronous and there should be an explicit Thread.Sleep() after backup? There shouldn't be any connection active, before backup. Isn't? For this I tried to use FbConfiguration object for a forced shutdown. But that was also of no help. Can u give me any idea, why this could be happen? Thanx, Mahesh. --------------------------------- Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now |
From: <meg...@ya...> - 2004-02-03 09:43:24
|
Hello Carlos, Sorry for being late. But I tried a lot to prepare a test case for the scene mentioned. I couldn't replicate it. It was only in one procedure that I was having this problem. (Code working fine in Beta 2, but not in RC2.) FbParameter fbParam = new FbParameter("@no_of_days",4); This is what the exception I've got Message : Incorrect values within SQLDA structure Source : FirebirdSql.Data.Firebird TargetSite : FirebirdSql.Data.Firebird.FbDataReader ExecuteReader(System.Data.CommandBehavior) By casting it with (object), the FbException doesn't comes. (Code working fine in Beta 2 and in RC2.) FbParameter fbParam = new FbParameter("@no_of_days",(object)4); Will let u know asap. Thanx anyway, Mahesh. --------------------------------- Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now |
From: Alan M. <al...@me...> - 2004-02-02 01:49:56
|
> Also, > Do you know anyone that would like some PHP and Interbase work? ive got > some, it were a resonable price. > > ""Frank"" <Rem...@wh...> wrote in message If you want to contact me offlist, I can help you. Alan |
From: Alan M. <al...@me...> - 2004-02-02 01:45:04
|
> Thanks.. > How does PHP talk to the interbase server? This is where Im confused. > > ""Alan McDonald"" <al...@me...> wrote in message It uses direct API calls which are wrapped by php function calls using the ibase plugin .dll library Alan |
From: Frank <Rem...@wh...> - 2004-02-02 00:29:30
|
Also, Do you know anyone that would like some PHP and Interbase work? ive got some, it were a resonable price. ""Frank"" <Rem...@wh...> wrote in message news:bvi249$4fc$1...@ne...... > Hi, > Ive had good luck with Delphi and Interbase. I now want to create some > dynamic pages that are connected to firebird, running on a windows 2000 > server. what is the best way? PHP? ASP?? Connect with ODBC?? any basic > direction would be appreciated.. > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |
From: Frank <Rem...@wh...> - 2004-02-02 00:28:41
|
Thanks.. How does PHP talk to the interbase server? This is where Im confused. ""Alan McDonald"" <al...@me...> wrote in message news:NBB...@me...... > > Hi, > > Ive had good luck with Delphi and Interbase. I now want to create some > > dynamic pages that are connected to firebird, running on a windows 2000 > > server. what is the best way? PHP? ASP?? Connect with ODBC?? any basic > > direction would be appreciated.. > > > > if I were starting out I would go straight to PHP. You don't need ODBC and > ASP, as much as it is good technology..., well PHP has a few more bells and > whistles now. > Also get a hold of ezSQL from JVMultimedia - it's like weight and very good > for a class/object based approach to db connection and access. > I've done some work with ASP.NET and really, there's no real advantage over > PHP - it's actually slower at this time. > Alan > > > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > Firebird-net-provider mailing list > Fir...@li... > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > |