Kbase P96490: How to create a MS SQL Server DataServer schema holder in UNIX?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/09/2008 |
|
Status: Verified
GOAL:
How to create a MS SQL Server DataServer schema holder in UNIX?
GOAL:
How to create a MS SQL Server schema holder in UNIX?
FACT(s) (Environment):
UNIX
MS SQL DataServer
Progress 9.1B
Progress 9.1C
Progress 9.1D
OpenEdge 10.x
FIX:
In order to create a SQL Server DataServer schema holder in UNIX, you need to run the DataServer broker in Windows machine. There are two brokers for the DataServer - One is the called unified broker (mssbroker1) which is SQL Server DataServer specific, and the other one is a default broker (_probrkr). You can run mssbroker1 using Progress Explorer and command prompt (refer to the DataServer for Microsoft SQL Server Guide for details) or _probrkr using proControl (only with Progress Version 9.1x) or command prompt (refer to the "Windows Server" section of the solution P22754). After you start the broker on the Windows machine, you can use UNIX machine to create the schema holder. The only progress product you need in the UNIX machine is the Progress Client Networking. Here are the steps to create the schema holder in UNIX: It is always a good practice to set the DLC and append the $DLC/bin to the beginning of the PATH and export each of those environment variables. You can also use the progress environment (proenv) by running the proenv script in the $DLC/bin folder. The proenv script creates a proenv prompt. The following steps are demonstrated in the proenv prompt. 1. Create a empty schema holder using the following command: prodb myholder empty 2. Connect to the myholder using the following command: pro myholder -rx (if you have 4GL development license, you do not need to use -rx switch) 3. On the progress editor, press F3 to get to the menu and select the tool menu > Data Dictionary 4. On the DataDictionary screen, select DataServer menu > MS SQL Server Utilities > Create DataServer Schema 5. Add the appropriate value to the corresponding field specified below: Logical Database Name: <logical name of the SQL server database>
Connection Parameters: -H <Windows machine name where the DataServer broker is running> -S <broker port number> -N TCP -U user -P password -Dsrv svub,1 (The -Dsrv svub,1 is only required when you use mssbroker1. Do NOT use it if you use default broker_probrkr)
ODBC Data Source Name: <name of the ODBC data source> 6. At the "User ID and Password" screen, you can enter the same or another user name and password but if you just click OK it will use the same username and password that have been entered from the previous screen. 7. At the "Pre-Selection Criteria For Schema Pull" window, enter the appropriate values that will be listed.
8. Once the objects are listed at the "Select MSS Objects", select the objects that you would like to pull into the Schema Holder and click OK.
9. Once complete, Progress Data Dictionary main menu will come back. The building of the Progress Schema Holder is now complete.