Re: [firebird-support] Help: firebird and apache Processes doesn't die

2017-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2017 16:09, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > Shouldn't page cache and firebird structures size kept in RAM be of > the same order of magnitude as databse size in the worst case ? No. -- WBR, SD. -

Re: [firebird-support] Firebird database size is becoming huge (56Gb)

2017-01-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.01.2017 16:30, Leandro Melo de Sales leandromsa...@gmail.com [firebird-support] wrote: > The database file size is huge as 56Gb. Is there any limitation of Firebird > as the size of > the database increase? No limitations at this level. 56Gb is quite small database. > any suggestion for i

Re: [firebird-support] Time zones

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote: > Can someone point me in the right direction please? Firebird does not handle time zones at all. CURRENT_TIMESTAMP and CURRENT_TIME return local time. -- WBR, SD. -

Re: [firebird-support] How to identify if field of table is identity or not?

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I need a method to check if table.field is identity or not. RTFM README.identity_columns.txt -- WBR, SD. +

Re: [firebird-support] Firebird : join table from two database

2017-01-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.01.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) ? No. -- WBR, SD. +

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 13:09, Tim Ward t...@telensa.com [firebird-support] wrote: > I just don't believe this. Can anyone make any other suggestion as to > what is going on? Is timezone on your Linux set globally or for each current user environment independently? -- WBR, SD. -

Re: [firebird-support] Re: Time zones

2017-01-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.01.2017 16:46, Tim Ward t...@telensa.com [firebird-support] wrote: > One thing I've now noticed is that running the trigger by updating a > record via isql gives the correct, Brazilian, answer. If you are running isql and connected to database in embedded mode, your current environment is

Re: [firebird-support] Syntax for system environment variables in firebird.conf

2017-01-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.01.2017 11:52, Arno Peter pe...@jam-software.com [firebird-support] wrote: > Does anyone know how to use Windows environment variables in the > firebird.conf? Currently there is no way to. -- WBR, SD. ++

Re: [firebird-support] Firebird 2.5 service turned off but client application is still working.

2017-01-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.01.2017 14:20, brucedickin...@wp.pl [firebird-support] wrote: > Is this a by design behaviour? Yes. Stopping service you only stop listener, working processes still work. -- WBR, SD. +

Re: [firebird-support] Re: Firebird 2.5 service turned off but client application is still working.

2017-01-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.01.2017 14:44, brucedickin...@wp.pl [firebird-support] wrote: > what is listener responsible for? Only for spawning new processes? In Classic architecture - yes. -- WBR, SD. ++

Re: [firebird-support] firebird schema changes during backup

2017-01-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.01.2017 21:36, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > For all that, I don't think it is a good idea to be changing metadata > during a backup. Changing metadata is a bad idea in general. Continuous development is the worst thing that can happen to a database. --

Re: [firebird-support] Re: firebird schema changes during backup

2017-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2017 13:47, kragh.tho...@yahoo.com [firebird-support] wrote: > To be clear when the change scripts is applied to production they have been > tested on our > CI server and in our pre-prod environment. > We have been using this way of updating our schema for a few years now and it > works ver

Re: [firebird-support] Re: firebird schema changes during backup

2017-01-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.01.2017 21:21, kragh.tho...@yahoo.com [firebird-support] wrote: > could you please elaborate on your point of view? > > What can go wrong during this kind of operation? Upgrade script may fail and you database will end up in half-upgraded state. It could be simpler to restore fresh-made ba

Re: [firebird-support] How to get a list of columns from another select

2017-01-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
25.01.2017 19:53, jorg...@yahoo.com [firebird-support] wrote: > I do not want the query results, I want the names of the columns. Don't execute the query then, just prepare it. -- WBR, SD. ++

Re: [firebird-support] Re: How to get a list of columns from another select

2017-01-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.01.2017 0:23, jorg...@yahoo.com [firebird-support] wrote: > How to prepare sentence in Firebird 2.5? It depends on what API you use to access Firebird 2.5. In native ISC API it is done by isc_dsql_prepare() call. -- WBR, SD. ---

[firebird-support] Character set of parameter strings

2017-02-06 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. When a string is sent to server via a query parameter, how is its character set determined: from XSQLVAR.sqlsubtype field or from connection's lc_ctype parameter? -- WBR, SD. +++

Re: [firebird-support] Re: Character set of parameter strings

2017-02-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.02.2017 3:51, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > can be overridden by API user) That's exactly what I wanted to know, thanks. -- WBR, SD.

Re: [firebird-support] Migrating a 2.5 server

2017-02-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.02.2017 9:14, Luke Crooks l...@solentwholesale.com [firebird-support] wrote: > When running the 2.5 server on our Windows DC and having clients access from > the local > network, performance was very slow (almost unusable). System HDD on DC has write cache forcefully disabled. Put database

Re: [firebird-support] Is this a bug of Firebird?

2017-02-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.02.2017 16:55, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > Of course, the fault is of the programmer, but it can be detected at > compilation time. Why? It is expanded into code like this: FOR SELECT ALU_NOMBRE, ALU_APELLD AS CURSOR X DO

[firebird-support] Partial update

2017-02-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello, All. If I use prepared statement like this "update table set field1=?, field2=? where field3=?" for performance reasons, is there a way to update only some fields and leave other untouched without overhead of building separate queries on the fly or selecting old values with diff

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
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 the matrix in any convenient form. There is no point to do that on server. -- WBR, S

Re: [firebird-support] Partial update

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2017 16:21, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > If you are using UPDATE, then is it not reasonable to expect that you would > know what the > original values for of each field? It is not reasonable: I have no way to know them. All I have at hand is new

Re: [firebird-support] FIREBIRD PIVOT function or Matrix

2017-02-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.02.2017 16:31, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > There are times when I would love to be able to pivot data on the server, to > further > process the data an SP. SP cannot process queries with unknown number of fields. Neither client part, BTW. > Also,

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.02.2017 20:36, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Our clients ask for mobile/web access of our app,in this case we decided to > rewrite app > with Asp Core.What options are for hosting firebird with asp core? VPS or your own server. -- WBR, SD. --

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

2017-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.02.2017 12:55, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote: > I encountered a bit of trouble migrating a firebird server from an > ancient w2k SBS to a powerful debian-based DL380 server. > > I'll share my story, so people facing the same problems can scratch > things off their

Re: [firebird-support] Firebird 2.5 classic performance issue on linux64

2017-02-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.02.2017 21:07, Andreas Zeller zel...@lux-medien.com [firebird-support] wrote: > I am still curious about how this might affect performance? Did you monitor resource usage? CPU, RAM, IO? -- WBR, SD. ++

Re: [firebird-support] Issue

2017-02-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.02.2017 15:55, Jony zjara...@gmail.com [firebird-support] wrote: > I'm having an issue with the firebird guardian version 1.5 and I was hoping > if you can > help me out. A piece of advice: never use guardian. -- WBR, SD. ---

Re: [firebird-support] Re: firebird 3.0 ten times slower than 2.5 ?

2017-03-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.03.2017 12:20, Michal Kurczabinski michk...@gmail.com [firebird-support] wrote: > is still difference between 2.5 and 3.0:for select first 100 * > (now over 100% of time fb 2.5) Show "gstat -h" from both databases. -- WBR, SD. --

Re: [firebird-support] Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2017 9:39, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > But there is some performance/scaling problem showed and i am interested > about your opinion It is funny that they think that their Changes Tracking API can be used for replication of som

Re: [firebird-support] Re: Interbase vs Firebird

2017-03-10 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
10.03.2017 13:59, lis...@warmboot.com.br [firebird-support] wrote: > If you are speaking about Change Views feature, I understand its main > purpose is to help mobile applications to update local copies of > (changed) data easily. Yes, this is the main purpose of Change View (sorry, I messed th

Re: [firebird-support] Does any Delphi component exist to access a FB database without DLLs?

2017-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2017 12:00, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] wrote: > Eastern world's phones can be really skimpy in memory size and a 1MB DLL > could be a big > deal, You cannot run Delphi application on such phones. > If I end up having - say - 10 apps that make use of FB

Re: [firebird-support] Does any Delphi component exist to access a FB database without DLLs?

2017-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2017 12:33, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support] wrote: > if I manage to keep the size small enough, it may be doable. With Delphi - no. > I know, only one copy is placed in memory, but you still need 1 copy per > application on disk. No, you don't need to

Re: [firebird-support] Basic Start

2017-03-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.03.2017 18:32, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > 2) Can I create a Firebird database file? ... as I did with SQLite ... No. Firebird is a client-server DBMS, closer to Oracle than file-server like SQLite. Read Firebird Quick Start Guide. -- WBR, SD. ---

Re: [firebird-support] How to check for Garbace Collector

2017-03-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.03.2017 15:28, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > how can I check if garbage collection is running? Garbage Collector is always running. Sweep you can see in monitoring tables. -- WBR, SD.

Re: [firebird-support] Migrate interbase xe

2017-03-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
16.03.2017 18:16, julio brzezinski juliobrzezin...@gmail.com [firebird-support] wrote: > i possible to do that with buckup/restore or exists any tool to help with this It is not possible with backup and restore. Create new database from scratch and pump data with IBDataPump or any other util

Re: [firebird-support] Question about an error during Create/Drop tables.

2017-03-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.03.2017 10:11, amiya_s_hos...@yahoo.com [firebird-support] wrote: > Is there any tips for the phenomenon? > I'd appreciate if anyone could give me a resolution for that. Do not ever do anything like that. Or at least put commit after drop statement. -- WBR, SD. -

Re: [firebird-support] reset sysdba password without loose existing users

2017-03-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.03.2017 17:27, startx252...@yahoo.fr [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in > Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ---

Re: [firebird-support] using a stored procedure to return the value for an existing field in the table

2017-03-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.03.2017 17:26, av...@telusplanet.net [firebird-support] wrote: > is there a way i can write a StoredProcedure or trigger to have the "code" in > the database > return that value i want for the existing column and not just return the > table data for > that column? Create a new table, pump

Re: [firebird-support] 64 bit UDF DLL problem on Windows

2017-03-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.03.2017 13:26, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > Do you have ideas why it cannot find my UDFs? First of all, check that your DLL exports 'sum' without mangling. -- WBR, SD. --

Re: [firebird-support] 64 bit UDF DLL problem on Windows

2017-03-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.03.2017 15:14, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > That's all. A nd it wo rks fine in linux. > > How should i modify it? STFW how to export functions from C++ DLLs. -- WBR, SD.

Re: [firebird-support] 64 bit UDF DLL problem on Windows

2017-03-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
29.03.2017 0:27, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > I have wasted a lot of time but succes yet to come. void foo() #ifdef __WIN32__ __declspec(dllexport); #else __attribute__((visibility ("default"))); #endif // __WIN32__ -- WBR, SD. --

Re: [firebird-support] 64 bit UDF DLL problem on Windows

2017-03-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.03.2017 14:17, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > the keyword was > > extern "C" > > Now the compiler stopped mangling the function names and Firebird can see > them correctly. Only C++ compilers mangle names but you insisted that you use plain C... -

Re: [firebird-support] between operator on a varchar field

2017-03-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.03.2017 9:51, 'support' f...@princess.hu [firebird-support] wrote: > Am I missing something? Yes: value 'AHH00141/2016', for example, is bigger than 'AHH00095/2017' and smaller that 'AHH00141/2017'. -- WBR, SD. --

Re: [firebird-support] Multiple firebird servers accessing the same database

2017-04-05 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
05.04.2017 21:27, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > Is this possible, even in some unorthodox way? No. The only way is to replicate copies of the database to every server. -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 8:22, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > How can I improve remote speed? Increase value of "TcpRemoteBufferSize" parameter in firebird.conf to max. -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 20:50, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > on another table,same db, with 7 records and 12 columns takes * 2.362s* Is result the same if query is executed from server or if count(*) is requested instead of whole data set? -- WBR, SD.

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 21:20, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > select count(*) remote is fast > Total execution time: 0.386s If you use isql instead of Flame Robin/IBExpert does it make any difference? -- WBR, SD. --

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 21:27, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > I don't think Just try. -- WBR, SD. ++ Visit http://www.firebirdsql.o

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 21:40, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > indeed is faster Working with Firebird via high latency network require very careful application design and development. You, literally, must count every round trip to server and every received byte. -- WBR,

Re: [firebird-support] Improve remote query speed on Windows Server 2012 VPS

2017-04-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.04.2017 22:01, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > this is just firebird specific? No, Oracle is the same. -- WBR, SD. ++

Re: [firebird-support] Firebird 1.5.6 not work with locla protocol

2017-04-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.04.2017 12:29, blumy2...@yahoo.com [firebird-support] wrote: > Where is the problem?? The problem is that you try to run 15 years old Firebird on modern OS. It has higher security measures that prevent using of old IPC protocol between ordinary user application and a service run under SY

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2017 13:42, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > Firebird.log file shows only lines with 10054 and nothing else. Is it server log or client log? > How can I find out the reason why a user is kicked off from > connection? If it was server log, the reason is your

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2017 14:51, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > What else can I check? Network cards, cable, commutators and firewall/antivirus between this server and 192.168.0.222. Make sure that network cards has "enable to turn off this device to save power" setting dis

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.04.2017 15:15, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: > Customer reports that it happens in heavy work too therefore I think > it must be something else than power saving on card. > > It is also true, that this started to appear after some Windows 10 > Update. Time differe

Re: [firebird-support] Performing bulk update taking time.

2017-04-27 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
27.04.2017 9:03, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Is there a way through which this query can be further optimised as this > query taking time > for completion more than 3 -4 hours. Could I use batch based update in this > qu ery…? Query in FOR SELECT does not n

Re: [firebird-support] Table Size

2017-05-09 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
09.05.2017 21:59, dres...@tbinc.com [firebird-support] wrote: > Does anyone have any tools that they can recommend that could help me easily > manage this? gstat -- WBR, SD.

Re: [firebird-support] Table Size

2017-05-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.05.2017 1:56, dres...@tbinc.com [firebird-support] wrote: > The results are pretty raw data--something like a pie chart would be nice. IIRC, IBSurgeon have a graphical tool for that. Look at www.ibsurgeon.com. -- WBR, SD.

Re: [firebird-support] Installing Firebird during the installation of my product

2017-05-19 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
19.05.2017 14:15, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Is there any way to install firebird silently as part of my installation app? > > Any documentation on how to do this for a single computer? And possibly > later how to do > it for a server and client install? RTFM doc/

Re: [firebird-support] remote connection disconnection

2017-05-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.05.2017 15:48, James mallee@gmail.com [firebird-support] wrote: > Or this issue is caused from Ubuntu ddclient DDNS service? Usually this issue is caused by provider's hardware. Cisco routers have by default connection inactivity timeout turned on. Try to set DummyPacketInterval to

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.06.2017 4:20, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > If our software running on firebird 1.5 and now going to move over to > firebird 2.5, > > technical-wise, what are the points we can convince people to change over? Firebird 1.5 is not supported by p

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.06.2017 8:54, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > What is the size of the database that we can test to show the speed > significance between > Firebird 1.5 and Firebird 2.5? One terabyte should be enough. But what's the point to migrate to 2.5 when

Re: [firebird-support] Firebird Server 64 Bit With 32 Bit Clients on Remote Machines

2017-06-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.06.2017 4:40, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote: > Is it correct to have Windows 32 clients on remote machines connecting to 64 > Bit > Firebird-3.0.2.32703_0_x64. It does not matter. Any Firebird client can work with any Firebird server. -- WBR, SD. -

Re: [firebird-support] Why backlash do not raise parser error

2017-06-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.06.2017 12:42, 'liviusliv...@poczta.onet.pl' liviusliv...@poczta.onet.pl [firebird-support] wrote: > Why backslash does not raise parser :error? It does: > Database: S_TEST, User: SD > SQL> Select * from rdb$relations\ R > CON> Inner join rdb$relation_fields rf on rf.rdb$relation_name = >

Re: [firebird-support] Can anyone advise the difference between Firebird 2.5 32 bit vs Firebird 3 32 bit?

2017-06-23 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
23.06.2017 11:15, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > Can anyone advise the difference between Firebird 2.5 32 bit vs Firebird 3 > 32 bit? Read Releas Notes. -- WBR, SD.

Re: [firebird-support] Re: witch vresion of Firebird to choose for Delphi 7 and IBX 7.09

2017-06-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.06.2017 19:44, safirh...@yahoo.fr [firebird-support] wrote: > is there any conflict betwene interbase gds32.dll , and firebird gds32.dll > .? Yes. They are quite different and Firebird client won't work with Interbase server good. Contrary is true as well: Interbase client will have pr

Re: [firebird-support] How can one rename a table in Firebird 3.0

2017-07-12 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
12.07.2017 18:13, dam...@wxs.nl [firebird-support] wrote: > my question is does someone know a method in Firebird 3.0. CREATE VIEW new_name AS SELECT * FROM old_name -- WBR, SD. +

Re: [firebird-support] Re: How can one rename a table in Firebird 3.0

2017-07-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.07.2017 11:08, dam...@wxs.nl [firebird-support] wrote: > Does it mean that the old method is blocked in Firebird 3.0 and later? Creating of a view is an old method. Firebird 3 just prohibit hacks with direct changes of system tables. -- WBR, SD.

Re: [firebird-support] Firebird Connection String

2017-07-22 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
22.07.2017 19:28, ajc4pyilyfqeryixt3gvm2tqmwze4i33cooea...@yahoo.com [firebird-support] wrote: > Any suggestions??? Read Firebird Quick Start Guide. Everything you do is completely wrong. -- WBR, SD. ++

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

2017-08-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.08.2017 15:20, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > Any idea how to prevent this problem to appear again in the future ? > > FB Version : 2.5.2.26539 Restore your database from backup and never use nbackup with this bugged FB version any more. -- WBR, SD.

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

2017-08-03 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
03.08.2017 11:00, Jorge Gonçalves projo...@gmail.com [firebird-support] wrote: > From which version is safe to use nbackup ? Always use the latest release. For 2.5 it is 2.5.7. But even with this it is not guaranteed to work. Check list of nbackup-related bugs in tracker: http://tracker.fir

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

2017-08-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.08.2017 18:52, Jesus Garcia jeg...@gmail.com [firebird-support] wrote: > As I understood he was saying to not use nbackup, and if one person involved > in any way to > firebird says not to use it, then what make him think to others? There is a difference between "do not use it" and "do not

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

2017-08-04 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
04.08.2017 20:37, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > Unfortunately, in your later post you suggested that nbackup is never safe to > use. Sure, as any other software it may have destructive bugs. Every software license has words like "this software is provi

Re: [firebird-support] udf with paramters problem

2017-08-11 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
11.08.2017 11:09, keith prosser prosse...@yahoo.com [firebird-support] wrote: > I'm fairy sure its to with pointers and data. No, it is about calling conventions. UDFs use cdecl, not stdcall. -- WBR, SD. +++

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 17:21, Nick Upson n...@telensa.com [firebird-support] wrote: > if I do nbackup . it fails, telling me I cannot access the security2.fdb > (as a normal > user) Why can't you use su to change current user to root or firebird? -- WBR, SD. --

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 17:44, Nick Upson n...@telensa.com [firebird-support] wrote: > because this is from cron, so key-based auth is out and I don't want to put > passwords / > keys on the server According to google you don't need password for cron jobs: https://stackoverflow.com/questions/8475694/how-t

Re: [firebird-support] permissions nbackup

2017-08-14 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
14.08.2017 18:00, Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support] wrote: > I manage a couple of databases > located on servers I don't have root accounts on, and it's possible, > although more complicated. If you have sysdba permissions, you can do nbackup via services. Secu

Re: [firebird-support] Automation tools?

2017-08-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.08.2017 15:36, Kjell Rilbe kjell.ri...@marknadsinformation.se [firebird-support] wrote: > We're in need of a tool where we can author sequences of SQL queries against > FB and non-DB > commands like file operations etc. I'd like to call them "batch runs" to > perform recurring > tasks. > >

Re: [firebird-support] Firebird slowdown.

2017-08-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
15.08.2017 18:50, anderphil...@hotmail.com [firebird-support] wrote: > 4x Intel(R) Xeon(R) CPU X5650 @ 2.67GHz > > physical memory: 4096 MB > 7gb disk free > > Firebird 2.5.3 x64 super server > Windows 2008 R2 https://support.microsoft.com/en-us/help/2207548/slow-performance-on-windows-ser

Re: [firebird-support] Re: Automatic Firing of Query.

2017-08-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.08.2017 11:32, anshuman.na...@airtelmail.in [firebird-support] wrote: > These queries are getting fired on its own even when there is no action taken > in the > system at a particular time interval. Not only that, these queries are > getting fired > even at the time when there are only sel

Re: [firebird-support] UDF or/and maybe Charset problem

2017-08-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.08.2017 11:37, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > result = (char*)calloc(j, sizeof(char)); You must use ib_util_malloc() to allocate memory in UDF and don't forget FREE_IT in declaration to avoid memory leak. -- WBR, SD. ---

Re: [firebird-support] UDF or/and maybe Charset problem

2017-08-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.08.2017 12:00, Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] wrote: > out = (char*)calloc(strlen(str), sizeof(char)); > result = (char*)calloc(j, sizeof(char)); Besides, here and there you forgot about space for terminating null char. -- WBR, SD.

Re: [firebird-support] Cast as domain in view - wrong datatype

2017-08-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.08.2017 14:49, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > View GTIN field is "exported" as varchar(20), instead of decimal(14,0). > Am I doing domething wrong or could be a bug? Because of your "else '' end as GTIN" server has no choice. Result of whole CASE

Re: [firebird-support] UDF or/and maybe Charset problem

2017-08-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.08.2017 15:07, Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support] wrote: > is there any problems if I just declare all UDF's with FREE IT? Yes, server will have problems trying to free memory that wasn't allocated. -- WBR, SD.

Re: [firebird-support]

2017-08-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.08.2017 20:00, Jorge Andres Brugger jorge.brug...@gmail.com [firebird-support] wrote: > It´s "fixable"? First, make versions of client library and message file match server. Second, you cannot create primary key on nullable field. -- WBR, SD.

Re: [firebird-support] Spatial extensions...

2017-08-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.08.2017 18:01, prosse...@yahoo.com [firebird-support] wrote: > I'm bored and need a challenge... I'd really like to add spatial support to > firebird so > how do I sign up?   I've been programming in C, C++ and Delphi for 30 years > and now I can > write what I want to write! Fork your r

Re: [firebird-support] Firebird Database to MYSQL Database conversion

2017-08-29 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.08.2017 12:43, vamsi sagiraju vamsi...@gmail.com [firebird-support] wrote: > I am alien to Firebird database, having no idea about it, But we have to > migrate it to > MySQL database(Have good idea about it). So could any one please let me know > how to > convert the Firebird database to MY

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

2017-08-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.08.2017 14:16, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I am looking for an instruction to execute SQL block with elevate permitions. > I would like to know if exists how to execute pSQL as another role (or user) > or SQL > update/insert/delete. RTFM Execute Statement on

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

2017-08-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.08.2017 17:58, hamacker sirhamac...@gmail.com [firebird-support] wrote: > To run, I need to know user and password and I don´t. No, you don't. If you provide role name only, current user will be used. -- WBR, SD.

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

2017-08-30 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
30.08.2017 21:15, hamacker sirhamac...@gmail.com [firebird-support] wrote: > Here in fb3, to put role name in execute, Its mandatory put username and > password too. I was wrong a little, but still you should read the documentation: > - if ON EXTERNAL DATA SOURCE clause is omitted then >

Re: [firebird-support] Any 'run as' in SQL/PSQL in FB3 ?

2017-08-31 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
31.08.2017 21:36, hamacker sirhamac...@gmail.com [firebird-support] wrote: > So, to my sample run file, all block code need to be a unique execute > statement... and you > know it´s a mess. Just in case: are you aware that you can grant rights to stored procedure instead of user? -- WB

Re: [firebird-support] Connect to FB database through VPN

2017-09-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.09.2017 11:28, sntpywhl3bfbefeaicfmgdnmn3pewm6576tee...@yahoo.com [firebird-support] wrote: > Is there something different I should be doing to connect to a FB database > through a VPN? No. Media is irrelevant for TCP. -- WBR, SD. -

Re: [firebird-support] Implicit path for Database

2017-09-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: > Will be good also a way to specify the path where the databses are store > if I not specify a path in connect string. In firebird.conf set DatabaseAccess to Restrict. Databases will be created in the first directory in list.

Re: [firebird-support] Problem with linked table

2017-09-07 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
07.09.2017 19:48, Adriano Novelli adrianonove...@yahoo.it [firebird-support] wrote: > What should I do to read data from the tables linked from every pc and not > just that with > which I linked the tables? Learn more about client-server technologies. You must install Firebird server on s

Re: [firebird-support] FreeAdhocUDF and Firebird 3 not working

2017-09-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.09.2017 1:10, ke...@dojitraders.com [firebird-support] wrote: > I thought it better to mention the FreeAdhocUDF issue otherwise it would be > my fault that > my own UDF does not work! The authors of FreeAdhocUDF can make mistakes different from you. You must not take conclusion that they

Re: [firebird-support] Problem with linked table

2017-09-08 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
08.09.2017 8:37, adrianonove...@yahoo.it [firebird-support] wrote: > Firebirds server is installed on server and i can connectthrough OBDC from > all workstations. Using the same connection string that you used for linking the tables?.. -- WBR, SD.

Re: [firebird-support] Explicit Login with Windows Domain username

2017-09-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.09.2017 16:40, 'Nikolaus Kern' parzival1...@gmx.at [firebird-support] wrote: > How do I format the username that it will work? No way to make it work. -- WBR, SD. +

Re: [firebird-support] error 10054

2017-09-20 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
20.09.2017 14:24, 'Sabbagh, Nariman' nariman.sabb...@delta.com [firebird-support] wrote: > Ames keeps hanging and it is because of firebird giving error 10054. Actually, it is contrary: Ames (whatever it is) hangs, get killed that that end up in error 10054. You should test your network hard

[firebird-support] Backup file padding

2017-09-25 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Hello. What is the purpose of backup file being padded by zeros up to 512 bytes block? -- WBR, SD. ++ Visit http://www.firebirdsql.org and clic

Re: [firebird-support] Transaction Management Failing?

2017-09-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.09.2017 12:10, 'Robert Harris' rob...@zzyzxl.com [firebird-support] wrote: > The logic is that straightforward. The InsertMyData inserts lines of an > invoice or any > other customer transaction into ledgers, each identified by a transaction > number. The > problem is that when the issue occ

Re: [firebird-support] Embedded FB3 was killed?

2017-09-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.09.2017 12:25, Matthias Hanft m...@hanft.de [firebird-support] wrote: > As far as I understand that, I just call "fbclient.dll" as usual, > and if the database path is a local file, "fbclient.dll" automagically > calls "engine12.dll" (or whatever it needs) for the use as a local/ > embedded serv

<    1   2   3   4   5   6   7   8   >