Configuring SequeLink

Sun Chili!Soft ASP includes the client portion of DataDirect SequeLink 4.5.1, which enables you to connect to a remote Microsoft Access or Microsoft SQL Server 6.5 database running on Windows 95, Windows 98, Windows NT 3.51 or 4.0, or Windows 2000. The SequeLink client resides on the same computer as the ASP Server and behaves like an ODBC driver. It communicates with a SequeLink server running on the remote database server.

Before you can use SequeLink to connect to a remote database, you must take the following steps:

1. Configure the SequeLink client software for Microsoft Access or Microsoft SQL Server 6.5, as described later in this topic.

2. Install and configure the SequeLink server software on the database server. You can download the software from the Sun Chili!Soft Web site at:

ftp://ftp.chilisoft.com/chiliasp/sequelink/slkntsrv.zip

3. Add a SequeLink DSN by using the Administration Console, as described in "Adding a DSN" in this chapter. When you do this, be sure to use the DSN name that you create in the following procedure.

To configure the SequeLink client for Microsoft Access

1. From the Sun Chili!Soft ASP instance subdirectory of the Sun Chili!Soft ASP installation directory, type the following command:

./setsqlnk

2. Select [2] New to create a new SequeLink DSN. Enter the following information when prompted:

Name: The name of the SequeLink DSN that you want to create (you must use the same DSN name when you configure the SequeLink DSN in the Administration Console).

Description: Optional.

Transliteration: Do not configure or change this option.

Select a network: Select TCP.

Host: Enter the IP address of the Windows server on which your database is running.

ServerType: Select Windows NT Server.

User: Enter the username for accessing the Windows server.

Password: Enter the password for accessing the Windows server.

Select a Database service: Select ODBC MS Access.

Name: Enter the name of the Windows service that you created when installing the SequeLink Server software.

Database: Enter the name of the database to which you want this DSN to connect, for example, E:\data\publish.mdb (note the Windows syntax for providing the path information).

3. Select [6] Test. The setup utility should return Test Passed. If you receive an error, select [4] to edit your DSN information.

4. After completing SequeLink setup, select [0] to exit.

5. Configure the SequeLink DSN, as described in "Adding a DSN" in this chapter.

To configure the SequeLink client for Microsoft SQL Server 6.5

1. From the Sun Chili!Soft ASP instance subdirectory of the Sun Chili!Soft ASP installation directory, type: