firebird Questions
6
Solved
I'm trying to connect to Firebird database using Spring Data JDBC and Spring Boot.
I've created a simple app using Spring Tools. Spring Data JDBC doesn't recognize the dialect. I believe the proble...
Sukin asked 17/5, 2020 at 12:5
3
Solved
I am extending the data layer of an existing application to work with Firebird 2.5, in addition to SQL Server and SQLite, but I have hit a stumbling block.
I have a field called TimeStamp which sto...
Smithereens asked 26/11, 2009 at 0:10
4
Solved
I'm currently working on modifying a Firebird v. 1.5 database.
The database structure will be modified running queries from a delphi application using interbase components, the problem I'm facing ...
Tachylyte asked 13/12, 2011 at 9:40
2
Solved
I'm very new to WPF and the EF, and I'm trying to display some data from a table in a datagrid. I've got the entity model pulled from an existing database and simple operations seem to work (gettin...
Thapsus asked 12/11, 2010 at 19:4
2
Solved
I have a Firebird 2.0 database running on a remote Windows XP PC.
Using the ADO.net connection provider, I configure the connection as follows:
Dim x As New FirebirdSql.Data.FirebirdClient.FbConne...
2
Solved
I'm trying to open a .fdb (Firebird) database using FlameRobin but it is giving me the following error message:
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database_f...
Chimborazo asked 26/4, 2017 at 19:36
7
I have installed Firebird 2.1 on windows Xp and using firebirdsql.jdbc-2.1.6 driver to connect with java. Code:
Class.forName("org.firebirdsql.jdbc.FBDriver");
connection = DriverManager.getConn...
Teleprinter asked 6/8, 2010 at 13:28
1
I'm not able to solve the problem with the version of Jaybird's libs package: jaybird-jdk17:3.0.10 where the antlr4-runtime:4.7 is conflicting with the hibernate-core6.1.5Final lib where there is a...
Antifederalist asked 19/12, 2022 at 18:37
7
Solved
Using Firebird, I want to combine the results of two queries using UNION ALL, then sort the resulting output on a given column.
(select C1, C2, C3 from T1)
union all
(select C1, C2, C3 from T2)
or...
Ritchey asked 9/12, 2008 at 21:0
5
I tried to get the row number using ROW_NUMBER() but it shows the following error:
can't format message 13:896 -- message file C:\WINDOWS\firebird.msg
not found. Dynamic SQL Error. SQL error co...
3
Solved
So I've got a couple of Firebird databases I need to convert. I've managed to connect to them using python code and the kinterbasdb library, but I can't find a way to get a list of all the tables i...
Singsong asked 13/2, 2014 at 21:12
3
Is there any way to capture SQL queries transmitted by old application
created in Delphi/C++Builder + Firebird?
I don't have source code of that client app or access to (remote) database server.
4
Solved
I'm trying to connect to a remote Firebird database "test" (alias already added). It is not an embedded server, and is installed on VM with IP 192.168.1.147.
Here is my connection string:
User=...
Warram asked 11/3, 2014 at 22:37
8
Solved
I need to get date, which was 30 (later I will use also 90 or 18O) days before first day of current (and previous) month. I wrote this, but I think it's unnecessarily complicated, so I come here fo...
2
Solved
How to check in which server mode (e.g. SuperClassic or Superserver) a Firebird database is running?
The latest Firebird 2.5.x database can run in either Classic, SuperClassic, or SuperServer mode. How can I check in which of these modes an installed database is running?
Aitch asked 6/3, 2013 at 11:15
2
Solved
i have a question about Firebird Client and Server versions. I know that the Database-File have to match the Firebird Server due to ODS Changes. i.e. Firebird recommends to Backup/Restore the Datab...
Propinquity asked 27/9, 2013 at 11:29
3
Solved
How do you get a list of the column names in an specific table?
ie.
Firebird table:
| name | id | phone_number |
get list like this:
columnList = ['name', 'id', 'phone_number']
Ivie asked 8/10, 2013 at 21:25
2
Solved
I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do:
SELECT * FROM customers WHERE customerid = 1234;
...
Seidel asked 10/10, 2013 at 14:0
4
Solved
I have a table with a primary key already defined in it. I would like to add a column to it which must also be part of the primary key. How can that be done?
Id asked 6/12, 2015 at 7:5
3
Solved
Try code below, but cause exception - SQLSTATE[HY000] [335544421] connection rejected by remote interface:
try {
$dbh = new PDO("firebird:dbname=localhost/3050:empty", "SYSDBA", "masterkey");
$d...
Sales asked 22/5, 2015 at 7:10
2
Solved
I'm trying to setup a local firebird instance to test against but am unable to connect to it with even ISQL. I have tried to following by following the quick start guide here:
CONNECT ..\examples\...
Churning asked 17/3, 2014 at 17:16
2
Solved
I am trying to find a way to quickly load a lot of data into database and one suggested to use Firebird External Tables, I would like know more about this method, I've tried searching online but I'...
Flagman asked 27/8, 2014 at 7:7
1
I have a view called VW_PURCHASE_ORDER_LIST. It has about 200,000 records total.
It takes 16ms to run the query:
select first 128 * from VW_PURCHASE_ORDER_LIST
However when i use the order by ...
Pammie asked 4/1, 2015 at 3:33
1
Solved
Newbie in SQL and development in general, I have a table (COUNTRIES) with fields (INDEX, NAME, POPULATION, AREA)
Usually i add a client side (Delphi) Calculated field (DENSITY) and OnCalcField :
CO...
Navada asked 30/9, 2020 at 23:54
12
Solved
I need to import a csv file into Firebird and I've spent a couple of hours trying out some tools and none fit my needs.
The main problem is that all the tools I've been trying like EMS Data Import...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.