Progress
DataServer for
Microsoft SQL Server
Guide
Connecting a Schema Holder
As described previously, connection can take place automatically using the information that you enter when you create a schema holder. In addition, Progress provides the following techniques for connecting to a schema holder:
- Use the Progress Data Dictionary or Data Administration tool. From the main menu, select Database
Connect and supply the schema holder’s physical name and the appropriate connection parameters. You can then select your SQL Server™ database as your working database and connect to it.
- Use the Progress 4GL CONNECT statement (see its reference entry in the Progress Language Reference). A CONNECT statement must first list the schema holder and related connection parameters, then the SQL Server™ database and related parameters.
This command connects a schema holder named mssholder and SQL Server™ database named mssdemo:
- Use connection parameters when you start Progress. You can include these parameters on the program item command line or in a parameter file that you specify when you start Progress. A parameter file is portable and easy to maintain. For information on creating a parameter file, see the Progress Startup Command and Parameter Reference.
You can use combinations of different connection techniques. For example, you can connect the schema holder at startup, then connect to the DataServer using the Progress CONNECT statement. If the proper connect information is stored in the schema holder, referencing a table in the SQL Server™ database will cause the DataServer to issue the connect statement automatically. Any combination of connection techniques works, as long as you follow these steps in the order shown:
If you connect to the schema holder and the SQL Server™ database in a single startup command or connection statement, be sure to specify parameters that affect the schema holder before the Database Name (-db) parameter. Specify only those parameters that affect the SQL Server™ database connection after the -db parameter.
The following section explains how to connect both a schema holder and a SQL Server™ database when you start up Progress.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |