Question: I currently store ASP.net application data in XML files. Now the problem is I have asynchronous operations, which means I ran into the problem of simultanous write access on a XML file... Now, I'm considering moving to an embedded database to solve the issue. I'm currently considering SQlite and embeddable Firebird. I'm not ...
I have two firebird databases running on the same server and I want to write to a table on one of the databases from a trigger on the other database when certain actions occur. I have had a search and cannot find out if this is possible. Can it be done either natively in firebird or via a UDF? Thanks Neil ...
Consider this table (from http://www.tizag.com/mysqlTutorial/mysqlmax.php): Id name type price 123451 Park's Great Hits Music 19.99 123452 Silly Puddy Toy 3.99 123453 Playstation Toy 89.95 123454 Men's T-Shirt Clothing 32.50 123455 Blouse Clothing 34.97 123456 Elec...
Using fbclient.dll in Firebird 2.1.X in fresh install Windows XP that never install with Microsoft C++ 2005 Redistrubable will cause problem. I wish to deploy my application that contain fbclient.dll and all related Microsoft C++ 2005 redistributable libraries without installing the redistributable libraries. Can I do that? I am runni...
I've got a record set that consists of a start and end time in two separate fields: id - Int startTime - DateTime endTime - DateTime I'd like to find a way to query a record and return it as X records based on the number of 15 minute intervals found between the start and end times. For example, let's say I have a record like this: ...
Hello everybody! I don't know if some of you also has experienced it but when I edit a query in Visual Studio (it uses DDEX 2.0.5 for accessing the Firebird 2.5 database), it duplicates some of the columns. What's really interesting is the fact that only System.Boolean columns are duplicated: Originally, there was only ,for instance, a...
Can I continue to use the interbase vcl components in delphi 2010 with firebird 1.5? Thanks ...
I have a table which already contains some rows and does not have a primary key. I want to add a primary key now, but for that I need to set unique values for the primary key field of the existing rows. How can this be done, using the newly added generator? ...
Our software installer install firebird if it is not present on the system and, as we are pursuing Win certificate the uninstaller should remove it but, we want to make sure that even if it was the installer that put it there, if any new software is using it now with a new database, we would not remove it (Firebird). The question is: Is...
I am considering the migration for 4 reasons: 1) SQLSERVER installation is a nightmare, expecially for 1-user software (Even if typically I have 3-20 users, sometimes I sell my software to single users: it is incredible to have troubles installing the DB, while installing the applicatino means copying an exe...). (note my max installati...
I am considering migrating to Firebird. To have a "quick start" approach I downloaded the trial of a conversion tool (DBConvert) and tried it. I just picked up a random tool, this tool doesn't convert procedures, functions and triggers (I don't think it is a limit of the trial since there is not an explicit reference to sp, sf and trigg...
Assuming the Firebird client is installed what additional files need to be included with a Delphi 2010 application that uses dbExpress to access the Firebird database. I assume dbxfb.dll (midas is included in the project 'uses') is required. Any others? ...
IMPORTANT NOTE: I recieved many answers and I thank you all. But all the answers are more comments than answers. My question is related on the number of roundtrips per RDBMS. An experienced person told me that MySQL has less roundtrips than Firebird. I would like that the answer stays in the same area. I agree that this is not the first ...
I am looking into using a lightweight serverless database engine like SQLite, Firebird, or VistaDB in an upcoming project. Someone asked about What are the advantages of VistaDB. I would like to know what are the disadvantages of using VistaDB versus other technology? UPDATE: VistaDB out of business (the real disadvantage) I have jus...
I'm having trouble getting a connection to a Firebird database. I can't seem to find too much information on Fluent NHibernate and Firebird on the Internet which lead me to here. Can anyone provide any insight on how to connect Fluent NHibernate to a Firebird database in C#? I'm specifically writing a WPF application. ...
I followed all the steps suggested here Minimum Firebird Client Installation on Windows. However I haven’t managed to make my application to run yet. Does anyone have managed to run .Net applications only meeting the requirements described in such link? If not, what were the additional settings you had to make in order to achieve it? ...
We have a "large" code base already developed using SQLite and NHibernate using .NET 2 for our clients. Using SQLite we can communicate with the db (even multiple clients) across a Windows file share. Most of the time, this is perfectly sufficient for what we need to do. Over the last few months, we have needed to integrate our applic...
I have a client that uses the mysql database to enter data, but he wants the data can be read with accurate program that uses the Firebird database. Is there a solution to move data in mysql to a Firebird database? ...
I'm writing a small java program that can read a .GDB file using the embedded Firebird server (libfbembed.so) on linux. I have all my paths correct: my classpath provides the Firebird classes, and my java library path provides the jaybird library. My connection string is: private String connectionString = "jdbc:firebirdsql:embedded:/...
I want to use a DNS-less connection Report in order not to set the DNS each time that I install my application but I have problems when I try to set the connection string from C#, the best thing that I have found is: http://stackoverflow.com/questions/674363/how-do-i-change-a-crystal-reports-odbc-database-connection-at-runtime I have tr...