Actually, if you set-up your Vantage 5.0 (Progress 9.1A) or 5.1 (Progress
9.1C) database server stating that it would be both 4GL and SQL-92 (which is
the default set-up option), there is no additional set-up required for ODBC
on the server side. Simply set-up an ODBC datasource on the workstation
using the Merant 3.6 SQL92 Progress 9.1X driver that is automatically
installed when installing the Progress client on the workstation. The same
port number can be used that is used in accessing Vantage. Of course, if
there is going to be intensive ODBC calls/routines, it would better to
set-up a separate database server in Progress Explorer strictly for ODBC.
In other words, I would only use the same database server if my ODBC calls
were infrequent.
One additional note, the drivers for 9.1A seem to still be less than
reliable and stable in all circumstances. However, our work so far with the
9.1C drivers has proved to be much more stable and reliable (at least so
far).
Of course, all of this is moot if you are not on at least version 5.0.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, February 07, 2002 8:20 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Merant ODBC driver for custom traveler
Brent,
The process is exactly the same as it has been since 3.0. If you are
using ProControl, you add a broker that starts whenever Vantage is started.
Is the SQL-92 driver easier? Yes, perhaps. Does it work for what you want
it to do? No.
So Merant is the next easiest thing, unless you want to go through the pain
of exporting each table/field you want and then risk that your data is not
up-to-date. Or worse yet, you can call Custom Programming to get the extra
field you want and then pay again each time you upgrade to a new version.
Merant ODBC is the way to go for us. And why Epicor wouldn't help you
set it up, I don't know. They used to help set up the basic ODBC driver
because they actually sold it, but perhaps they don't now because they are
recommending the SQL-92 drivers.
You can also add yourself to this call number (# 748545) which my
original call to fix the Error 599 which comes up when trying to use SQL-92
in Vantage when adding a new field to the table. If Epicor/Progress would
fix the SQL-92 driver, I would be glad to use it. Until then....
And actually, if you count all the steps to set up the ODBC process in
Progress Explorer tool, it's not really any more to set up the broker for
ODBC in Procontrol.
I'd be glad to help you if I can.
Troy Funte
Liberty Electronics
9.1C) database server stating that it would be both 4GL and SQL-92 (which is
the default set-up option), there is no additional set-up required for ODBC
on the server side. Simply set-up an ODBC datasource on the workstation
using the Merant 3.6 SQL92 Progress 9.1X driver that is automatically
installed when installing the Progress client on the workstation. The same
port number can be used that is used in accessing Vantage. Of course, if
there is going to be intensive ODBC calls/routines, it would better to
set-up a separate database server in Progress Explorer strictly for ODBC.
In other words, I would only use the same database server if my ODBC calls
were infrequent.
One additional note, the drivers for 9.1A seem to still be less than
reliable and stable in all circumstances. However, our work so far with the
9.1C drivers has proved to be much more stable and reliable (at least so
far).
Of course, all of this is moot if you are not on at least version 5.0.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, February 07, 2002 8:20 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Merant ODBC driver for custom traveler
Brent,
The process is exactly the same as it has been since 3.0. If you are
using ProControl, you add a broker that starts whenever Vantage is started.
Is the SQL-92 driver easier? Yes, perhaps. Does it work for what you want
it to do? No.
So Merant is the next easiest thing, unless you want to go through the pain
of exporting each table/field you want and then risk that your data is not
up-to-date. Or worse yet, you can call Custom Programming to get the extra
field you want and then pay again each time you upgrade to a new version.
Merant ODBC is the way to go for us. And why Epicor wouldn't help you
set it up, I don't know. They used to help set up the basic ODBC driver
because they actually sold it, but perhaps they don't now because they are
recommending the SQL-92 drivers.
You can also add yourself to this call number (# 748545) which my
original call to fix the Error 599 which comes up when trying to use SQL-92
in Vantage when adding a new field to the table. If Epicor/Progress would
fix the SQL-92 driver, I would be glad to use it. Until then....
And actually, if you count all the steps to set up the ODBC process in
Progress Explorer tool, it's not really any more to set up the broker for
ODBC in Procontrol.
I'd be glad to help you if I can.
Troy Funte
Liberty Electronics