... Another way is to create indices together with other database objects, but as INACTIVE, then activate them after data insert. You can use the same EXECUTE...
Hi! It works just fine. I'm using: - Pocket PC 2003 - Data Provider for .NET Compact Framework 2.0 - Software written in C# - Firebird server v1.5.x It is an...
Hi, I got this error while restoring an fb2 database on fb1.5 server. Of course, I did first the bakcup on fb2 server with fb1.5 gbak.exe. ... gbak:...
... Does the backup restore successfully to a FB2 server? If not, it may be corrupt. If you can restore to FB2, I guess you must be using a feature new to FB2...
I am having a problem with the firebird super server which has its CPU peak at 100% for at least 30 seconds. I came across http://www.firebirdfaq.org/faq312/...
Scott Buckham
scott_buckham@...
Sep 3, 2007 1:12 am
88799
... CPU peak ... solution for me ... trading. ... would ... set to ... collecting in ... You may want to take a look at Classic server (especially if you have ...
... Well, if a GC thread was in process at the time, it would die. ... The sweep interval doesn't determine whether or not GC takes place. What version of...
... OK, it makes sense that it fails but was worth a try. ... I agree, but it doesn't. I imagine the information must be available in the system tables ...
... Re-read Adam's advice. To put it more clearly, you cannot downgrade a v.2.0 database once you have created objects that are not supported by the older...
Hi, I get following error when adding new user to embeded FB: Cannot attach to services manager service C:\ise\D5\tap.fdb:service_mgr is not defined ...
... OK, suspected that this is the case... Now should I file feature request on this? I know that embeded doesn't have "real security" (ie password isn't...
... You can only have user management if you have a way to store the user names etc, which involves the security database. IMO, this is beyond the scope of the...
Hi All, We are using Firebird 1.5.3 for our application. We are using a SELECT query which fetches data from four different tables. If this query is executed...
... So? Drop security.fdb into app dir (where the fbembeded.dll is) and youre done. Actually, right now embedded checks for username so it must read it from...
... No it does not. The system tables in each database don't include users. ... On which level? If you want them to behave the same, they should both have...
... Hi Mario You can use this Delphi 7 code to check if Firebird is running. First copy this function to your code (You need to include the unit WinSvc): ...
SO Windows Firebird 2.0.1 Using isql to execute one script test.sql isql -i test.sql */test.sql*/ INSERT INTO Table1 (Field1) VALUES ('Line1 Line2'); Isql...
... Is your isql on Linux? Linux newline is LF (no carriage return) so, if the script was composed on Linux, no CR would be stored. ... Windows newline is...
Hi all, I am getting the following errror when I try to run as a normal user: ================ FirebirdSql.Data.FirebirdClient.FbException: operating system ...
... It is usually a better idea to make the characters explicit. From the Firebird Book, p162: INSERT INTO Table1 (Field1) VALUES ('Line1' || Ascii_Char(13)...
Richard Wesley
hawkfish@...
Sep 3, 2007 3:42 pm
88817
Hi Helen, ... No, isql in Windows XP. Thanks, Paulo Geloramo ... so,...
... What I have done is I use a Web Service written in ASP.Net that returns DataSets. I used the conecept of Provider Factory in Ado 2.0, that way my client...
