Connections

[Chris Kelleher]

Hello!
I'm using an evaluation version of Webspeed, and it's working fine to
connect to local (on the same machine) demo databases, but I can't seem to
get it to connect to other databases on a separate box.
Here's the specs:
Webspeed is running on NT
The Progress databases I want to connect to are on another machine (called
gms2) - HPUX 10.2 progress 7.3E
What will the connection string (agent thingy) look like, and how do I
troubleshoot errors with the connection?
Is there anything you have to do on the HP box (like start a broker or a
service or....) to allow Webspeed to connect?
Thanks
Rich
GMS

 

[Chris Kelleher]

You need to install client networking.

Regards,

Sean Overby
Sr. Programmer Analyst
Protech Systems Inc.
soverby@protech.com http://www.protech.com
Stulti timent Fortunam, sapientes ferunt

 

[Chris Kelleher]

What version of Webspeed? You will not be able to connect to v7 db from WS
3. Progress is only backward compatible with the previous major release!

Otherwise...

Can you connect to the remote database from the webspeed machine with just a
regular Progress client? Can other remote machines connect to that database
( not telnet clients, real remote connections)?

Mario

 

[Chris Kelleher]

sorry, didn't read the rest of it.

If you want to connect remotely:

client networking on the webspeed box (they're basically just progress
sessions after all).
workgroup or enterprise server on the db box.
yes, u need to run a db broker.
connect string for ws agent: -db urDbName -H urDbHost -N tcp -S
urDbServiceName

Regards,

Sean Overby
Sr. Programmer Analyst
Protech Systems Inc.
soverby@protech.com http://www.protech.com
Stulti timent Fortunam, sapientes ferunt

 

[Chris Kelleher]

Hi Richard,

First of all, what's tour webspeed version ? If It's V3, I don't think you
can connect to a V7 database since V3 is based on V9 of Progress.

The connection parameters for your agent should look like

-db dbname -H hostname -S servicename -N tcp

Your DB server on the HP machine should have been started with the same
parameters (only the -S and -N are required)

Possible errors:

Hostname is not found (Do you have a hosts file on the Webspeed machine)
Service is not found (You need to add servicename in the service file)
Services number do not match for servicename in your service file on both
machines

Send the error you are getting, maybe we can get a better idea.

 

[Chris Kelleher]

In addition to what others have said, if you still have problems give the
'-Nv 12' setting a try. This was always helpful in getting WebSpeed 2.1 to
connect to V6 databases. I haven't had the need to try it with WS3 but I
suspect it won't work there.

Have a great day,

Brian

Brian Laferte brianl@webspeedconsulting.com
President

Progressive Systems Technology, Inc. http://www.webspeedconsulting.com

P: 401-762-4905
F: 401-767-5337

 

[Chris Kelleher]

Thanks for responses I've gotten
Conecting to 1 remote database works great.
What's the syntax for connecting to more than 1 database? (6 to be exact)
For 1, I've got:
blah blah .... /rd/data/trhead.db -H gms2 -S prhead -N tcp -1
If I do more than 1, do I need commas? quotes? etc....
Thanks
Rich

 

[Chris Kelleher]

I don't think you need to specify the full path for the database when you
connect. I have a multiple database connection and it looks something like
this:

blah blah... -db first_logical_db -H hostname -S servicename -N TCP -db
second_logical_db -H hostname -S servicename

Notice that you don't need to specify the "-N TCP" a second time. So an
actual statement would look like:

... -db firstdb -H jooky1 -S fdbsv -N TCP -db seconddb -H jooky1 -S sdbsv

RTS

 

[Chris Kelleher]

No, just add all six connect string one after the other. This is where pf
files start to come in handy. But progress does have a startup parameter the
sets the limit of connected databases, and I think the default is 5. So you
may have to look into that.

Mario

 

[Chris Kelleher]

No, you don't need commas.

If you're connecting to 6 DBs, you'll need to bump
up -h (max # of DBs your Progress session can connect
to) because the default is 5.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
R o b e r t J. M i r r o
rmirro@microserve.net http://www.microserve.net/~rmirro/

I have lost the will to live
Simply nothing more to give
There is nothing more for me
Need the end to set me free
- Metallica
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

 

[Chris Kelleher]

You will need to start the HP-UX DB server with the -S -H and -N parameters.
Then add the same parameters to your agent startup string. Be sure the service
named in the -S parameter is using the same TCP port on both machines.

__________________________________
Tony Auerbach
Application Solutions Specialist
SCS
(972) 550-7666 Ext. 2132
auerbaa@ccgate.dl.nec.com http://www.scsglobal.com