Trying to access demo database, but do not understand how to do

[repostor]

Hi,
I am a newbee of OpenEdge 10.x
I am trying to access a copy of the demo database, which I copied to /tmp/pro directory.
But I get this error:
"This version of PROGRESS requires a start up procedure"

I use this command to startup the server:
$ proserve /tmp/pro/demo

And I use this command to logon to the progress database
$ mpro -db /tmp/pro/demo

---------
What am I trying to achieve, is a way to use "SELECT" statements on the selected database in Progress.

Please help me.
Regards Tomas

 

[MaximMonin]

It seems you dont have a developer license, only runtime client to execute some code.
mpro -db /tmp/pro/demo -p src/test.p

 

[repostor]

Thanks,
Thats makes sence.

Unfortunally, I did not find the file src/test.p

proenv>ls src
_admin.p _edit.p _help.p _login.p _prostar.p _winevnt.p adecomm.pl adeedit.pl adm2 applhelp.p auditing extractpl login.i prostart.p web web2 workshop.w
proenv>

I dont know what to do next.
My Progress version is:
OpenEdge Release 10.1C as of Sat Feb 9 14:16:03 EST 2008
And yes; it is an evaluation license.
I am a software developer (integrator).

Regards Tomas

 

[RealHeavyDude]

You need a developer license in order to start a development tool. If you don't have a developer license then all you can do is to run pre-compiled code whether you connect to a database or not. Don't know how or where you got the evaluation license from - but it's a sure bet that, if you got it from a Progress sales rep - that he/she is keeping you on a short leash. If you got it via a Progress sales rep you need to contact him/her ...

Heavy Regards, RealHeavyDude.

 

[repostor]

Thanks,
It could be a developer license, I might be using wrong terminology.
And I got it from Progress.
I will try to get a new try license.
Regards Tomas

 

[repostor]

Hi,
I have now installed a new OpenEdge 10.x on a new machine, but the problem remains.
I even got an evaluation license for it.

Here is what I did:
# download/proinst
# proenv
# cd $DLC
# mkdir /tmp/try
# cp sports* /tmp/try
# cd /tmp/try
# proserve sports

( I guess that I can't use pro, cause the database is in multiuser mode).

# mpro sports
(returns the same error as before)

** This version of PROGRESS requires a start up procedure. (495)

Press space bar to continue.


Please suggest a solution for this.

I would like to do "INSERT/SELECT" from a database
Regards Tomas

 

[tamhas]

Given that you are one the SQL forum and mentioning SELECT statements, you really don't want mpro at all. That will, with a development license, get you to an editor where you can use ABL statements. ABL includes some basic SQL89 commands, but these are deprecated. If you really want to use SQL, you should be coming in with sqlexp or your preferred SQL client. Look at http://www.oehive.org/node/952 and/or documents on PSDN for instructions in how to set up SQL access.

 

[repostor]

Thanks,
I got it now.
It is sqlexp I should use instead.
//Tomas