369 questions
2
votes
1
answer
274
views
Embarcadero InterBase 2020 Server Edition Update 6 views with more than 2 UNION ALL Select Statements Fails
I downloaded the latest Interbase from here https://altd.embarcadero.com/download/interbase/2020/latest/InterBase_2020_Windows.zip and used the trial version.
Upon installation, either as 32-bit or as ...
- 23
0
votes
1
answer
216
views
Failure when connecting to a LAN UNC path located Interbase database, using IBLite
I'm writing a little POC console IBLite application for Windows, using Delphi and the FireDAC components
Here is a code that works without error:
lDACConnection := TFDConnection.Create(nil);
...
- 419
0
votes
0
answers
211
views
Delphi app won't initialize IBX components on Wine (Ubuntu)
Trying to get my Delphi application to run on Wine but it crashes initializing the IBX (InterBase Express) components. The call stack indicates the crash happens in TMBCSEncoding.Create with the error:...
- 825
0
votes
1
answer
72
views
command SHOW SYSTEM TABLES generate an error message
Got an error message when trying to view a list of system tables on Interbase 2020 server with SHOW SYSTEM TABLES command.
Trying to view a list of system tables on Intebase 2020 server by using ...
1
vote
1
answer
197
views
How to configure access to remote Interbase Database in emsserver.ini for Rad Server
I have searched and I found this question: Hosting RAD Server in IIS. EMS license not found
which is the error I am receiving. I have tried the solutions listed there, but I am still receiving the ...
- 77
2
votes
1
answer
167
views
InterBase find these character (Code 13: Carriage Return (CR) Code 10: Line Feed (LF) ) in database
I am using InterBase 2007 to connect and update information in a database. I am importing data from a SQL Server database, while working on InterBase database.gdb file using Delphi in a DBgrid
I am ...
- 41
0
votes
0
answers
179
views
Problem with threads in an MDI application: application waits when thread is executing
Over the past 15 years, I have been writing and maintaining an MDI application written in Delphi 7 that accesses a database. The program runs fine and I have no problems (normally) in adding or ...
- 6,497
0
votes
0
answers
56
views
Scaffold Database Context Error "Object cannot be cast from DBNull to other type"
I am using this command in the Package Manager Console:
Scaffold-DbContext "data source=SOURCENAME;initial catalog=INTERBASE_DB;user id=username;password=password" InterBaseSQL....
- 1
0
votes
1
answer
167
views
Entity Framework Core Interbase -quotation marks issue
I am facing an issue with Interbase connectivity using Entity Framework Core, following the guidelines provided in this documentation:
https://docwiki.embarcadero.com/InterBase/2020/en/...
- 137
2
votes
0
answers
246
views
Migrating from BDE to FireDac: Strange FireDac behaviour with Interbase and automatic transactions
The isolated representation of the behavior is as follows:
I have created a project with Delphi 11.3 and use FireDac components to access an Interbase database. All settings except the connection ...
1
vote
1
answer
753
views
Cannot open gbk file - is it Firebird or Interbase?
We have a .gbk file that we are trying to restore to a database, in order to convert it to Postgres, but we can’t figure out the ODS or even if it is actually an Interbase file, and not a Firebird ...
- 182
0
votes
0
answers
368
views
Unable to connect to Interbase 2020 Database with PHP 8.2
We recently installed Interbase Server 2020 on Windows Server 2019
with Apache Server 2.4.57 (Win64) OpenSSL/3.1.2 PHP/8.2.10
I am able to connect to the Interbase SQL Database remotely with ...
0
votes
1
answer
247
views
FireDAC database unavailable when trying to connect
When attempting to make a connection (named MyConnection) on the fly with Interbase server I get the message unavailable database.
Instead, it works fine if I assign a previosuly declared ...
- 689
0
votes
1
answer
157
views
Testing for existence of a row and insert it if not present in InterBase
I am looking for a way to insert rows into an InterBase table if they do not already exist in the table. I cannot guarantee that the InterBase table is not empty to begin with.
In SQL Server, I could ...
- 1,137
0
votes
1
answer
97
views
Error 104 after creating domain in Interbase 2020 script
I am a beginner with Interbase (always used Advantage and SQL Server) and I am now running into a problem that is probably very easy to fix, but I'm just not seeing it (nor can I find a usable hint in ...
- 140