Stack Overflow
Stack Overflow

Questions tagged [firebird-3.0]

For questions specific to Firebird 3.0. It is advisable to also tag with firebird.

Firebird 3.0 is the latest release of the Firebird database server.

Notable new features

  • Unified executable
  • Improved SMP support for SuperServer
  • Encrypted wire protocol
  • Per-database configuration
  • Multiple security databases
  • Improved SQL user management
  • BOOLEAN data type
  • IDENTITY support
  • PSQL packages
  • PSQL functions
  • DDL triggers
  • SQL Window (or analytical) functions

Resources

See also

174 questions
0
votes
1 answer

Direct connection to Firebird with IBDac/UniDac from Android using Delphi

I'm trying to connect to a REMOTE Firebird Database from Android using Delphi and IBDac. It says that cannot find libfbclient.so.3.0.2 library. I put it in the deploy to all library paths and nothing. If I remove the library it doesn't connect…
Fon
  • 33
  • 8
0
votes
1 answer

Error trying to connect a firebird database with ODBC or C# application

I'm trying to connect my c# application in a Firebird database. Using the user and password I got works on firebird sql tool. But when I go to my c# app, I got an error. So I went to the ODBC drivers, trying to connect and I got the same…
Leandro De Mello Fagundes
  • 474
  • 1
  • 7
  • 31
0
votes
1 answer

Problems generating Firebird database with script

I have a script to generate the structure of a database for Firebird and use ISQL I have problems with some of the statements I use due to the type of date TIMESTAMP, for example with the external functions: DECLARE EXTERNAL FUNCTION…
Roman345
  • 145
  • 7
0
votes
1 answer

Problems connecting firebird with .ib database (Interbase)

I have a problem and I can not connect to my .IB (Interbase) database with firebird. The case is that I have downloaded firebird 3.0 and I do not know how to connect to the interbase database I have. Do I need any more software? Normally in my…
Roman345
  • 145
  • 7
0
votes
1 answer

Tutorial on Firebird 3.0 UDFs / External Functions

Just wanted to know if anyone knows of a tutorial on how to create a udf specifically for FB3 or if the process is pretty much the same as FB2.5. I've been looking online but only can find details for FB2 and I wanted to make sure i wasn't missing…
CSharpNewb
  • 141
  • 1
  • 14
0
votes
1 answer

Firebird calc between date skip weekend

I want to convert this sql code to firebird sql for find working days between two dates: CREATE FUNCTION [dbo].fn_CountWeekDays ( @fromdate Datetime, @todate Datetime ) RETURNS TABLE AS RETURN ( SELECT (DATEDIFF(dd, @fromdate, @todate) +…
David
  • 11
  • 5
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
1 answer

connect to firebird via ODBC: x32 vs x64

I've installed on Win10 x64 latest firebird x64 3.0 and created database under it. I've also installed both x32 and x64 ODBC drivers. Now i've created System DSN connection via x64 driver against fbclient.dll and successfully tested it. After that…
icegood
  • 44
  • 3
0
votes
1 answer

How to filter records of people who have a birthday between two dates based on their birthday using Firebird?

I would like to query in my database people who have a birthday between a start and end date. The field is stored with Date in the database, so it would need to select the anniversary disregarding the year. I tried to use functions like extract, to…
Marcoscdoni
  • 893
  • 1
  • 7
  • 26
0
votes
3 answers

How to use the return value from a stored procedure as a default value in a column?

I need to use the return value from an stored procedure in firebird 3.0 as the default value in multiple columns. My Procedure: CREATE OR ALTER PROCEDURE CURRENTTIME returns ( stime char(12)) as begin sTime = (SELECT…
Aoki.Miku
  • 27
  • 8
0
votes
3 answers

two counts based on field value

I have a table table1 that has a field1 has values from 1 to 5 I need to get the count of records when field1 = 1 and the count of remaining records when field1 <> 1. so I could do it like this: select count(*) from table1 group by field1 =…
William
  • 3,692
  • 10
  • 50
  • 101
0
votes
0 answers

Firebird 3, ADO.NET data provider 5.0.5, memory gradually growing

After changing the firebird 2.1 to 3.0 (SuperServer) is gradually rise much memory up to a maximum of hardware (20GB) for about one month. Firebird server has 6 database with a total size of about 30 gigabytes. Client applications are .NET WinForm…
Majkl
  • 767
  • 1
  • 8
  • 24
0
votes
2 answers

WCF REST service and client notifications

Here is my situation: I have a Firebird database, a WCF REST service (.NET 4.5) and a Windows Mobile 6 client. What I need is: on Firebirds post event, WCF REST should notify the client. I know that WCF has duplex communication when used as SOAP…
Aleksandar
  • 246
  • 1
  • 10
0
votes
0 answers

Firebird 3 do Firebird 2.5 Free-Adhoc UDFs work?

I am currently running an application on Firebird 1.54 and working on an Upgrade to 2.56. As Firebird 3 is released, I would like to directly go to this version but I need the great Free-AdHoc-UDFs as users also have custom statements in their…
MichaSchumann
  • 1,111
  • 11
  • 29
1 2 3
…
11
12