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.
Questions tagged [interbase]
356 questions
0
votes
2 answers
Creating database in InterBase
I try to create a InterBase database on Delphi using TIBDatabase type.
ibdb:=TIBDatabase.Create(nil);
with ibdb do
begin
SQLDialect:=3;
DatabaseName:=Self.name;
Params.Clear;
Params.Add('USER "SYSDBA"');
Params.Add('PASSWORD…
AN90
- 67
- 1
- 10
0
votes
2 answers
IBDAC / UniDAC + interbase 6 or 7 + a table field named "returning"
I am porting REALLY old code to use the UniDAC components. I have hit a wall with a specific UPDATE sql that changes a field named "returning." Simply wrapping the field in quotes does not resolve the issue, because the SQL dialect in the database…
Stamp
- 89
- 9
0
votes
1 answer
Generate row numbers in SQL from Interbase
Is this possible from Interbase ?
For example like in this link.
Roland Bengtsson
- 5,058
- 9
- 58
- 99
0
votes
0 answers
php 5.6.13, PDO, connect to interbase fails (Debian GNU/Linux 7.7 (wheezy))
I can connect to my interbase using IBConsole using the same user/pass as I use in php
php --version
PHP 5.6.13-0+deb8u1 (cli) (built: Sep 7 2015 13:38:37)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend…
Terje Rosenlund
- 153
- 1
- 9
0
votes
1 answer
Delphi 10 Seattle missing libsqlib.a
I can't compile my multi-device iOS application, because there is an error:
[DCC Error] E2597 ld: file not found: libsqlib.a
I use Delphi 10 Seattle.
I didn'd find solution for this, only for the Delphi XE8 and XE5 libsqlib.a can be downloaded. But…
methos
- 13
- 4
0
votes
0 answers
Microsoft OLE DB Service Components error 8007007E
My Delphi XE8 app MyApp.exe fails with EOleException
ErrorCode = -2147024770 {$8007007E},
Message = 'The specified module could not be found'
Source = 'Microsoft OLE DB Service Components'
which unfortunately doesn't give name of the incriminated…
jkomorowski
- 45
- 7
0
votes
2 answers
Dynamic SQL Error 804 Incorrect values within SQLDA structure
I'm getting this dynamic sql warning after trying to fetch results from this query:
Warning: ibase_fetch_assoc(): Dynamic SQL Error SQL error code = -804 Incorrect values within SQLDA structure
SELECT VOORRAADAUTO.*, AUTOMERK.*,…
Monstertov
- 23
- 6
0
votes
2 answers
Issues installing interbase/firebird PHP extension on MAMP
I'm currently having issues trying to install interbase support (interbase PHP extension) on my Mac MAMP PRO installation (with PHP 5.5 selected).
Here are the steps I did and didn't enable it:
cd…
David Pearson
- 83
- 13
0
votes
2 answers
SQL Server 32-bit easysoft IB6 odbc SSIS package failing with validation error: codes 0x80004005 and 0xC0014009 when run by a sql server agent job
I have a SSIS package on sql server 2012.
It utilizes an easysoft odbc connection to access and optima attendance controller. In my project, I have
Run64BitRuntime is false. My SQL Agent Job is also set for 32 bit run time.
I use and SSIS proxy…
Noah
- 9
- 8
0
votes
2 answers
can't connect to interbase using VB.NET
i'm pretty new in VB.NET.
i'm trying to connect INTERBASE database (local) and get an error:
I've tried many things and nothing helped.
can't figure out what am I doing wrong or missed
Imports FirebirdSql
Public Class Form1
Private Sub…
ohade
- 161
- 9
0
votes
1 answer
SqlDependency interbase c#
I have a problem with interbase database and sqldependency c#. I want to detect changes in database.
When I run code:
public Form1()
{
InitializeComponent();
DbConnection c = new TAdoDbxInterBaseConnection();
…
user3455769
- 49
- 1
- 7
0
votes
1 answer
Firebird SQL access parameter by name in stored procedure
Is there a way to access an output parameter by name in a Firebird (v1.5) stored procedure? The result fields should be the month of a specified year and it would be easier if I don't have to copy my code 12 times.
Here is an example (the final code…
tcxbalage
- 696
- 1
- 10
- 30
0
votes
0 answers
PHP-Interbase : Product Interbase is Not Licensed
I have a services create with PHP PDO for Data Transfer from Fingerscan Machine that uses Ms.Access (.MDB) to Internal Application that uses Interbase 2009 (.BI)
Currently the services are running well and getting data every 3 minutes.
But i have…
Hadi Human
- 1
- 2
0
votes
1 answer
Export IBConsole settings (interbase)
How can I export or extract IBConsole settings? I only need the servers I have added and their corresponding Interbase databases that I have added under each one. It is the same server/computer.
The only difference for me is that I have made a new…
goamn
- 1,939
- 2
- 23
- 39
0
votes
2 answers
Can't get PHP rest server post method to update database
I am creating an android app with a php Rest server with firebird database. I can get information from the database via json with php server but I can't update anything. Here is my code.
public function update_user_info (){
$fname =…
