SQLData Systems, Inc.
Home | Products | Services | Documents | Support


  1. 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.
  2. 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
  3. 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,


    allows all hosts with IP address from to 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,


    machine with IP 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.





Download | Purchase | ContactFeedback

horizontal rule

Send mail to  info2-at-sqldata-dot-com with questions or comments about this web site.
Copyright 2008-2010 SQLData Systems, Inc.
Last modified: July 10, 2010