Все вопросы: [firebird]

105 вопросов

1
голосов
2ответов
507 просмотров

ADO.NET (Sql Compact + MySQL + IBM db2 expressC)

I'm developing an app which will have a central database users can add entries to. The database will have to be on a server somewhere but I want the users to be able to add entries offline. The app will sync to the main db when connection is available. So, I supose I need 2 databases - the main o...

1
голосов
4ответов
1024 просмотров

How to migrate an old Database into a new Database using Microsoft Access

Basically this task is pretty easy when you think about it, but I found no answers in Microsoft Access or MSDN. I have to create a connection to a new Database and query the old one. After validating the old data, everything is written in a new fine Form to the my new Database. Any Ideas? Add:...

0
голосов
1ответов
530 просмотров

WAIT in Transaction - Firebird

Can we set the index active when another transaction is in progress. Will firebird wait till the other transaction completes its operation and the index will become inactive/active (this is for reindexing) after that ? Thank you. Regards, Sabu

3
голосов
2ответов
612 просмотров

integer primary key for replication

I am weighing my options for integer primary keys that can be used in multi master replication. (I'm pretty much sold on using integer keys instead of GUIDs) The best I can come up with is having the most significant data first and having the server number last: eg. invoice 1 on server 1 = 101 i...

11
голосов
3ответов
29005 просмотров

JDBC connection with auto reconnect

I am using JDBC to connect to a database server. The connection is over a wireless network and can be dodgy at times. At the moment when the connection is lost I need to close and restart the application. Does anyone have some examples of code where I could write some sort of wrapper to automati...

4
голосов
1ответов
4161 просмотров

How to change field types or field length comfortably in Firebird?

I mean, even if the database is empty, you have to drop a varchar(50) field and recreate it to make it varchar(30). Not to mention constraints... This is very frustrating. I am the SYSDBA and Firebird make very simple things way harder than it should be. If I voluntarily decide to shoot my own f...

2
голосов
2ответов
683 просмотров

Embedded Firebird unload delay

After I close my application fbclient.dll remains in memory for about 3 seconds. So it locks the database file and prevents my application from unloading. I'm using Firebird embedded. The problem is related to events. I signup to events using isc_que_events. If I don't signup to events dll unloa...

0
голосов
5ответов
5088 просмотров

String functions in SQL

I need query (to be more specific, it is view, not query) that will return string column. String will be code, that might be prefixed with two letters (LJ). If it is prefixed -- prefix have to be trimmed. If there is no prefix present, it should be left untouched. Is it possible to do such thing...

1
голосов
5ответов
2402 просмотров

Database Component for Firebird using D2010

I just upgraded my BDS2006 Prof to D2010 Prof. I usually use Interbase component (TIBDatabase, etc) to connect with the database. I am thinking about other alternative components. Sadly, Zeos component (6.X) currently still not working with D2009/D2010. DBExpress support FB connection but not in ...

4
голосов
4ответов
13735 просмотров

How to backup a Firebird database?

I am working on my first WinForms application with a Firebird database shared over a network. Now I wonder how should I ensure database backup and restoring? Up till now, my applications used embedded databases (SQLite), so I was sure that only my application accessed the database. The applicati...

2
голосов
2ответов
550 просмотров

Zend_Auth and Firebird DB

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...

0
голосов
6ответов
1190 просмотров

ETL Tool for transfering old Firebird Database to a new organized Firebird Database

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...

1
голосов
2ответов
5418 просмотров

SQL - Reference current row in a computed column with SELECT

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 DeadlineMo...

0
голосов
2ответов
1462 просмотров

Difference between Firebird isql and ODBC connection

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 t...

0
голосов
2ответов
583 просмотров

How do I specify a DateTime mapping in nhibernate when using Firebird?

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
голосов
6ответов
1405 просмотров

How does Firebird client/server compare to DB2 Express C

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 so...

2
голосов
4ответов
9791 просмотров

Connection issue in JayBird

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...

15
голосов
6ответов
3828 просмотров

Which embedded database has maximum SQL compliance, and concurrency support?

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...

5
голосов
4ответов
3874 просмотров

How to get the millisecond value from a Timestamp field in firebird with Delphi 2007

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 NUL...

7
голосов
2ответов
11384 просмотров

How to register Firebird data provider for Entity Framework?

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 ano...

0
голосов
5ответов
1079 просмотров

Firebird Database & Linux Red Hat Base Server for FireBird Database

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?

0
голосов
2ответов
1180 просмотров

Do you use Scimore SQL database?

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 als...

2
голосов
4ответов
2481 просмотров

Store millions of small images in Firebird blob fields

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 wi...

1
голосов
1ответов
292 просмотров

Using Subsonic with Firebird

I have a dotnet application with a Firebird Database back-end. I am planning to use Subsonic with it v3. Does anybody have any experience with it. Are there any major issue with it ? Any help would be appreciated.

18
голосов
6ответов
6636 просмотров

EXPLAIN SELECT in other databases

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 l...

1
голосов
3ответов
2536 просмотров

Domains in Firebird

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 th...

1
голосов
3ответов
1068 просмотров

Why does the FbDataAdapter throw a NullReferenceException after batch updating for about a minute?

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 ...

7
голосов
18ответов
6590 просмотров

What do you think of Postgres and Firebird Databases?

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.

1
голосов
2ответов
981 просмотров

Is Entity Framework provider for Firebird reliable enought?

Has anybody tried to use EF provider (.NET 3.5 SP1) for Firebird (embedded server in my case) in production? Can it be considered stable enough for commercial development?

2
голосов
2ответов
5939 просмотров

Firebird custom installation

I want to deploy a firebird installation, and thus will launch it from my installer using command-line parameters. I read Inno Setup's documentation but still can't get it to work. I just want to install a "Super server" with no documentation or whatsoever. Here's what I have so far Firebird-2...