Stack Overflow
Stack Overflow

Questions tagged [interbase]

InterBase is a SQL database system for server, desktop and embedded applications, for use on Windows, Linux, macOS, iOS and Android. InterBase 2020 is the newest version and integrates with Embarcadero's RAD Studio IDE supporting Delphi and C++ development. InterBase supports connectivity from many other programming languages as well. See https://www.embarcadero.com/products/interbase for further information.

331 questions
5
votes
1 answer

Database connection with Firebird Adapter in Zend Framework

I just started to learn about ZF and Firebird because of a project I am assigned to. I have been trying to make the connection between both for several days now, but I haven't succeed yet. I tried ZF with PDO_Mysql and it works just fine as it does…
Clarissa
  • 115
  • 1
  • 9
4
votes
3 answers

Finding a legacy firebird/Interbase database password

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…
Martin Marconcini
  • 23,346
  • 18
  • 98
  • 135
4
votes
1 answer

Interbase XE7 and Entity Framework 6.1.2

Currently I am working on a project where I want to create a database layer for Interbase database using the Entity Framework. The only thing is that I can't get it to work, so I turn to my beloved SO co-users. I am currently using: Visual Studio…
RFerwerda
  • 1,237
  • 1
  • 10
  • 23
4
votes
1 answer

Is it possible to tweak TStringField to work like TWideStringField in Delphi?

We want to use Unicode with Delphi 2009 and Interbase, and found that to switch the character encoding from WIN1252 to UNICODE_FSS or UTF8 we first have to replace all instances of TStringField with TWideStringField in all datamodules. For around 60…
mjn
  • 35,561
  • 24
  • 160
  • 351
4
votes
8 answers

Delphi dbExpress and Interbase: UTF8 migration steps and risks?

Currently, our database uses Win1252 as the only character encoding. We will have to support Unicode in the database tables soon, which means we have to perform this migration for four databases and around 80 Delphi applications which run in-house…
mjn
  • 35,561
  • 24
  • 160
  • 351
4
votes
3 answers

How to restart Interbase

I try to follow http://edn.embarcadero.com/article/28604 for restarting Interbase. Here is some code: program IBRestart; {$APPTYPE CONSOLE} uses SysUtils, winsvc; var vManager, vService: SC_Handle; vtmp: TServiceStatus; begin vManager :=…
Roland Bengtsson
  • 4,902
  • 8
  • 53
  • 89
4
votes
3 answers

Weird three minutes delay for TSQLConnection.Connect with InterBase 7.5

Environment: Delphi 2009 client applications (and one Java), running on Windows 2003 server connecting to InterBase 7.5.1 (another Windows 2003 Server) over dbExpress The Delphi applications log the time to open the TSQLConnection using the…
mjn
  • 35,561
  • 24
  • 160
  • 351
4
votes
2 answers

How can I copy records between tables only if they are valid according to check constraints in Firebird/Interbase?

I want to copy a bunch of records from a temp table to a target table. The problem is that some records may violate check constraints in the target table so I want to insert everything that is possible and generate error logs somewhere else for the…
Rafael Piccolo
  • 2,249
  • 1
  • 15
  • 28
3
votes
2 answers

Should I use native Interbase components to read an Interbase database from Delphi

I have an Interbase 5.5 database (note: this is a very old version, from the last millenium). So far I have managed to connect to it using the "native" Interbase components that ship with Delphi (IBDatabase, IBQuery etc). There seems to be a few…
awmross
  • 3,639
  • 3
  • 34
  • 47
3
votes
5 answers

Help With SQL Query - Sub Query Using INTERBASE

I have the following query SELECT * FROM ( select distinct r1.rep_code, r1.contact_id, c1.Name, e1.year_num, e1.period_num …
c11ada
  • 4,182
  • 14
  • 43
  • 62
3
votes
2 answers

SSIS Error code: 0xC0014009

How to solve problem run job SSIS by SQL Server Agent failed with error code : 0xC0014009. My job ssis package transform data from source database interbase to target sql server for use ODBC. I found job failed Error: The AcquireConnection method…
Going
  • 31
  • 1
  • 3
3
votes
2 answers

Select AS not working in interbase

works select payeeid, EXTRACT(WEEKDAY FROM checkdate) as DOW, (bankcleared - checkdate) as DateDiff from Master where (bankcleared is not null) order by payeeid, DOW, DateDiff adding DateDiff to Where - does not work select payeeid,…
IElite
  • 1,768
  • 7
  • 36
  • 63
3
votes
3 answers

Delphi Interbase Sql Conversion to Sql Server and Oracle

i have a delphi application which uses database interbase / firebird. To consult and write data I use the InterBase components palette (IBTable, IBQuery, IBDataset). I'm performing the conversion of my system to sqlserver / Oracle but i…
Mauro Reis
  • 41
  • 5
3
votes
2 answers

Max length TSQLConnection.Params values

Hello fellow StackOverflowers, Currently I'm facing a situation where it seems that there is a maximum length for the Database property of a TSQLConnection object in Delphi. When I open the connection to my database I get the following error when I…
RFerwerda
  • 1,237
  • 1
  • 10
  • 23
3
votes
2 answers

PHP is not connecting with a firebird (interbase) database

I have a legacy system to maintain and in production this system runs ok, but in my development machine I can't connect to the database. My OS is a Ubuntu 14.04 with a fresh install of firebird2.5-classic, php version is 5.5.9-1ubuntu4.5 and i…
Loquaz Mendes
  • 31
  • 4
1
2
3
…
22 23