Before you define the interface and connect to an Adaptive Server database in DataWindow Designer, follow these steps to prepare the database for use:
Install and configure the required database server, network, and client software.
Install the Adaptive Server database interface.
Verify that you can connect to Adaptive Server outside DataWindow Designer.
Install the required DataWindow Designer stored procedures in the sybsystemprocs database.
Preparing an Adaptive Server database for use with DataWindow Designer involves these four basic tasks.
You must install and configure the database server, network, and client software for Adaptive Server.
To install and configure the database server,
network, and client software:
Make sure the Adaptive Server database software is installed on the server specified in your database profile.
You must obtain the database server software from Sybase.
For installation instructions, see your Adaptive Server documentation.
Make sure the supported network software (for example, TCP/IP) is installed and running on your computer and is properly configured so that you can connect to the database server at your site.
You must install the network communication driver that supports the network protocol and operating system platform you are using. The driver is installed as part of the Net-Library client software.
For installation and configuration instructions, see your network or database administrator.
Install the required Open Client CT-Library (CT-Lib) software on each client computer on which DataWindow Designer is installed.
You must obtain the Open Client software from Sybase. Make sure the version of Open Client you install supports all of the following:
The operating system running on the client computer
The version of Adaptive Server that you want to access
The version of DataWindow Designer that you are running
Make sure the Open Client software is properly configured so that you can connect to the database at your site.
Installing the Open Client software places the SQL.INI configuration file in the Adaptive Server directory on your computer.
SQL.INI provides information that Adaptive Server needs to find and connect to the database server at your site. You can enter and modify information in SQL.INI by using the configuration utility that comes with the Open Client software.
For information about setting up the SQL.INI or other required configuration file, see your Adaptive Server documentation.
If required by your operating system, make sure the directory containing the Open Client software is in your system path.
Make sure only one copy of each of the following files is installed on your client computer:
Adaptive Server interface DLL
Network communication DLL (for example, NLWNSCK.DLL for Windows Sockets-compliant TCP/IP)
Database vendor DLL (for example, LIBCT.DLL)
In the DataWindow Designer Setup program, select the Typical install, or select the Custom install and select the Adaptive Server Enterprise (ASE or SYC) database interface.
Make sure you can connect to the Adaptive Server database server and log in to the database you want to access from outside DataWindow Designer.
Some possible ways to verify the connection are by running the following tools:
Accessing the database server Tools such as the Open Client/Open Server Configuration utility (or any Ping utility) check whether you can reach the database server from your computer.
Accessing the database Tools such as ISQL (interactive SQL utility) check whether you can log in to the database and perform database operations. It is a good idea to specify the same connection parameters you plan to use in your DataWindow Designer database profile to access the database.
