Configuring SequeLink

Sun ONE Active Server Pages includes the client portion of DataDirect SequeLink 5.3, 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:

Create a data source on the Windows machine.

Install and configure the SequeLink server software on the database server. The software can be downloaded from the Sun ONE ASP Web site at:

http://developer.chilisoft.com/downloads/register2.asp?target=SEQUELINK

Run setup.exe /v"IPE=No" and install all defaults.

Note: Be sure to install SLSocket. For information about configuring the SequeLink server, see the following procedure.

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

On the database server to which SequeLink Server 5.3 is installed, create a DSN using Windows’ administrative tools (Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC).

Start SequeLink Server 5.3 for ODBC Sockets (Start > SequeLink Server 5.3 for ODBC Sockets > SequeLink Manager Snapin.

Note: To perform this procedure, SLSocket must be installed.

Connect to the SequeLink Service if you’re not already connected, and then expand SequeLink 5.3 Manager.

Expand SequeLink Services > SLSocket53 > Configuration.

Right-click Data Source Settings, and then select New > Data source.

Name the new data source by typing the name of the DSN you created in step 1 (for example, "test"), expand the node, and then click the Advanced folder.

Double-click DataSourceSOCODBCConnStr.

In the Value box, change the value to the connection string you created in step 1 (for example, "DSN=test"), and then click OK.

Expand the User Security node, and then double-click Data Source Logon Method.

Select OSIntegrated.

Configure the SequeLink DSN, as described in Adding a DSN. You will be asked to specify the ServerDataSource. This is the name of the DSN you just configured (for example, "test").