Any suggestions?
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
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
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.
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
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
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
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.
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
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
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
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
12 matches
Mail list logo