Multi Connect via ODBC

[Chris Kelleher]

Hi all:

Is it possible for an application running on a PC to simultaneously
connect to 3 Progress databases on a remote UNIX host (each in
different directories)? If it is possible, would you please give me
some info on how to set it up.

So far in my testing (using MS Query), I've only been able to
connect to a single database at a time through ODBC. I can
connect to all databases simultaneously in Client Networking on the
PC.

PC running Win 95:
ODBC application (using MS Query for testing)
Merant ODBC driver 2.53 for Progress
(Merant driver 3.x available)
Progress 8.3B Client Networking

Host - HP V-2500 using HP-UX 11:
Progress 8.3B16 -- probrkr
Many large multi-user Progress 8.3B16 databases.

Regards,
Bill Landin.

The beauty of a diamond is in its simplicity!

 

[Chris Kelleher]

I know the Merant drivers can do it and have info on how in their doc.
Don't remember the details myself.

PK

 

[Chris Kelleher]

With Merant, simply add the -db dbnames on to the additional
database parameters in the Advanced tab section. You must
specify the full path names to the databases. (make sure
the OS is set correctly or the \ vs / issue will cause
problems) All of the databases need to have unique field
names across the databases. You will not be able to
see the database through something like MS Query's Wizard.
Remember getting a list of fields and files is done by
looking at _file and _field for the dictdb alias. The
driver doesn't know about switching aliases so you
only get the first database's schema. Free form your
queries instead of the wizard.

=================================================================
Geoff Crawford Phone: (973) 361 - 4224
Innovative Client Servers FAX: (973) 537 - 6946
75 Fleetwood Drive, Suite 200 Email: geoff@innov8cs.com
Rockaway NJ 07886 Web: http://www.innov8cs.com
Orange and Black Forever

 

[Chris Kelleher]

Yes, it is psossible but remember this "You'll also have to start a PROGRESS
Database Server service PER database you want to connect to. So if you want
to connect to 3 databases at the same time you'll have to start 3 PROGRESS
Database Server services and 1 PROGRESS Broker service."

and this

"Some older versions of the "Procontrol" utility (like version 8.0 on NT,..)
are setting the PROGRESS environment variables AFTER starting the PROGRESS
Broker and Database Server services. As a direct result of this, errors will
be returned like: "PROOIDRV variable does not contain Open Access Driver
module. (2660)". Therefore it’s recommended that you start (at least) the
PROGRESS Broker service manually (via shell-scripts/batch-files). Afterwards
you can always try to get it working from within the Procontrol utility.
PROGRESS Software reported this problem to be fixed in later versions of
Procontrol."

Victor.

 

[Chris Kelleher]

This one is not true on two accounts. First, by "Progress Database
Server service" it implies -H -N -S. ODBC should never involve
-H -N -S. You do not need it and it kills performance.
It is also not true you need to start a server at all.
It could always be done single user. Just add -1 to the
database advanced options in the DSN.

This is assuming the discussion is about Merant. Other
drivers work the same way, only with different methods
to achieve the same thing.


=================================================================
Geoff Crawford Phone: (973) 361 - 4224
Innovative Client Servers FAX: (973) 537 - 6946
75 Fleetwood Drive, Suite 200 Email: geoff@innov8cs.com
Rockaway NJ 07886 Web: http://www.innov8cs.com
Consulting, Performance Tuning, & Author of the Progress ODBC FAQ

 

[Chris Kelleher]

>This is assuming the discussion is about Merant.

I don´t assuming nothing, Bill wrote this

>>PC running Win 95:
ODBC application (using MS Query for testing)
Merant ODBC driver 2.53 for Progress
(Merant driver 3.x available)
Progress 8.3B Client Networking<<

>Other drivers work the same way, only with different methods
>to achieve the same thing.

I don´t know the other drivers, because the question is with Merant.

And I staying my answer, if this kill or not the performen is Bill who
should decide if it is this way or not.

More exactly the connection is built up as follows:
Client ODBC application =>
MERANT DataDirect Connect PROGRESS 7/8 ODBC driver => PROGRESS Client
Networking Software =>

PROGRESS Broker service =>
PROGRESS Server service =>
PROGRESS Database file

Victor.

 

[Chris Kelleher]

Hi bill,

in advanced tab htere is a database connection options field that
you can use, don,t forget to update services file.

Marco Aurelio de Pasqual

 

[Chris Kelleher]

hi geoff,

For what i understand a database should be "served" with "-S"
parameter to be accessed through a network. And that's what was happening
the databases were in hp-ux and progress in w95. Is there another way to
connect database without using -H -S -N in this case? I have this situation
and it's really killing performance, i would be glad to know a better way to
connect multi-user databases using ODBC without these parameters.

Thank you

Marco Aurelio de Pasqual

 

[Chris Kelleher]

Best way to connect to a databse in Unix from windows is using TCP. I was
told by progress that you can not connect to progress databse from progress
client using ODBC. To do this
on the server
edit the services file with a services name.
and start the server as proserve dbname -H host -N TCP -S services name.]
at client edit the host file and services file in windows it is in windows
directory in workstation or server it is in winnt/system32/drivers/etc
directory.
then from the progress client type connect dbname -H host -S servicename -N
TCP

Akan T Rajah