[firebird-support] Re: Running with two different embedded versions of Firebird DB
Any suggestions?
[firebird-support] Running with two different embedded versions of Firebird DB
We are in the middle of letter our users upgrade their database from 1.56 to 3.x at their will. Users can upgrade when they want to--so we install 1.56 embedded db as gds32.dll and 3.x as fblcinet.dll in the same directory (using IBObjects, we can select which DLL is used). Almost all of our users use the embedded version. The problem is when a database exception occurs--the "firebird.msg" file is used. Is there a way to configure the name that the DLL uses for the firebird.msg file? Or should the FB databases be installed in separate sub directories? Any suggestions here would be appreciated. Ed Dressel
Re: [firebird-support] Huge performance different from FB 2.5.2 vs FB 3.02
Karol: Not to highjack the thread, but a question. You stated: > this is terible to read. Please change join style to explicite join style > > instead SELECT .. FROM TABLE_A A, TABLE_B B WHERE A.ID=B.ID > write SELECT .. FROM TABLE_A A INNER JOIN TABLE_B B ON A.ID=B.ID I'm not a DB expert, only as I have to but I read the first line easier than the second line, but not without much difference. Why do you state it is terrible? Ed Dressel
[firebird-support] Re: FB and VPN
The exception they are getting is: ISC ERROR CODE:335544721 ISC ERROR MESSAGE: Unable to complete network request to host "[Server Name]". Error reading data from the connection. An existing connection was forcibly closed by the remote host. Any suggestions? Thanks in advance. Ed Dressel
[firebird-support] FB connection over a VPN
By default, my app (Delphi with IBObjects) use FB 1.56 embedded with an option to run as client server (C/S). One of my customers wants to set it up to run C/S over a VPN. They tried using 1.56 but it timed out. They then tried switching to 2.5 (including changing out the DLL) but it still times out. Any suggestions on how to get this to work? Ed Dressel
[firebird-support] FB and VPN
My (Delphi) application uses FB embedded (1.56 by default right now; connection via IBObjects) and works great. I have a user who wants to run it over a VPN and it times out on him. He replaced the 1.56 library with 2.5 and installed 2.5 on the server, but this did not fix the problem. Any suggestions to getting this to work? We are looking at going to 3.x, but have been overwhelmed with other issues at the moment. Ed Dressel
[firebird-support] Re: Compatibility questions: Current release versus 1.5.3.4870
Scott: We are seeing something very strange as well--on some computers that update, our application does not work. It won't even let us reinstall. Checking the rights to the directory and everything seems correct. After a reboot, and a reinstallation of our application, everything works fine. We use FB 1.5 embedded in most applications, but are running the server version on several computers and it is running just fine. Ed Dressel
Re: [firebird-support] Table Size
Thank you. Running 15. The results are pretty raw data--something like a pie chart would be nice. Any way of getting the API calls to know tables and their sizes? I don't mind creating something like this.
[firebird-support] Table Size
I have a number of growing databases on my server and would like to occasionally see how much space each table is taking in the database--there may be some log files that could be cleaned up now and then. Many of my tables include blob fields, so this becomes different than just doing record count times the amount of data in a record. Does anyone have any tools that they can recommend that could help me easily manage this? much appreciated, Ed Dressel
[firebird-support] FB 1.56 over a VPN
We are using FB 1.56, and have a customer using it over a VPN with less than stellar results (meaning very slow). We are considering FB 3--will this solve some of the slowness? Any other comments? Thank you, Ed Dressel
RE: [firebird-support] Grouping SQL counts
Set Huan: Sorry for the lack of clarity--it was clear when I wrote it but when I read it now, I understand the lack of clarity. I wanted two columns count columns--Set, your answer d is perfect. Thank you both for taking the time--and Set for taking the time. Ed Dressel
[firebird-support] Grouping SQL counts
FB 1.5x I have a SQL statement that returns the results I want--giving me a count on the detail dataset (ClientRegHistList is a detail list on ClientRegHis, more info below) select C.RegDate, Count(Client_ID) from ClientRegHist C, ClientReghistList CL where (CL.ClientRegHist_ID = C.ClientRegHist_ID) and CL.RegType = 0 and (C.Company_ID = 128) group by 1; I have a second SQL that is exactly the same except changing the 0 to a 1 in line 5. I would like to combine the two datasets into one result set--any hints on how to do this? Thank you, Ed Dressel CREATE TABLE CLIENTREGHIST ( CLIENTREGHIST_ID DM_KEY /* DM_KEY = INTEGER NOT NULL */, REGDATE DM_DATE /* DM_DATE = TIMESTAMP */, COMPANY_IDDM_INTEGER /* DM_INTEGER = INTEGER */ ); CREATE TABLE CLIENTREGHISTLIST ( CLIENTREGHIST_ID DM_INTEGER /* DM_INTEGER = INTEGER */, REGTYPE DM_INTEGER /* DM_INTEGER = INTEGER */, CLIENT_ID DM_INTEGER /* DM_INTEGER = INTEGER */ ); ALTER TABLE CLIENTREGHISTLIST ADD CONSTRAINT FK_CLIENTREGHISTLIST_1 FOREIGN KEY (CLIENTREGHIST_ID) REFERENCES CLIENTREGHIST (CLIENTREGHIST_ID) ON DELETE CASCADE; ALTER TABLE CLIENTREGHISTLIST ADD CONSTRAINT FK_CLIENTREGHISTLIST_2 FOREIGN KEY (CLIENT_ID) REFERENCES CLIENTINFO (CLIENT_ID);