[progress Communities] [progress Openedge Abl] Forum Post: Re: Pdsoe Novice

[sdobbey]

Hi grolfe, Here, the problem seems to be with sports2000 database in installation directory. Instead, try creating a new sports2000 database. Here are the steps to create new database from PDSOE: 1. Go to menu Window -> Show View -> Other 2. Show View dialog box appears. Expand 'Progress DB Navigator' node and select 'Connections' option from it. 3. Connections view will be displayed. 4. Click on 'View menu' option in connections view (down arrow icon). 5. Select 'Create OpenEdge Database'. 6. Create Database dialog will be displayed. Browse to a location where you want to create database (ex: C:\DLCWORK\database) and provide database name as sports2000. Click save. 7. Select 'A copy of the SPORTS2000 database' radio button and click 'Ok'. 8. Database creation dialog will appear stating that Database 'sports2000' has been successfully created. Click 'Ok'. 9. Go to Window -> Preferences. Expand Progress OpenEdge node and select Database Connections. 10. Database Connections table will appear beside. 11. Click on New provide any connection name (ex: sportsConn). 12. Browse to the created sports2000 database location (ex: C:\DLCWORK\database) and select sports2000.db from it. 13. Provide Hostname as localhost and any free port (ex: 9574) 14. Click Next until you reach the Define Data Server Configuration page and click Finish. 15. Click Ok. 16. Now connect the created database to project: a. Right click on project select 'Properties' b. Expand Progess OpenEdge node and select Database Connections. c. Database connections will be displayed select 'Show all' radio button then all database connections will be displayed. d. Select New created database connection and click ok. 17. To ensure database is connected successfully check if below message is displayed in console or not Starting database server 'C:/DLCWORK/database/sports2000.db' (-S 9574) Project 'CustomerReport' runtime connection to ' sports2000' : OK As an alternative, you can create sports 2000 DB from PROENV using following command: prodb sports2000 For the second question, Could you please tell the error message you are seeing? You can check the status of the appserver from proenv console. Open proenv from start -> All Programs -> Progress -> Proenv And type this command 'asbman -i asbroker1 -q' It will show you the status of appserver. Hope this helps, Sneha.

Continue reading...