Consultor Eletrônico

Status: Unverified

GOAL:

How to connect to a local 10.2B progress database from OpenEdge Architect 10.2B

GOAL:

OpenEdge database connection from OpenEdge Architect 10.2B

GOAL:

Start a local OpenEdge database and connect to it from OpenEdge Architect 10.2B

FACT(s) (Environment):

OpenEdge 10.2B
Windows

FIX:

First in C:Windows\System32\drivers\etc (on a 32 bit windows version) add a line to the 'services' file such as:
MyDBservice 20000/tcp #Do not use the tab key when entering the information
Launch proenv (Start -> All Programs -> OpenEdge -> Proenv)
To start the database type:
proserve myDB -S MyDBservice -N TCP

Open the OpenEdge Architect
To create a Database connection
Select the Window Menu
Select preferences
Select OpenEdge Architect
Select Advanced
Select Database Connections
Select New...
In the field 'Connection name' fill in a name for the connection:
Example
myDB
In the field 'Physical name' fill in the path to your database:
Example
C:\OpenEdge\WRK102B\DB_location\myDB.db
In the field 'Host name' fill in 'localhost' if making a local connection or enter the hostname of the machine where the database is running if making a remote connection.
In the field 'Service/Port' fill in the name of the service you added in the ?services? file:
Example:
MyDBservice
Click on the button 'Test Connection', the message 'Connection succeeded' should now appear.

After all testing is completed the command to shutdown the database is:
proshut myDB