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


Getting Started -- SQLData Desktop Server

Setting up ODBC Data Sources

The SQLData Server uses ODBC to access your databases. So, the first thing is to define your ODBC data sources in the Control Panel. Click the ODBC icon in the control panel to bring up the ODBC Data Source Administrator. Then, select the System DSN tab in the dialog box and add your data sources as the System Data Sources. The SQLData server is running as a Windows NT system service, it can only access data sources defined as the System DSN.

Important: While you are in the ODBC Administrator, you should take the opportunity to clean up unused data sources and broken data sources (Data Sources that don't point to a valid database system). This will help SQLData server not to make any unnecessary database connections when it tries to search all your databases and tables in the system.

Starting up the SQLData Server

The SQLData server is installed as a Windows NT system service on a Windows NT system. To start the service:

bulletGo to the Control Panel and double click the Service icon.
bulletIn the service list, select SQLData Database Services and click the Start button.

In a Windows 95/98 system, the server should be started from the Start menu:

bulletStart Programs SQLData Services SQLData Web Database Service

Browsing Database Tables

After starting the server, you are ready to access all databases defined on the server. The server shipped with a set of HTML pages to give you a jump-start. You should be able to perform all database operations if you follow the following steps:

      1. Start you web browser and type in
        where localhost can be your machine name and 8732 is the default port for the service. You should see the welcome page displayed in your browser with Service Indices in the left frame window.
      2. Click on the Database under the Service Indices to see all your databases and tables displayed in the left frame window. Database tables are grouped together under the name of the data source. An error will be displayed if the server could not connect to a data source. The server generates a form for you to make a manual connection, type in your user name and password for the data source and click the Connect button.
      3. Click on the name of the table you want to see. The content of the table will be displayed in the right frame window.
      4. Now click on any record in the result set, the record detail will be displayed in an HTML form. You can now make changes in the record and click the Update button or click the Delete button to remove it from the database.

If you have reached to this point without problem, your server is setup and configured properly.

If, at any of the steps, you encountered a problem, check out the Trouble Shooting Guide. It contains solutions to many common problems. You can also reach our technical support by mailing to support@sqldata.com if the problem persist.


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