Kbase 19685: How to Connect Actuate 4.x Via ODBC With Progress 9.x
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to connect Actuate via ODBC driver With a Progress 9.x database
FACT(s) (Environment):
Actuate 4.1
Actuate 5.0
Progress 9.x
FIX:
Perform these steps:
1) Create a user in your Progress database.
If you have users created go to step 2. If there are no users, Open the Data Administration or the Data Dictionary Tool, connect to the Progress Database and choose "Admin" menu -> "Security" Option -> "Edit User List" -> "Add" and create a user.
2) Start the database server
If you have started the database server for remote connection (using -S and -N parameters) go to Step 3. If not, you can use the command line, ProControl or Progress Explorer to start the Progress database. Using a command line, enter:
proserve dbname -N TCP -S servicename
3) Define the data source.
Use ODBC Administrator in the Windows Control Panel:
A) Pick the System DSN tab in the DataSource setup window.
B) Click the Add button.
C) Select "MERANT 3.50 32-Bits Progress SQL-92 Driver", if you use Progress Version 9.0B or "MERANT 3.60 32-Bit Progress SQL-92 Progress Version 9.1x" if you are using Progress Version 9.1x.
D) Fill in the information:
Data Source Name: Your identifier of the data source.
Description: A brief description of what the data source is for.
Host name: The host machine name that launched the database server. This is the same name supplied for the host (-H) parameter at startup. Normally the host name is defined in the hosts file or by the DNS server to resolve host names to IP addresses.
Port number: The service port the database server is launched with. This is the same value that was supplied for service name (-S) at startup.
Database name: The physical name of the database.(You do not need to supply the full path to the database or type the .db extension.)
User ID: Use the user created in Step 1
E) Press button "Test connect" and fill in the password. Use the password you defined in Step 1.
4) Fill in the Actuate connection folder:
A) Select a database connection: choose "ODBC".
B) DataSource: Use the Data Source name that you created in Step 3(d).
C) DisplayName: ODBC Connection.
D) DllPath: ODBC32.
E) Password: Use the password you defined in Step 1.
F) UserName: Use the user created in Step 1.