Newbie question re creating tables

B

banjodog

New Member
I am completely new to Progress OpenEdge and have downloaded the evaluation version.

I just want to create a database with a couple of simple tables in it.

I have created a database using the DataBase Admin tool.

How do I create tables? Do I use the Data Dictionary? When I try to use Data Dictionary it says it is in read only mode and I cannot create tables.
 
It sounds like you didn't install the 4gl development license - just the database license. You'll need the 4gl license to create tables.

You might try creating a database that is already populated with tables and data.

The command below should create a database called testdb that is a copy of the sports2000 database in the %DLC% directory. I'm guessing you are on windows, but it would work on unix as well.

prodb testdb %DLC%\sports2000
 
OK, thanks, I created a copy of the sports2000 database (yes I am on windows)

I now want to test accessing this database from a 3rd party tool(DBVisualizer) using JDBC. Don't suppose you know which files contain the jdbc drivers for OpenEdge 10.2B?
 
Look in your odbc admin tool. There should be a driver installed for OpenEdge.

Also when you start your test db, you'll need to define a -S <port number> for DBVisualizer to connect.
 
Nothing in the windows Control Panel...Admin Tools...ODBC if that is what you mean.

I need to tell DBVisulizer what JDBC driver files to use, as it does not have one for Progress/OpenEdge
 
Did your trial software come with several different license keys that you could add ? The ODBC or JDBC driver may be included in a separate product - I think it is called SQL Client access or something like that. The product containing the ODBC / JDBC driver is free, so I'm guessing it is there somewhere.
 
<<Also when you start your test db, you'll need to define a -S <port number> for DBVisualizer to connect>>

OK, is there a specific port number I need to use?
 
You can use any TCP port that isn't already in use on your DB server. It's best to stay away from the ranges below 1024 and above 32000. If you like, you can give the service a name in your OS services file (/etc/services or <windows dir>\system32\drivers\etc\services), and then use -S <service name> in your command line, instead of the port number.
 
Thanks for all your help...but I think it would be helpful if you could clarify what commands I should be running.

I have created mynewdb as a copy of sports2000 using the prodb command

After that what commands do I need to run to start the database so that I can connect to it via JDBC?

The documentation is a bit confusing...I am not sure if I need to run proserve or dbman....or both?

Thanks
 
You must log in or register to reply here.
Back
Top