Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 14 total |
Database System Utility unable to connect to DB Server |
Thu, May 3 2012 4:37 AM | Permanent Link |
Mathias Burbach | Hello Folks!
I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port & encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail. What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe? Thanks for a short answer in advance. Salut, Mathias Attachments: Remote.PNG |
Thu, May 3 2012 4:47 AM | Permanent Link |
Mathias Burbach | Mathias Burbach wrote:
Hello Folks! I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port & encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail. The login dialogue does not show up in order to connect to the "remote server". What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe? Thanks for a short answer in advance. Salut, Mathias |
Thu, May 3 2012 8:49 AM | Permanent Link |
Raul Team Elevate | Mathias,
You need to go to the settings (File->Options->Remote tab) and enter the IP address for the server first (or use 127.0.0.1 if runnning on local machine) Raul On 5/3/2012 4:37 AM, Mathias Burbach wrote: > Hello Folks! > > I have inherited a Delphi 5 project, that I need to move forward to Delphi XE2. I purchased DBISAM VCL Standard with Source Code and installed it into a fresh virtual machine with Delphi XE2. I then copied over the dbsrvr.ini from teh old Delphi 5 install (it includes a different port& encryption password), changed the settings of Database System Utility to try to connect on the different port. But when I now try to connect to the "remote server" on 127.0.0.1 via "Remote (Client/Server)" the label says "Remote (Client/Server) - Not available" and any attempt to choose the radio box "Remote (Client/Server)" will fail. > > What do I need to do to get Database System Utility to connect remotely to the re-configured dbsrvr.exe? > > Thanks for a short answer in advance. > > Salut, > Mathias > |
Thu, May 3 2012 11:35 AM | Permanent Link |
Mathias Burbach | Hello Raul,
thanks for your reply. Raul wrote: >Mathias, >You need to go to the settings (File->Options->Remote tab) and enter the >IP address for the server first (or use 127.0.0.1 if runnning on local >machine) That has been entered already (see attached screenshot). Other settings that have been activated in dbsrvr.ini are: * Server Description=XXX Database Server * Server Address=127.0.0.1 * Server Port=12015 * Server Thread Cache Size=20 * Administration Address=127.0.0.1 * Administration Port=12016 * Administration Thread Cache Size=4 * Configuration Password=XXXXXXXX * Encrypted Only=1 * Encryption Password=XXXXXXX * No User Interface=0 * Append To Log=0 * Large File Support=0 There must be another reason why the Database System Utility doesn't want to connect "remotely". Salut, Mathias Attachments: DSU Remote Settings.PNG |
Thu, May 3 2012 3:32 PM | Permanent Link |
Raul Team Elevate | Can you clarify the "remote" part - your DBSRVR is set to listen on the local loopback address (127.0.0.1) hence only way to connect to it is from the same machine (you would not be able to connect remotely). "Not available" usually indicates that dbsys could not connect to the server over IP. Are you using the dbsrvr that shipped with the DBISAM or is it the one from D5 install? If so then any chance it's been customized (like custom engine signature or such). If it's the default dbsrvr as shipped by ElevateSoft then i would verify that the dbsrvr is actually online and listening on local loopback IP and port 12015 and double-check all your password settings Raul On 5/3/2012 11:35 AM, Mathias Burbach wrote: > Hello Raul, > > thanks for your reply. > > Raul wrote: >> Mathias, >> You need to go to the settings (File->Options->Remote tab) and enter the >> IP address for the server first (or use 127.0.0.1 if runnning on local >> machine) > That has been entered already (see attached screenshot). > > Other settings that have been activated in dbsrvr.ini are: > * Server Description=XXX Database Server > * Server Address=127.0.0.1 > * Server Port=12015 > * Server Thread Cache Size=20 > * Administration Address=127.0.0.1 > * Administration Port=12016 > * Administration Thread Cache Size=4 > * Configuration Password=XXXXXXXX > * Encrypted Only=1 > * Encryption Password=XXXXXXX > * No User Interface=0 > * Append To Log=0 > * Large File Support=0 > > There must be another reason why the Database System Utility doesn't want to connect "remotely". > > Salut, > Mathias > |
Fri, May 4 2012 12:07 AM | Permanent Link |
Mathias Burbach | Hello Raul,
Thanks for your reply. Raul wrote: >Can you clarify the "remote" part - your DBSRVR is set to listen on the >local loopback address (127.0.0.1) hence only way to connect to it is >from the same machine (you would not be able to connect remotely). Yes, I try to connect via 127.0.0.1 (see also attached screenshot of the Database System Utility settings). >Are you using the dbsrvr that shipped with the DBISAM or is it the one >from D5 install? If so then any chance it's been customized (like custom >engine signature or such). I have installed the latest version of DBISAM into a new virtual machine. I just copied the DBSRVR.ini from the virtual machine running Delphi 5, so that my new development environment is as close as possible to how it was with Delphi 5. >If it's the default dbsrvr as shipped by ElevateSoft then i would verify >that the dbsrvr is actually online and listening on local loopback IP >and port 12015 and double-check all your password settings Yes, it is. If I rename the DBSRVR.ini and run the server with the default settings (e.g. port 12005 and no forced encryption) I can connect successfully from Database System Utility. Something in the settings of DBSRVR.ini must cause that the Database System Utility doesn't find the "remote server" on the amended port any more and doesn't even show a login dialogue. I am looking forward to any other suggestions you or the DBISAM user community might have. Salut, Mathias |
Fri, May 4 2012 12:17 AM | Permanent Link |
Mathias Burbach | I have removed the requirement to encrypt the communication (e.g. Encrypted Only=1 is now Encrypted Only=0) and the login dialogue appears. But I still cannot connect. If I try to connect with the Server Administration Utility I get the following error message:
"Error retrieving server information - DBISAM Engine Error # 11276 The connection to the database server at '127.0.0.1' has been lost" Salut, Mathias |
Fri, May 4 2012 5:36 AM | Permanent Link |
Mathias Burbach | Next attempt:
I have commented out all settings and started re-enabling them. With all settings disabled I could connect. I then enabled * Server Description=XXXX Database Server * Server Port=12015 * Administration Port=12016 * Administration Address=127.0.0.1 and still I could connect. As soon as I enabled * Encrypted Only=0 * Encryption Password=XXXYYYZZZ the connection error occurred again: "Error retrieving server information - DBISAM Engine Error # 11276 The connection to the database server at '127.0.0.1' has been lost" There seems to be no way to add an encryption password to dbsys or srvadmin and even if the use of the encryption password is optional (e.g. Encrypted Only=0) the server seems to require it. Can I use the dbsys as provided in the install with a server, for which the transport encryption has been enabled? Thanks for a short answer in advance. Salut, Mathias |
Fri, May 4 2012 6:27 AM | Permanent Link |
Mathias Burbach | Hello Folks!
The case is solved. My predecessor compiled a customised version of dbsys with the encryption password in the FormCreate event. I tried to do the same but it failed due to missing PAS files such as dbisamut.pas & dbisamct.pas. I only have a "DBISAM VCL Standard with Source Code" license. I take it this means I can't compile the server or the utility tools either. Is there an upgrade path for my version to get to "DBISAM VCL Client-Server with Source Code"? Salut, Mathias |
Fri, May 4 2012 6:57 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Mathias
>Is there an upgrade path for my version to get to "DBISAM VCL Client-Server with Source Code"? email sales@elevatesoft.com for the answer to that. Roy Lambert [Team Elevate] |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |