I am trying to build SQL for a parameter query in C# for a query which will contain the LIKE %% command. Here is what I am trying to acheive (please note that the database is Firebird) var SQL = string.format("SELECT * FROM {0} WHERE {1} LIKE '%?%'", TABLE, NAME); Cmd.Parameters.AddWithValue(NAME, "JOHN"); Now I have tried every sing...
Hi, I have a customer that has an old non-existant application; he had a problem with the company that made the application and they won't disclose his database password. He realized that he signed a contract (back then) where it said that he was sort of "renting" the application and they had no right to disclose anything. This customer...
Greetings all, I have the following bit of code that I have used in the past to export a DataSet generated from the Stored Procedure 'HISTORICAL_COSTS' to Excel. Dim c As Long = 1 For Each dc As DataColumn In Me.WOCostDataSet. & _ HISTORICAL_COSTS.Columns .Cells(1, c).Value = dc.ColumnName.ToString ...
I've used the command-line switches for installing a Firebird database from within the install package for my application. But now I'd like to uninstall Firebird in the same way. The problem is that the Windows install executable for Firebird was built with Inno Setup. In order to uninstall an Inno Setup executable, you have to run a f...
I really want to know, how to secure a firebird database from being opened by any user but from the application it self. If I distribute a desktop application with a single file Firebird database (not embedded), how to protect the database from being copied to another machine running Firebird with known sysdba password? I have searched...
I've got a seemingly unique issue on just one computer in the company. (had to be my boss's) I've got a program from borland C++ that usese a TSQLConnection. It connects to a local firebird server 2.1.1.17910 running as an application. The other computers work fine. it will ABSOLUTELY NOT connect on this one lappy (local server) for ANY...
I use Delphi 7 with DBExpress. I want to fully migrate my app to firebird 2.1. I already know what to do at the server side but not really sure at client side. In the TSQLConnection component I see that vendorLib property points to GDS32.dll. The driverName is Interbase and getDriverFunc is getSQLDriverINTERBASE. I don't know what to d...
In my table I want to set default of a column to 30 days from now. This needs to be a real, not computed column. Something like alter table T_NAME alter column EXPIRATION set default CURRENT_TIMESTAMP + 2592000 is not valid, but you get the idea. I am sure I can do that with a before insert trigger, but I was just wondering if ther...
We are using firebird as our database. How do we go about storing currency symbols in the database. Which character set should we use or what is generally best practice? For example storing "$" or "¥" appears straight forward but more complex symbols do not appear correctly in the database table, i.e. "₡" will not store in the database....
Is there any PHP web framework that works cleanly with the Firebird database? By "cleanly", I mean out-of-the-box, no hacks/customization/self-made drivers. So far, I've checked out frameworks like CodeIgniter & CakePHP, but their support for Firebird is vague or little at most. ...
What is the best way to implement fast queue where multiple users try to access to about 100 000 records. Only one user can get one unique row. Now im using sql database (firebird) but there is a lot of problems deadlocks / high database load. ...
I am changing all varchar columns in our firebird database to UTF8 however I don't understand the difference in varchar size. For example, with the charset and collation set to nothing, we can set the varchar size to 255, if we set the charset and collation to UTF8, when we set the varchar to 255, it reads different values. What would ...
In my Delphi7 app, I can connect to the database when logged in as Administrator ("Dave"), but not when logged in as a standard or limited user ("Paris"). Happens on XP Home & Vista Business Ultimate 64. I use an alias for the db, and have tried placing the .fdb file in Program Files, in an app folder on the C drive, and in Users\Applica...
In my Delphi7 app, I can connect to the database when logged in as Administrator ("Dave"), but not when logged in as a standard or limited user ("Paris"). Happens on XP Home & Vista Business Ultimate 64. I use an alias for the db. Database is Firebird, middle-ware is IBO 4.7. I posted this in another thread, but know I have a lot more i...
I use both Firebird embedded and Firebird Server, and from time to time I need to reindex the tables using a procedure like the following: CREATE PROCEDURE MAINTENANCE_SELECTIVITY ASDECLARE VARIABLE S VARCHAR(200); BEGIN FOR select RDB$INDEX_NAME FROM RDB$INDICES INTO :S DO BEGIN S = 'SET statistics INDEX ' || s || ';'; EXECUTE STATEME...
I'm looking into implementing full text search on our Firebird database. Our requirements are: Every field in several tables should be indexed. When a result is found we should be able to find out the originating table. The index can be stored in the database or in the file system. The results of the search (BigInt primary keys) must b...
I'm trying to generate an entity model from a Firebird database using the Entity Data Model Wizard, but it dies loading the data for the "Choose Your Database Objects" step with the error: Microsoft Visual Studio An error occurred while connecting to the database. The database might be unavailable. An exception of type 'Sy...
Which Freeware "GUI tool" for "FireBird RDBMS" closestly resembles "MS SQL Server 2000 Management Studio"? ...
Hi, i got an old Firebird Database with a lot of content. Is there an easy way to get the content of this Database without rewriting the tables from Database for an Grails Application? An example would be nice. Thank you! ...
Hello again, So Hibernate Supports the latest Version of Firebird, which is really great. But... I got here an Firebird 1.5.2 Database. My Grails App using this Database via Hibernate...so far everything great. My Apps sends Queries with Functions that are not known to my Database. For Example the Function LOWER, which is now supporte...