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:
 | Go to the Control Panel and double click the Service icon. |
| In 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:
| Start
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:
- Start you web browser and type in
http://localhost:8732
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.
- 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.
- Click on the name of the table you want to see. The content of the table will be
displayed in the right frame window.
- 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.
|
