interbase

Firebird's SQL's Substring function not working

I created a view on a machine using the substring function from Firebird, and it worked. When I copied the database to a different machine, the view was broken. This is the way I used it: SELECT SUBSTRING(field FROM 5 FOR 15) FROM table; And this is the output on the machine that does not accept the function: token unknown: FROM B...

How to convert legacy Interbase DB to SQL Server?

I have an Interbase DB. How can I convert it to SQL Server? ...

Best way to connect to Interbase 7.1 using .NET C#

Hi there, Could someone please explain the best way to connect to an Interbase 7.1 database using .NET/C#? The application will be installed on many end user computers so the less "add-ons" that I will have to package with my application the better. ...

Persuade Access 2007 to use a .UDL file/oledb connection?

Is there any way of coaxing Access 2007 into using a .UDL file? Specifically, one of our older products uses an Interbase 6.0 database. My client would like to link to his database, for read/write, using Access 2007 (in the short term). While this isn't my preferred way of doing things at all, given it's all single-user and the other ...

How to use journaling between 2 physical machines with IB2009 ?

I'm member in a team that have bought Interbase 2009. We have 2 identical servers running Windows 2003, one liveserver running production database (around 18 GB). And one testserver for development and test. The data is business critical and now we take backup every night with gbak -b. But still we can loose a whole day of work in case ...

How can I merge data within a DB table by a SQL statement?

I have an interesting problem for Interbase. I have a record set which amongst other things has a data entry field and a timestamp for each record. I would like to be able to copy the timestamp from records so that at the end of the day the final field will read along the lines of: TIMESTAMP <Carriage return> <carriage return> Origina...

Finding a legacy firebird/Interbase database password

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

Accessing data from a .gdb file with SQL Server Integration Services (2005 or 2008)

I have number of files in .gdb format, which I believe is associated with Borland interbase. Does anyone know how I would go about extracting data from the using SSIS (2005 or 2008)? Any help very much appreciated. Ed. ...

Best way to design database tables with interbase?

I am about to start redoing a company database in a proper fashion. Our current database is a mess and has little to no documentation. I was wondering what people recommend to use when designing an Interbase database? Is there some sort of good visual schema designer that will generate the SQL? Is it better to do it all by hand? Basica...

How do I limit the number of records returned for Interbase 7.1?

We have an Interbase 7.1 database and I'm trying to figure out how to limit the number of records returned by the query to just 1. I really only need to know an event code from the last record, in which the query will return hundreds of records if I cannot do some kind of limit. Thanks in advance! ...

Is there an efficient and free method of migrating a 6GB Interbase DB to MySql?

That's about it. I can always just dump it to csv and read it in, but I was hoping to avoid that. ...

How do I connect to Interbase 6 on a remote location from .NET?

What drivers should I use? Are they free? How should the connectionstring look like? Thanks ...

How do I see what queries are running on an interbase database

I have a Interbase 7.x database being used by an application. I want to know which queries are run by that application in different scenarios. Does anyone know about how to "profile" an interbase database and see which queries are currently running? ...

Delphi Interbase JSON server

I'm building a little personal project; I wish to have a Windows Service that will act as a simple HTTP server accepting requests via HTTP, run queries against an Interbase 6/7 server and then return results in JSON format. Could anyone recommend some tutorials, free components or just a quick plan of how they would develop the various ...

How can I access an Interbase (.IB) database using RubyOnRails?

I have a database in Interbase and I want to access it directly from my Rails app using ActiveRecord. How can I do it? ...

Database Design: Alternate to composite keys?

I am building a database system and having trouble with the design of one of my tables. In this system there is a users table, an object table, an item table and cost table. A unique record in the cost table is determine by the user, object, item and year. However, there can be multiple records that have the same year if the item is di...

How can I add a InterBase JDBC connection pool in GlassFish V3?

Using: InterBase 2007, latest interclient.jar (8.1.8), GlassFish v3 b68. I try to configure the connection pool in the web admin console page "Edit Connection Pool" with these settings: Resource Type: javax.sql.DataSource Datasource Classname: interbase.interclient.DataSource A 'ping' in the same screen returns this error message: ...

Porting an IBXpress Interbase 6 app to the current Firebird platform, on Delphi 7?

Just wondering if there are any gotchas to be wary of here. We have a legacy D7 app that we developed several years ago for a client, which uses IBXpress to talk to the open source Interbase 6 build. We're having a number of issues with that platform these days (very slow to connect/start-up on new hardware being the chief one) and the...

Interbase SQL SELECT query using CASE

I'm running the following query against a .gdb-file: SELECT CASE USERS.USERID WHEN 1 THEN 'God' ELSE 'Somebody else' END FROM USERS; However, running essentially the same query against a .ib-file, I get "Error at line 1 Dynamic SQL Error, SQL error code = -104, Token unknown - line 1, char 17". It seems it doesn't recognize the part C...

Interbase 2009: complete removal?

Are there any tools for completely removing an Interbase 2009 SMP installation? I found an article describing how to remove IB6 (http://edn.embarcadero.com/article/28131), but I'm reluctant to delete anything in the registry according to a document which applies to another version of IB. Are there any equivalent descriptions for IB2009? ...