You perform several basic steps to use a native database interface to access a database.
The first step in connecting to a database through a native database interface is to prepare to use the database. Preparing the database ensures that you will be able to access and use your data in DataWindow Designer.
You must prepare the database outside DataWindow Designer before you start the product, then define the database interface and connect to it. The requirements differ for each database—but in general, preparing a database involves four basic steps.
To prepare to use your database with DataWindow Designer:
Make sure the required database server software is properly installed and configured at your site.
If network software is required, make sure it is properly installed and configured at your site and on the client computer so that you can connect to the database server.
Make sure the required database client software is properly installed and configured on the client computer. (Typically, the client computer is the one running DataWindow Designer.)
You must obtain the client software from your database vendor and make sure that the version you install supports all of the following:
The operating system running on the client computer
The version of the database that you want to access
The version of DataWindow Designer that you are running
Verify that you can connect to the server and database you want to access outside DataWindow Designer.
For specific instructions to use with your database, see “Preparing to use the database” in the chapter for your native database interface.
After you prepare to use the database, you must install the native database interface that accesses the database.
Once you are ready to access the database, you start DataWindow Designer and define the database interface. To define a database interface, you must create a database profile by completing the Database Profile Setup dialog box for that interface.
For general instructions, see “About creating database profiles”. For instructions about defining database interface parameters unique to a particular database, see “Preparing to use the database” in the chapter for your database interface.
When you use DataWindow Designer to define or edit a DataWindow object, make sure you specify the same connection parameters for the database in both DataWindow Designer and DataWindow .NET. Otherwise, you will be unable to use the DataWindow object in your application.
The following chapters give general information about using each native database interface. For more detailed information:
Check to see if there is a technical document that describes how to connect to your database. Any updated information about connectivity issues is available from the Sybase Support Web site.
Ask your network or system administrator for assistance when installing and setting up the database server and client software at your site.
