Hi,
I unable to connect to remote database in Openedge.
Actually, while doing development in mfg/pro, we will connect to database through putty and will do development and compile.
I want to do the same using openedge studio.
Kindly suggest the process.
Thanks & Regards,
Vitoba Piska.
To start with, make sure you have an project created (from the File menu). During the new project creation you can provide access the list of databases configured in the work space.
If you already have aproject, then select project->properties, select the openedge->databases node. From there you can link to the workspace configured databases.
You'll need to know the database name, host, and port, and login information for the database you want to connect to.
Thanks Matt.
Kindly suggest me to do steps for connecting DB.
I went to properties->progress Openedge->Database Connections->cofigured database connections->new.
After that, I am getting confusion with Physical name ,logical name.
My Server is 192.168.2.10.
Kindly help me any reference.
t.[View:/cfs-file/__key/communityserver-discussions-components-files/26/Screenshot_5F00_OED.docx:320:240]
- display bob.fred <-- requires that the connected database have either a physical name or logical name of bob
- display fred <- the database name doesn’t matter since you only reference the table name
- display orange.fred <- requires a logical name of orange since the real database name is bob but the code references it is orange
For that dialog you need 3 values. The database name, the port number, and the machine name. You might need user+password. I'll ignore that for now.
In your case the database name is on a different machine so only put in the database name, not the full path to the database.
Then put in the database host and database port fields. You can use IP asddress or hostname, either should work as long as the machine is accessible.
And optionally user+password.
Check with your database admin, they may provide other switches you might need such as logical name.
Use the 'test connection' button to make sure you get it right.
Finish the wizard. You don't NEED the SQL stuff, in the rest of the wizard, PDS can get by without it, but a few things won't work. So if you know the connection details for the SQL database connection to the same database, fill those in. Often they are exactly the same as the ABL connection details.
Once you're done with the wizard, you should end up back at the project properties database page. Hit the checkbox on the right row in the table, and press ok.
That's it, you're done.
Thanks Brian.
Once I connect to DB, I will let you know.