Stack Overflow
Stack Overflow

Questions tagged [flamerobin]

FlameRobin is a database administration tool for Firebird RDBMS

32 questions
0
votes
0 answers

SQL Category - Min value selection with multiple criteria

I have a table such as the below, called mytable Customer LocationStore DistanceCustomerLocationStore 1 London 0.5 1 Birmingham 0.8 2 London 0.3 2 Birmingham 0.9 From this table I want to select for…
GuusHag
  • 1
0
votes
0 answers

How do I connect to Firebird through Visual Studio 2019 and C#

I am struggling to connect to a Firebird database in C# through Visual Studio 2019 I was able to connect to the database through FlameRobin, but I don't really know how to connect through Visual Studio 2019 and C#. Please show me all the commands I…
buddy
  • 3
  • 3
0
votes
0 answers

Error when creat new database in FlameRobin, I/O error during "open" operation for files

I'm trying to creat a new database in FlameRobin with Window OS, but when i creat, FlameRobin show error: *** IBPP::SQLException *** Context: Database:Create Message: isc_dsql_execute_immediate failed SQL Message : -902 Unsuccessful execution caused…
Minh Lee
  • 1
  • 1
0
votes
1 answer

Firebird permission denied when connecing with FlameRobin but is okay with isql

I'm trying to connect to employee.fdb in Firebird3.0 (localhost) using FlameRobin 0.9.3 on a Ubuntu OS. The connection to Firebird using isql has no issues. I can create users, roles, etc all from the terminal. However, when I attempt to make a…
DanZ
  • 361
  • 1
  • 8
0
votes
0 answers

Problem of database connection to localhost with FlameRobin/Firebird

I'm coming here because I wanted to test some things with Firebird. Indeed, I need to create a database with LibreOffice Base, which now comes with Firebird-3: I would like to not have an embedded database in LibreOffice Base, but better connect LO…
greb
  • 11
  • 1
  • 2
0
votes
2 answers

How to query between date and specific time range

I need help on a query between date and specific time range. For example, a user entering the building from 1 Jan 2019 until 1 April 2019 and only from 7 PM until 10 PM for that date. the database stored EVENTDATE as 01.01.2019, 07:15:01.000 I have…
Shazwan Shukor
  • 1
  • 1
0
votes
1 answer

FlameRobin on-disk structure support

I use Firebird 2.1 on Windows 7 Pro. I try to connect database with Flamerobin 0.9.2. It has worked before, but now I get the following error message from every database I try to connect to. IBPP::SQLException Context: Database::Connect Message:…
Jukka Sariola
  • 1
  • 3
0
votes
1 answer

"isc_attach_database failed" error FlameRobin for connect Firebird database

I'm trying setup Firebird 2.5 with FlameRobin 0.9.3, installed on Windows 10 64bit. The .fdb files are on the same disk of the Firebird machine and the FlameRobin program. I'm trying to connect EMPLOYEE.FDB file with FlameRobin getting this error.…
zokanzi
  • 103
  • 1
  • 11
0
votes
1 answer

Connecting to Firebird 3

I have installed Firebird 3.0.1 on a PC and on a VM client. I installed Flamerobin on both to test the connection. I can connect to localhost on both PC and VM using Flamerobin, so I assume the Firebird server is running on both and Flamerobin is…
Tony
  • 48
  • 9
0
votes
0 answers

connecting to firebird server from client

I have a problem connecting to Firebird 3 running on a Windows Server 2012 from a Windows 10 client. Firebird is running on the server and my application is ok and accesses the Firebird database on the server. However it cannot connect to the backup…
Tony
  • 48
  • 9
0
votes
0 answers

FlameRobin: Not Responding While Establishing Connection

I have installed Firebird-2.5.6.27020_0x64 and Firebird_ODBC_2.0.4.155_x64 in a Windows 10 64 bit computer system architecture. I have set-up also ODBC configuration in ODBC Data Source Administrator (64 bit) and test connection was successful. In…
alyssaeliyah
  • 1,684
  • 3
  • 24
  • 62
0
votes
0 answers

Firebird select statement gives SQLSTATE = 42S02

I've made a very simple database and am trying select * from klant; I've verified the table exists, and last week was able to see data in it. Today however I keep getting Statement failed, SQLSTATE = 42S02 Dynamic SQL Error -SQL error code =…
Sonja
  • 61
  • 2
  • 8
0
votes
1 answer

Getting an error of 'Token Unknown' while Execute Stored Procedures

I'm new in learning stored procedures in SQL. I want to create a stored procedure for inserting values from automatic data by calculation. Table Attendance: EMPL_KODE |EMPL_NAME |DATE_IN |TIME_IN |TIME_OUT|TIME_IN |TIME_OUT 001 | Michel …
Andiastika Intan Pratiwi Hasan
  • 79
  • 11
0
votes
1 answer

Update statement with CTE (Firebird 2.1)

I have following statement with which I would like to update table based on some of its columns entry. I use Firebird 2.1 and documentation shows that update can be used with CTEs but my flamerobin stubbornly insists that update statement is not…
Sonya Blade
  • 279
  • 4
  • 21
0
votes
0 answers

Filter certain SQL data formatted in one column into a new column

Before I begin I found this to be most relevant with the research I have done. How to split the data from one column into separate columns using the contents of another column in SQL Attached are pictures of my progress so far. How can I display…
Matt Wilde
  • 271
  • 2
  • 14
1
2
3