I am trying to choose between postgre and firebird databasses. The database will be installed on a windows 2003 server with asp.net 3.5. i don't want to use sql server because of price issues and I don't want MySQL I had a bad experience with it and the .net connector and the membership provider. ...
When updating a DataTable with 1850-ish new rows to a FbDataAdapter I get a NullReferenceException during execution. Usually it succeeds in inserting around 1200 records, sometimes more, sometimes less... However when stepping through the code with the debugger, it sometimes inserts the entire recordset, no problem. I am using the Fir...
I have a general questions about domains. I recogniced, that when I create a table and I don't use a domain, a default domain will be created, such as RDB$1, RDB$2, RDB$3, aso. Here are my questions: - What impact has the default created domain? - Does these enlarge my database size? - Does these have an inpact of the performance? - S...
Hi, I found EXPLAIN SELECT query very useful in MySQL because it gives information on how SQL will be executed and gives the opportunity to analyze, for e.g., missing indexes you should add in order to improve response BEFORE doing the query itself and analyzing stats. My question is: In databases like MS Sql, Firebird, Ingres, is ther...
I have a dotnet application written for Firebird and am planning to use Subsonic with it. Does anybody have any experiece with it. Are there any major issue with it ? Any help would be appreciated. ...
I know you will say there are several duplicates for this question. I've read most of them. But I need an answer to the specific case I'm presenting. I'm planning to store millions of small jpg images (about 3kb) in a Firebird database. Assumptions: - The table that will contain these images will not contain any other information but i...
There's a database engine that looks amazing for a free tool and that is Scimore. Have you had much experience with it? If so, how does it rate..particularly against Firebird? How resilient/self reliant is it? (Meaning how much downtime/maintenance is expected?) The scale out capabilities also look very interesting. I just downloade...
Kindly give your comments / input ... We are considering Firebird Database, and getting a Linux Red Hat Server for our Database System .. is it advisable?, What's the future like for Linux and Firebird Database? Also, are there many developers available with knowledge of Firebird? ...
Hi All, I need to point a tech team in the right direction to investigate a very short term interim solutiuon for an online XML authoring database. The idea would be to set up something which does not require us to commission a server Multiple users need to interact with any of the database records remotely from multiple locations A s...
There have been recommendations to use Firebird as a enterprise alternative to Oracle, MSSQL, MySQL, PostGre. I'm planning to move some our SQL Server databases to viable alternatives and I'm interested in Firebird as a possibility (alongside Postgres and MySQL). Question Why shouldn't I use Firebird? What problems do you usually en...
How do I register a Firebird data provider to use it with Entity Framework? What should I do to make it appear in the Entity Data Model Wizard/Choose Data Source window? I expect it to appear in the Data sources: or Data provider: lists. Is it possible? Or I need to configure this connection another way? PS: The provider I'm trying to ...
I have a Firebird database (running on server version 2.1.3) and am connecting to it with Delphi 2007 using the DBExpress objects (using the Interbase driver) One of my tables in the database looks something like this CREATE TABLE MYTABLE ( MYDATE Timestamp NOT NULL, MYINDEX Integer NOT NULL, ... Snip ... PRIMARY KEY (MYDAT...
My application at present uses Microsoft Access, but now may be hosted on Linux boxes. Additionally while being accessed from multiple computers, one of these may update the records (when its being read by other users). I also require that the embedded database should support complex SQL queries - like inner SQL, Joins, etc. I tried SQ...
Hi All; I am new to Firebird using its Java version Jaybird, But unable to connect from database (.fdb file). The problem comes like this: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544375. unavailable database OR java.lang.RuntimeException: Failed to initilize Jaybird native library. This is most likley due to a failure ...
I was about to use Firebird for a project, when someone told that DB2 Express C is also free, and with plethora of tools, and is also mature. I read Firebird is also good for use as enterprise client/server database. Then how does it compare to DB2 Express C? Could the experienced ones shed some light on this. ...
I'm using nhibernate as my ORM and Firebird embedded as the database. How would I got about saving a DateTime to the database? This is an example definition of a class. [Class(Table = "table")] public class Table { private int mId; private DateTime mDate; [Id(Name = "Id"),Generator(1, Class = "native")] public virtual ...
I have problem with connecting to a Firebird database. It works perfectly, when I use isql tool, or program I have written using Borland dbExpress drivers. When I try to test ODBC connection it fails. I am using official Firebird ODBC drivers, version 2.0. Strange facts: On other machines in the same network ODBC connection test fails...
Hi, I have a table that represents the parameters of a contract - including their change over time through addendums. The first addendum is a "special" addendum representing the parameters when the contract was first signed. Here's how the table should look like: ID ProjectID BeginDate DeadlineMonths DeadlineDate 1 20 20-12-2...
After looking at a lot of questions..i found no real answer for this. I redisigned an Database for our customer. With Microsoft Access i found a good Tool to get old table Data in my new well formed Database Structure. It is really easy but takes a lot of time (cause handling old Data with a lot of care). Are there any Open Source Tool...
A short question for the PROs. Is it possible to use Zend_Auth_Adapter_DbTable with ZendX_Db_Adapter? I've tried this: $adapter = new Zend_Auth_Adapter_DbTable( Zend_Registry::get('db') ); $adapter->setTableName('USERS') ->setIdentityColumn('username') ->setCredentialColumn('password') ->setIdentity('FOO') ->setCred...