One way I have gotten past the issue of "stale" exported data is to create a
new .r file to launch the report from Vantage.
In this example it exports the DMRCorAct table to the DMRCorAc.txt file then
launches an Access database that contains the report. It could just as
easily launch the original .r file that runs the report. We use this to
make sure our reports are as current as possible. By the way, just to give
credit where credit is do, I found most of this code in the Vantage file
area here on vantage groups site. There was also some other code on the
site that Thaddeus had written that exported the data directly to an mdb
file but I could never get it to work. Said It was missing a file. If you
could get that to work it would be much slicker. And FYI, if your on
Progress 9.1A or higher, the ODBC driver is free.
DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.
OUTPUT TO c:\vntgwork\DMRCorAc.txt.
FOR EACH DMRCorAct:
EXPORT DELIMITER "~011" DMRCorAct.
END.
OUTPUT CLOSE.
ASSIGN ProgName = 'msaccess.exe'
ProgOption = 'v:\vantage\ud\dmrlkup\access\dmrlkup.mde'.
RUN v:\vantage\lib\ShellExec.r (INPUT ProgName,
INPUT ProgOption,
OUTPUT hInstanceNum).
Jeremy Leonard
IT Manager
K-T Corp
-----Original Message-----
From: tbfbranch [mailto:tfunte@...]
Sent: Monday, July 22, 2002 8:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC drivers for Crystal 8.0
Jennifer,
Linking a Vantage form to a new table is POSSIBLE, but TRICKY.
The only way to do it with the SQL-92 drivers is by exporting the
vantage data to a text file, "link" in inside Access to the exported
file, and then connect the Crystal (Vantage) form to the Access
database. I've tested this method and it does work. The drawback is
that the data is only as fresh as the export it.
The easier way of linking via ODBC requires using the actual
Merant/Datadirect drivers. The progress drivers, because they
require a username/password to connect to ODBC don't work in the
Vantage reports. The Merant drivers are about $100 per PC last we
checked a few years ago.
If you need more details, let me know. There was a recent thread
about this last week also with more details.
Troy Funte
Liberty Electronics
(reply directly to tfunte@...)
new .r file to launch the report from Vantage.
In this example it exports the DMRCorAct table to the DMRCorAc.txt file then
launches an Access database that contains the report. It could just as
easily launch the original .r file that runs the report. We use this to
make sure our reports are as current as possible. By the way, just to give
credit where credit is do, I found most of this code in the Vantage file
area here on vantage groups site. There was also some other code on the
site that Thaddeus had written that exported the data directly to an mdb
file but I could never get it to work. Said It was missing a file. If you
could get that to work it would be much slicker. And FYI, if your on
Progress 9.1A or higher, the ODBC driver is free.
DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO.
DEFINE VARIABLE ProgOption AS CHARACTER NO-UNDO.
DEFINE VARIABLE hInstanceNum AS INTEGER NO-UNDO.
OUTPUT TO c:\vntgwork\DMRCorAc.txt.
FOR EACH DMRCorAct:
EXPORT DELIMITER "~011" DMRCorAct.
END.
OUTPUT CLOSE.
ASSIGN ProgName = 'msaccess.exe'
ProgOption = 'v:\vantage\ud\dmrlkup\access\dmrlkup.mde'.
RUN v:\vantage\lib\ShellExec.r (INPUT ProgName,
INPUT ProgOption,
OUTPUT hInstanceNum).
Jeremy Leonard
IT Manager
K-T Corp
-----Original Message-----
From: tbfbranch [mailto:tfunte@...]
Sent: Monday, July 22, 2002 8:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC drivers for Crystal 8.0
Jennifer,
Linking a Vantage form to a new table is POSSIBLE, but TRICKY.
The only way to do it with the SQL-92 drivers is by exporting the
vantage data to a text file, "link" in inside Access to the exported
file, and then connect the Crystal (Vantage) form to the Access
database. I've tested this method and it does work. The drawback is
that the data is only as fresh as the export it.
The easier way of linking via ODBC requires using the actual
Merant/Datadirect drivers. The progress drivers, because they
require a username/password to connect to ODBC don't work in the
Vantage reports. The Merant drivers are about $100 per PC last we
checked a few years ago.
If you need more details, let me know. There was a recent thread
about this last week also with more details.
Troy Funte
Liberty Electronics
(reply directly to tfunte@...)
--- In vantage@y..., "Jennifer Schneider" <jschneider@d...> wrote:
> We are on Vantage 5.1. I can update the forms as long as I don't
want to link a new table to them. If I try to do this I get error
after error. We are using the MERANT 3.60 32-BIT Progress SQL92
v9.1C driver. We have installed several patches, but still don't
seem to be able to connect the way that we should. Does anyone have
any suggestions for me to try.
>
>
> [Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/