On 2017-03-08 11:30, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> Thanks for your answer,
>
> perhaps problem is in jaybird-3.0.0-beta-3 used to connection to fb 3.
>
> My fb25 client is jaybird-2.2.12 and works fine.
When comparing performance of two systems, it is better
On 2017-03-01 09:59, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
> 01.03.2017 11:58, jonatan.laurit...@yahoo.dk wrote:
>
>> OK, I have working Firebird 3.0.1 installation and I have copied
>> security3.fdb from the broken Firebird installation and now I am also
>> receiv
On 2017-03-01 11:41, jonatan.laurit...@yahoo.dk [firebird-support]
wrote:
> Solution found - I had to use the "create user" command with the
> "using" clause:
> SQL> create user SYSDBA password 'masterkey' using plugin Srp;
>
> My firebird.cong indicated that Legacy_Auth is the first (default)
>
On 2017-03-01 09:34, jonatan.laurit...@yahoo.dk [firebird-support]
wrote:
> Hi!
>
> Our client has Firebird 3.0 super server installation which has the
> following behaviour:
> - Client software (e.g. Flamerobin) can establish connection using
> Firebird 2.x fbclient.dll
> - When client software
On 26-2-2017 17:46, andreasmzel...@yahoo.de [firebird-support] wrote:
> I originally tried to post to this like I would to a normal mailing list.
> I've never seen an open source project that required me to have a yahoo
> account ;) I have a firebird-related problem however.
You don't need an Ya
On 2017-02-21 17:32, Nick Upson n...@telensa.com [firebird-support] wrote:
> Hi
>
> The problem I'm trying to solve is users leaving inactive db_workbench
> sessions attached to a database while other work is going on by other
> processes, causing a large OIT gap and the consequent problems. The
>
On 14-2-2017 15:48, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 14.02.2017 14:15, 'Stef' s...@autotech.co.za [firebird-support] wrote:
>> Any suggestions on my DB design and query to display the values in matrix
>> (pivot) format?
>
>Simple client-side code can show you
On 10-2-2017 08:34, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> IBExpert uses two settings for database charsets:
> - Charset (apparently Database related) and
> - Font Character Set (apparently Client related)
>
> As I understand then Charset is the same setting as lc_ctype=UNICODE_FSS
Please send your question to the Firebird-java list instead. If you do that,
make sure to include more information:
- the code you use
- the version of Jaybird
- the version of Firebird
- the full stacktrace of the exception
Mark
- Bericht beantwoorden -
Van: "Guilherme Henrique guilhe..
On 12-1-2017 21:44, startx252...@yahoo.fr [firebird-support] wrote:
> What is the way to make a join from 2 tables in two respective database
> (in same server) ?
>
> ex :
>
> Db1
> TableA
>
>
> Db2
> TableB
>
>
> how can i make somethink like this :
>
> SELECT tA.MATRICRS, tB.name, tB.age
> FROM T
On 12-1-2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> hi All,
>
> I did a procedure that recompute all identity fields of a list with
> items separate by comma, but I need a method to check if table.field is
> identity or not. It´s a procedure of mainnitence.
For Firebird
On 12-1-2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Sorry if this is a really basic question, but some time spent searching
> has failed to find for me the definitive detailed documentation on
> exactly how Firebird handles time zones (I'm particularly interested, to
> start w
On 11-1-2017 12:00, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> Colums identity in FB3, I love it!
>
> But there is one thing missing.
>
> I would like to know, if exists a verb to supply identity value to not
> assume a literal value. Ex:
>
> create table test (
>id integer gene
On 11-1-2017 10:35, startx252...@yahoo.fr [firebird-support] wrote:
>
>
> i mean taht i have no result (it's empty) and i am sure my string existe
> in one table
That is probably because you are using
' WHERE '||:DANSCOLONNE||' = ?'
instead of
' WHERE '||:DANSCOLONNE||' = ''%'' || ? || ''%'''
On 11-1-2017 10:02, startx252...@yahoo.fr [firebird-support] wrote:
> i have this code but something gone wrong
Please be more specific than "something gone wrong"
Mark
--
Mark Rotteveel
On 10-1-2017 18:10, startx252...@yahoo.fr [firebird-support] wrote:
> I am looking for a procedure or a function to find a stirng in my database
>
> I have a DB with 200 tables and want to find a specific string (record)
> in a my DB
>
> I don't know the name of table / field.
There are no ready-m
On 9-1-2017 18:08, Leandro Melo de Sales leandromsa...@gmail.com
[firebird-support] wrote:
> Scenario: My customer has a Linux CentOS 5.7 with Firebird TCP/IP server
> version LI-V2.5.2.26540 Firebird 2.5. I want to update his Linux server
> to Ubuntu latest version. My customer uses a third-party
On 2016-12-13 22:05, tvd...@ymail.com [firebird-support] wrote:
> If I have a table like this:
>
> CREATE TABLE EXAMPLE (
>
> E_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
>
> );
>
> How do I add a record to it, getting an automatically assigned ID?
>
> For example,
On 2016-12-09 12:35, Luigi Siciliano luigi...@tiscalinet.it
[firebird-support] wrote:
> Hallo,
>
>what is more performant from subject?
Could you please put all pertinent information of your question in the
body, and not only in the subject. It makes questions a lot easier to
read (especia
On 6-12-2016 17:57, 'Israel Pinheiro' israel.ip...@gmail.com
[firebird-support] wrote:
>
>
> Error in procedure. Please!
Please include the full error in the body of your message; don't use the
subject to communicate pertinent information (especially not if it seems
to be incomplete).
Also do
On 6-12-2016 09:23, Dmitry Yemanov dim...@users.sourceforge.net
[firebird-support] wrote:
> Check RDB$GENERATOR_INCREMENT inside RDB$GENERATORS. NEXT VALUE FOR uses
> the increment stored inside the system table.
I noticed something interesting, when restoring a Firebird 2.5 database
to Firebird
On 6-12-2016 03:59, trsk...@yahoo.com [firebird-support] wrote:
> During project development/testing or database maintenance, such as
> backup/restore, mostly, there is only 1 connection to FB Server.
>
> I have 6 core processors and during those process, cpu's utilization is
> about 16%. I knew,
On 2016-11-25 15:29, Lester Caine les...@lsces.co.uk [firebird-support]
wrote:
> On 25/11/16 13:56, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>> On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk
>> [firebird-support]
>> wrote:
>>> >
On 2016-11-25 12:40, Lester Caine les...@lsces.co.uk [firebird-support]
wrote:
> Nothing to do with Firebird but can anybody explain why the numbers in
> 'SELECT FIRST 102121121121212 SKIP 3574239239242420' would be a problem
> in MySQL or is it some other vulnerability the original sQL injection
On 24-11-2016 11:02, Si Carter s1car...@gmail.com [firebird-support] wrote:
> Using FB3 on windows I get the error message:
>
> String literal with 30465 characters exceeds the maximum length of 16383
> characters for the UTF8 character set
>
> As a test I created a new db (UTF8) with the following
Where do you live (or what is your current timezone)? It might be explained by
timezone changes, etc. That happened a lot before at the end of the 19th and
stay of the 20th century.
Mark
- Bericht beantwoorden -
Van: "Steve White steve.wh...@health.telstra.com [firebird-support]"
Aan:
Firebird 3 does not support old ODS versions. You will need to backup with
Firebird 2.5 and then restore under Firebird 3.
Mark
- Bericht beantwoorden -
Van: "'Joje' j...@codework-solutions.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Unable to upgrade database to firebir
On 17-10-2016 12:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> No there isn't, although you could build something like that
> yourself in
> Firebird 3 with PSQL functions.
>
> Mark
> --
> Mark Rotteveel
>
> Hi Mark,
>
> yes, PSQL function can be g
On 17-10-2016 10:10, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> i know
> Cast('XXX' AS Integer)
> but is there
> try_Cast('XXX' AS Integer)
> like in MSSQL?
> you know if something can not by converted then return null.
No there isn't, although you could build something
On 13-10-2016 11:43, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
> 64-bit or 32-bit - does not matter. You should be able to open that
> v.1.5 database with either Fb 1.5 or 2.0.6. You would probably get
> some errors trying to open it in Fb 2.1 or 2.5. That has nothing to
> do
On 2016-10-06 14:26, abdi.m...@inergi.ca [firebird-support] wrote:
> Hi There, We are updating our operating system from windows 7 to
> Windows 10 64 bit and want to know the compatibility for the
> application below: * Firebird 3.0
Firebird 3 and its client library are compatible with Windows 10.
You should post this to the Firebird-devel list instead.
Mark
- Bericht beantwoorden -
Van: "'Mueller, Roland (GE87)' roland.muel...@honeywell.com [firebird-support]"
Aan: "firebird-support@yahoogroups.com"
Onderwerp: [firebird-support] Compile Errors Firebird 3.0.1 Win32
Datum: do, okt
Could you please stop posting responses like "Perfect", "Thanks" and
"Great, Thanks!", "Hello", etc. It is unnecessary filler that doesn't
contribute anything to the mailing list
Over the last 3 months you have only posted response like that to the
list (and no other real contributions).
Mark
Which version of Firebird are you using? And show the code of your stored
procedure.
Mark
- Bericht beantwoorden -
Van: "'Joje' j...@codework-solutions.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Unable to execute large text inside stored
procedures.
Datum: do, sep. 29,
On 23-9-2016 06:00, trsk...@yahoo.com [firebird-support] wrote:
> I have set WireCrypt to Disabled/Enabled, the error changed to :
> Error occurred during login, please check server firebird.log for details
>
> When I read on firebird.log, here are the error :
> Authentication error No matching p
On 26-9-2016 22:56, Carlos Mazariegos carlosemazarieg...@gmail.com
[firebird-support] wrote:
> I understand firebird is not equal interbase,
> but the problem is that the Firewall Palo Alto,
> Palo Alto detected the vulnerability with my application, which is built
> with:
It didn't detect the vu
On 2016-09-22 11:01, trsk...@yahoo.com [firebird-support] wrote:
> Hi guys,
>
> Anyone here able to connect to FB 3.01 with JDBC 2.x?
>
> I have tried with jaybird-full-2.2.11 & have adding these lines to
> firebird.conf
> 1) UserManager = Srp, Legacy_UserManager
> 2) AuthClient = Srp, Win_Sspi,
You either need to generate the necessary metadata yourself, but then you
either have to guess, or have the user provide the type.
You can't use openCursor as insert ... returning doesn't have a cursor; just
like an executable procedure it has a single result that is returned on execute.
Mark
-
On 11-9-2016 09:11, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> Gbak and nbackup are different tools that work in a different way. Gbak
> works through a Firebird server (real or embedded), while nbackup works
> with the physical backup file.
That should have been
On 10-9-2016 23:34, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I am getting this error while running nbackup:
>
> "nbackup needs local access to database file"
>
> The nbackup sentence is:
>
> Nbackup.exe -user SYSDBA -pas HereMyPass -B 0
> localhost:MyDB_FB3.fdbC:\temp\MyDB_
On 10-9-2016 22:11, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I am running both gbak.exe and nbackup.exe on an FB3 server with Windows
> 2012 R2 64 bits, 24 processor, 192 GB ram, the nbackup.exe level zero is
> much faster than the gbak.exe (does not make any sense, it should take
You need to use comment on:
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl-comment.html
Mark
- Bericht beantwoorden -
Van: "gregorkob...@yahoo.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Change Description
Datum: do, s
Sounds like the user running gbak has insufficient rights to create a file in
the target folder.
Mark
- Bericht beantwoorden -
Van: "Nick Upson n...@telensa.com [firebird-support]"
Aan: "firebird support"
Onderwerp: [firebird-support] gbak error
Datum: wo, aug. 31, 2016 18:41
its poss
On 26-8-2016 22:27, Jardar Maatje jardar.maa...@nds.nortek.no
[firebird-support] wrote:
> We are running fb 2.5.6 and are getting the INET erorr regularily.
> The error has been there before as well with earlier versions of fb.
>
> Is this something I should be conserned about and what can I do ab
The rows clause does work on delete (and update) statements.
Mark
- Bericht beantwoorden -
Van: "'livius' liviusliv...@poczta.onet.pl [firebird-support]"
Aan:
Onderwerp: [firebird-support] Delete causes server to hang
Datum: vr, aug. 26, 2016 19:30
Hi,
your statement is incorrect
sele
Which Firebird version are you using, and do you use Super, Classic or
SuperClassic?
Mark
- Bericht beantwoorden -
Van: "kragh.tho...@yahoo.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Delete causes server to hang
Datum: wo, aug. 24, 2016 22:00
HeyOn my website i have a
On 28-7-2016 18:38, Carlos Mazariegos carlos.mazarie...@umg.edu.gt
[firebird-support] wrote:
> Exist any ide or manager web for administration firebird from 2.1 to 3.0
> version?
Yes: https://github.com/mariuz/firebirdwebadmin
--
Mark Rotteveel
On 28-7-2016 04:49, 'hz.yb' hz...@foxmail.com [firebird-support] wrote:
>
>
> i want to get rownum?how to select?thanks
>
> table:
> CREATE TABLE PZ (
> ID INTEGER NOT NULL,
> RQ TIMESTAMP NOT NULL,
> JE DECIMAL(18,2),
> /* Keys */
> PRIMARY KEY (ID)
> );
>
> data:
> INSERT INTO PZ (ID
Can you create a bug on http://tracker.firebirdsql.org/browse/CORE
Mark
On 27-7-2016 08:28, ehmmm.fireb...@seznam.cz [firebird-support] wrote:
>
>
> Adding some notes:
>
> Examples stat3.e and stat5.e from /opt/firebird/examples/stat/ don't
> work, while stat2.e works.
> I'm getting the same -901
Given you are using 2.1.5, it is entirely possible you are experiencing a bug
that crashed the server that was fixed in a more recent release.
Mark
- Bericht beantwoorden -
Van: "'maciej...@gmail.com' maciej...@gmail.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Firebird -
I already covered that one in my reply to your previous question. The error
means connection refused, which usually means that the client is trying to
connect to a Firebird insurance that isn't running (or to the wrong port).
Mark
- Bericht beantwoorden -
Van: "'maciej...@gmail.com' maci
On 19-7-2016 06:25, 'maciej...@gmail.com' maciej...@gmail.com
[firebird-support] wrote:
> I have a question about the information in the log Firebird (version
> Firebird: 2.1.5.18496).). The server was installed as SuperServer. The
> problem occurs in Windows XP SP3.
2.1.5 is not the latest 2.1;
Of course there is: just call isc_prepare and never commit or rollback.
Mark
- Bericht beantwoorden -
Van: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] Transaction in limbo
Datum: di, jul. 19, 2016 12:16
19.07.2016 12:14, michael.vilhelm
On 19-7-2016 12:14, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> As I read about 2 phase commits, its about 2 databases. We do not use
> more than one
Not really, two-phase commits can also be applied to a single database,
single connection.
It just means that instead of doing an i
On 19-7-2016 09:32, michael.vilhelm...@microcom.dk [firebird-support] wrote:
> I have a database, which have had to instances where there have been
> Transactions in limbo.
> I know how to fix this.
>
> I am on the other hand unsure why they appear.
> What can cause this?
> What should/could I chec
On 15-7-2016 09:42, Norbert Saint Georges n...@tetrasys.eu
[firebird-support] wrote:
> -CHARACTER SET ISO8859_1 is not installed
> X-Newsreader: MesNews/1.08.05.00
>
> I try to connect embedded mode via master interface with the code
> (Pascal).
> <--
> master := fb_get_master_interf
On 28-6-2016 20:03, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 28.06.2016 19:46, Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
> wrote:
>> I've never heard of such a file, does anyone have an idea what it could be?
>
>I would bet on a d
I just came across this question on Stackoverflow:
http://stackoverflow.com/questions/38070209/what-is-this-file-fdr-in-the-directory-firebird
The question is: "what is this file .fdr in the directory Firebird . For
me, it weighs 16 gb. Is this a transaction log ? Or how to reduce it ?"
I've ne
On 2016-06-23 22:06, Gabriel Frones grfro...@gmail.com
[firebird-support] wrote:
> Eu preciso de informações sobre suas tabelas (essas envolvidas) e
> que tipo de relatório essa view fornece pra te dar uma query que
> funcione. Mas uma dica geral a principio é: isole o problema.
> Primeiro constru
On 15-6-2016 17:55, chen hsu chen...@outlook.com [firebird-support] wrote:
> Thanks, Helen. Please see my replies inline.
>
> I am sure it is not 3.0 specific, 2.5 is the same. and the main issue is
> scalability, sequential transaction performance is actually pretty good,
> comparable to ESE store
On 2016-06-14 19:44, fabia...@itbizolutions.com.au [firebird-support]
wrote:
> My understanding from reading the documentation is:
>
> Provider = Remote means the client is on the network, excluding
> 127.0.0.1
> Provider = Loopback means the client is actually on the same OS
> instance as the FB3
Engine12 is actually the post of Firebird 3 that is the implementation of the
database server (and understands ODS12).
So it is a required part of Firebird 3.
Mark
- Bericht beantwoorden -
Van: "fabia...@itbizolutions.com.au [firebird-support]"
Aan:
Onderwerp: [firebird-support] Engin
On 7-6-2016 13:50, Virgo Pärna virgo.pa...@mail.ee [firebird-support] wrote:
> On Tue, 17 May 2016 16:43:51 +0200, robert rottermann rob...@redcor.ch
> [firebird-support] wrote:
>>
>> This is the connection string I use:
>> engine =
>> sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.1.150:30
On 2016-06-02 6:20, trsk...@yahoo.com [firebird-support] wrote:
>> What value must it have? Add a default clause to this statement. Or
> add
> > the field as nullable, populate with data and then alter to NOT
> NULL.
>
> I have tried to add field as nullable, then tried to alter to not
> null.
>
>
Sorry, I just realised I was thinking of an option that had been removed. You
need to run Firebird as SuperClassic or Classic (or do the backup through
localhost as suggested earlier.
Mark
- Bericht beantwoorden -
Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-
You need to backup through localhost, or you need to set the database in
databases.conf (or the Firebird default in Firebird.conf) to Shared.
You should have had the same problem with Firebird 2.5 if you used SuperServer.
Mark
- Bericht beantwoorden -
Van: "dondondonje...@yahoo.com [fire
On 23-5-2016 03:45, fabia...@itbizolutions.com.au [firebird-support] wrote:
> I have been trying to migrate from FB2.54 into FB 3 for a few weeks, and
> after hitting a string related error for some time i have got to the
> point where I do understand the issue, but I don't know how to solve it.
>
On 2016-05-25 8:31, josef.gschwendt...@quattro-soft.de
[firebird-support] wrote:
> Hi,
>
> what is with msvcp100.dll and msvcr100.dll?
>
> Are these files not required?
They are required if the MS Visual C 2010 runtime is not installed on
the machine. In my experience it usually is, but it might
On 20-5-2016 13:21, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> I think you have too many `/` after the port number. Try
>
> sa.create_engine('firebird+fdb://SYSDBA:thekey@10.42.1.150:3050/c:\\Users\\elvis\\Documents\\VAS.fdb')
>
> It would also be
On 17-5-2016 16:43, robert rottermann rob...@redcor.ch
[firebird-support] wrote:
> Hi there,
>
> I try to access a firebird db on windows from my ubuntu box.
> I have a gui-tool (FlameRobin), from which this works nicely. Therefore
> it is not a firewall or access problem.
>
> Now I would like to
On 17-5-2016 18:08, josef.gschwendt...@quattro-soft.de
[firebird-support] wrote:
> could please anybody tell us which files we definitely have to ship with
> our app as client for a FB3 remote server or as an FB3 embedded server?
> (minimal files required).
>
> Standard Client:
> - fbclient.dll
On 12-5-2016 20:18, liviusliv...@poczta.onet.pl [firebird-support] wrote:
> This detection is useless .
> use the latest library (FB3) and you can connect to any older servers
But that isn't really useful if you want to find out if you need to
upgrade a database.
Mark
--
Mark Rotteveel
On 11-5-2016 16:04, 'Checkmail' check_m...@satron.de [firebird-support]
wrote:
> I have already tested the new version of firebird, but I think it is not my
> part to understand everything how firebird works. MSSQL I can install in
> every version, except new functions everything works in a new ve
On 10-5-2016 16:03, 'Checkmail' check_m...@satron.de [firebird-support]
wrote:
> We had FB 2.5 CS before our migration to fb 3 SS. After this, the
> Frontend (MS-ACCESS) calls a stored procedure and sometimes the
> odbc-driver does not wait until the procedure finished and writes the
> new records
On 2016-05-12 7:37, 'Checkmail' check_m...@satron.de [firebird-support]
wrote:
> Hello again,
>
> the most funkctionality are very simply, just tables who linked to
> msaccess.
> I thought that firebird in every version can do this without any
> problems -
> how I said is this not in every case
for sort fields and returned fields
Datum: ma, mei 9, 2016 23:54
Perfect
On Monday, May 9, 2016 8:48 PM, "'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support]" wrote:
Ah. It is the exception, because ordering by column index (en order by 1, 3)
uses the index
Ah. It is the exception, because ordering by column index (en order by 1, 3)
uses the index of the column in the select list, so by definition that column
needs to be in the list.
Mark
- Bericht beantwoorden -
Van: "liviusliv...@poczta.onet.pl [firebird-support]"
Aan:
Onderwerp: [fire
On 2016-05-09 16:22, Ralf Jansen ralf.jan...@mailstore.com
[firebird-support] wrote:
> Hi,
>
> really? The groups disclaimer states „DO NOT USE THIS LIST FOR
> SUPPORT QUESTIONS REGARDING RELEASED VERSIONS.”
>
> Ralf
In my opinion, the plugin system is not documented enough and therefor
not real
On 2016-05-09 15:29, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> hi,
>
> could you explain this exception?
> And i also have not sql standard to look into and need some exact
> confirmation about this (something like Sql92 or sql2013.. say this)
I see no exception, did yo
On 2016-05-09 10:36, Ralf Jansen ralf.jan...@mailstore.com
[firebird-support] wrote:
> Hi,
>
> unfortunately, my question didn't get anything as response so I
> assume that there isn't a documentation dedicated to writing plugins.
> Let me try a more concrete question on the subject.
>
> I was rea
On 2016-05-09 11:45, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi,
>
> This is not specific to Firebird question but:
> is something in SQL standard specification about sorted fields must
> be
> also returned?
> I mean:
>
> SELECT
> [FILM_DATE,]FILM_TITLE
> FROM
> FILMS
On 2016-05-09 0:35, 'e...@emel.hu' e...@emel.hu [firebird-support]
wrote:
> I try the ordinary EF CodeFirst test with latest packages for new
> FB3.
...
> BUT: why is created a "IX_Posts_blogId" index when the
> "FK_Posts_Blogs_blogId" index created for FK?
This question is more suitable for t
On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu
[firebird-support] wrote:
> Create a firebird 3 bd in another user who is not sysdba
> and create a role called sysdba without permission
Creating a role called SYSDBA will disallow the user SYSDBA to connect
to Firebird.
> and
On 23-4-2016 11:33, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
> Hello Mark,
>
> Saturday, April 23, 2016, 6:02:00 PM, you wrote:
>
>> As far as I know even in Firebird 2.5 and earlier, settings like
>> ConnectionTimeout, TcpRemoteBufferSize and maybe some other settings
>> affect
On 22-4-2016 20:22, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
> Mark, since the OP was referring to "aliases.conf" he evidently isn't
> trying to work with Firebird 3, which doesn't have aliases.conf.
>
> In prior releases, firebird.conf is relevant locally only if the
> client i
On 2016-04-21 21:13, Helen Borrie hele...@iinet.net.au
[firebird-support] wrote:
>> DB-Application @ PC-B
> ->> fbclient.dll
> ->> Pickup Firebird Server IP/Name from firebird.conf
>
> No. Firebird.conf and aliases.conf are components of the server host,
> not of the client. Fbclient.dll is a
On 2016-04-20 8:29, michael.vilhelm...@microcom.dk [firebird-support]
wrote:
> Hi
>
> I have a testserver currently running both Firebird 2.1 and 2.5.
> I need this to support and test various situations with different
> firebird versions.
>
> Now I would like to install Firebird 3.0 manually as w
Firebird embedded still exists, but looking at the release notes, it might
require a bit more explicit coverage.
In short, you need fbclient.dll and engine12.dll (or their Linux equivalent).
There is no separate fbembed.dll anymore.
Mark
- Bericht beantwoorden -
Van: "galdari...@yahoo.c
On 2016-04-11 13:55, thetr...@yahoo.com [firebird-support] wrote:
> hi,
>
> recently we had some strange performance issues with our Firebird DB
> server.
>
> We would be very grateful if anyone can give us hints where we can
> search further.
>
> Or someone has similar experiences to share with us
On 7-4-2016 23:01, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr
[firebird-support] wrote:
> Would you be so kind to provide an example SQL which shows how to do
> primary key with a case insensitive collation?
1. Register the WIN1254_UNICODE collation (it is defined in fbintl.conf,
but not includ
On 5-4-2016 17:18, tcanfiel...@hotmail.com [firebird-support] wrote:
> I'm trying to set the exclusions for one of our servers and I see
> Firebird running.
>
> I don't have any experience with this program and I was hoping someone
> on the forum could shed some light on the needed exclusions.
>
>
On 7-4-2016 20:54, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Hello Mark.
>
> I was like you showed 192.168.0.158:C:\DIR1\BASEDIR\MYDATABASE.FDB
>
> Than I changed from FB 32 to FB 64 and it stopped working. After that,
> after that even turnning to FB 32 it doesn´t work using this stru
This is the default and expected behavior. If you want case insensitive, then
you need to create the primary key column with a case insensitive collation.
Mark
- Bericht beantwoorden -
Van: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"
Aan:
Onderwerp: [firebird-suppo
Also consider the situation with multiple rows on the other side of the join:
in that case the one side repeats as many times as there are rows
- Bericht beantwoorden -
Van: "'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]"
Aan:
Onderwerp: [firebird-suppor
16. 04. 07. 18:48 keltezéssel, 'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support] írta:
> Why wouldn't it be necessary, this is an inner join, so the joined table
> needs to be evaluated if the matches row is present.
>
> SELECT RDB$FIELD_NAME FROM VIEW1
SELECT RD
Why wouldn't it be necessary, this is an inner join, so the joined table needs
to be evaluated if the matches row is present.
Mark
- Bericht beantwoorden -
Van: "Gabor Boros gaborbo...@yahoo.com [firebird-support]"
Aan:
Onderwerp: [firebird-support] VIEW optimization
Datum: do, apr. 7,
On 2016-04-07 14:41, Hugo Eyng hugoe...@msn.com [firebird-support]
wrote:
> Hello.
>
> Thanks for answer my question.
>
> I changed the connection (Deplhi XE10 / DBX) to
> \\192.168.0.158\C:\DIR1\BASEDIR\MYDATABASE.FDB and it works.
With this change you are using a different protocol than you
On 2016-04-07 5:26, Alex Castillo acr_k...@yahoo.com [firebird-support]
wrote:
> I've no doubt this is a bug for the linux release. It should be
> filtering the string literals before doing the conversion as it does
> on Windows.
I don't think it is a bug. Firebird supports the SQL standard
ISO-
Have you checked the difference between the two Firebird.conf? You seem to be
using relative paths to connect the database; I believe that depends on the
RootDirectory setting.
Mark
- Bericht beantwoorden -
Van: "Hugo Eyng hugoe...@msn.com [firebird-support]"
Aan:
Onderwerp: [firebird
On 2016-04-04 9:08, Hasnain Najafi hasnain.naj...@boots.co.uk
[firebird-support] wrote:
> unsubscribe
>
> Regards,
>
> HARDWARE REFRESH TEAM
To unsubscribe send a mail to
firebird-support-unsubscr...@yahoogroups.com with subject: Unsubscribe
Mark
501 - 600 of 857 matches
Mail list logo