Error "[JDBC Progress Driver]:No Data" from SQL Explorer Tool

[tkhong]

Hi,
I get "[JDBC Progress Driver]:No Data" when trying to connect to a database. Here's what I did on a Windows XP box:
1. Installed WebSpeed 9.1E
2. Ran "proadsv -start" from proenv - AdminServer does not show up in Severvices for some reason.
3. using Data Adminstration, created a database from a copy of Sports database using default values - network = <None>
4. Use SQL Explorer to connect to the database and receive the "[JDBC Progress Driver]:No Data" error message.

When I tried to create a DSN using Data Direct 4.10 ODBC driver I get similar error with ODBC instead.

Can anybody tell me what I'm doing wrong or if I missed some steps in between.

Thanks in advance!

Also, this is an eval copy of Progress so it is a single user system, if that matters.

 

[Casper]

Hi,

Do you connect to the correct portnumber?
You don't need the adminserver to connect to a database with sql explorer.
Do you use a secondary SQL broker?
How do you start the database?

Also, this is an eval copy of Progress so it is a single user system, if that matters.

Unfortunately I don't know what you can do and can't do with an evaluation license....

Regards,

Casper.

 

[tkhong]

Casper,
Thanks for the reply. This is my first experience with Progress so I don't quite understand what you mean by secondary broker. I tried to launch Open Interface Broker and nothing happens. Could this be a clue?

1. I am using port 20931 which I'm assuming is the default. If I use anything else, I get the "Error in Network Daemon" message so I assume the port is correct.
2. Using Data Administration, I'm able to export data to a text file. I guess this does not mean the db is started.
3. I added and tried to start the database from Progress explorer I get the message stating that the db is not networked and if I proceed, I get "Error in startup of database... Message: time BROKER :** This process terminated with exit code 1. (8619)(JUNMsg024)".

Thanks for your help, again.
tk

 

[Casper]

Hi,

This is my first experience with Progress so I don't quite understand what you mean by secondary broker. I tried to launch Open Interface Broker and nothing happens. Could this be a clue?

well first of all, I think you have to read up on Progress:
http://www.progress.com/products/documentation/openedge10_1a_pdf/index.ssp

The open interface broker is not the best way to make connection with an SQL client to the database.

For making sql connections see knowledgebase articles:

20143: http://tinyurl.com/o77l5
18757: http://tinyurl.com/r8hhr
http://www.progress.com/products/documentation/openedge10_1a_pdf/index.ss
Regards,

Casper.

 

[tkhong]

Casper, thanks. The knowledge article is exactly what I needed.

from proenv run
"proserve dbname -S port#" will start the database.