- How to use SSL 3.0?
You must have a valid certificate in order to run the service
using SSL. The server runs in secure mode when it is given the certificate:
sqldata.exe -cert YourCertificate
There are many certificate authorities that issue server certificates.
- How to run the server as a proxy?
The server can be used as a secure proxy when needed. The command line option is:
sqldata.exe -proxy
- How to specify which hosts can access the server?
The hosts that can access your service is specified as ValidIP in the configuration file.
ValidIP is a string of IP addresses separated by ';'. You can also use regular expression
in the setting. For example,
ValidIP=205.245.34.*
allows all hosts with IP address from 205.245.34.1 to 205.245.34.255 to access the
service. All other hosts will be rejected. You can also exclude hosts from the legal host
group by setting InvalidIP. For instance,
InvalidIP=205.245.34.234
machine with IP 205.245.34.234 will be excluded from the legal group, and will be denied
for services.
4. What is the Dynamic Server Group?
The Dynamic Server Group (DSG) is a group of servers that run the SQLData servers. Each
server in the server group multicasts messages to others so that resources can be accessed
from other hosts transparently. Database information can be obtained from any of the hosts
in the group. DSG is useful for distributing loads to multiple servers and providing
fail-over support in the mission critical application.
5. I have several databases which I don't what to
make them publicly available. How can I remove them from the service?
The easiest way to remove a database from being accessed through the SQLData servers is
to delete the Data Source Name (DSN). This can be done using the ODBC administration tool
in the Control Panel.
The second way is to define ExportDSN setting in the configuration file such that it
contains a list of data sources (separated by semicolon) to be exported. For
example, the following setting export three data sources:
ExportDSN = TestDbase;TestAccess;TestText
Data sources not in the list will not be available for web users.
6. How can I change the port number the server is listening to?
The server uses 8732 as the socket port by default. You can
change the port number by specify a different port number from the command line. For
instance,
sqldata -port 80
will start the server using port 80. If you run the server as a Windows NT service, the
server uses system registry setting at:
HKEY_LOCAL_MACHINE\Software\SQLData Systems\Web Database
Services\2.0\ServerPort
You can use regedit to modify the value.
7. I reinstalled the trial version and the server could not be started any
more, what's the problem?
You can only install the trial version many times, but the setup program will not
generate the trial license the second time it is installed, so the license file is not
signed and thus becomes invalid. Please send a email to support@sqldata.com to get another trial
license.
8. When I try to start the service from the Control Panel, I got an Internal
Error message. What's the problem?
It is likely that the license has expired. Please send a email to support@sqldata.com to request another trial
license.