Eric,
Are you using Merant's ODBC driver? If so, you would use the Progress "User
DSN" to connect the report to the database. You could also setup a System
DSN but is truely not needed. I don't know any other way to connect if you
are using another driver. If you need more specifics as to the information
needed in the connect options, Merant has a very good Tech Support. At
least I think so.
Roy Bosworth
Senior Manager IT/MIS
-----Original Message-----
From: Eric Nelson [mailto:enelson@...]
Sent: Tuesday, August 08, 2000 5:18 AM
To: vantage@egroups.com
Subject: [Vantage] ODBC & Crystal Reports
Hello Everyone,
I'm modifying a Crystal Reports (Return Authorization) that I will
make into an exe and fire when a user presses a button on a VB form.
I can make the button, I can even make the report attempt to fire. I
cannot figure out how to 'Hook it up' to the Vantage DB.
I'm guessing that it is an ODBC issue. I can get to a point in
Crystal where I can open a DB connection but I don't know what I am
to connect to - the DB on the network or the DBF's on the local
machine. Do I use a Paradox (.db) format or some other type? How is
this ODBC going to affect other users? Will the compiled report do
all the ODBC stuff automatically?
Can somebody who has done a similar report walk me through opening a
DB connection in Crystal?
Thanks in advance!
eric
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Are you using Merant's ODBC driver? If so, you would use the Progress "User
DSN" to connect the report to the database. You could also setup a System
DSN but is truely not needed. I don't know any other way to connect if you
are using another driver. If you need more specifics as to the information
needed in the connect options, Merant has a very good Tech Support. At
least I think so.
Roy Bosworth
Senior Manager IT/MIS
-----Original Message-----
From: Eric Nelson [mailto:enelson@...]
Sent: Tuesday, August 08, 2000 5:18 AM
To: vantage@egroups.com
Subject: [Vantage] ODBC & Crystal Reports
Hello Everyone,
I'm modifying a Crystal Reports (Return Authorization) that I will
make into an exe and fire when a user presses a button on a VB form.
I can make the button, I can even make the report attempt to fire. I
cannot figure out how to 'Hook it up' to the Vantage DB.
I'm guessing that it is an ODBC issue. I can get to a point in
Crystal where I can open a DB connection but I don't know what I am
to connect to - the DB on the network or the DBF's on the local
machine. Do I use a Paradox (.db) format or some other type? How is
this ODBC going to affect other users? Will the compiled report do
all the ODBC stuff automatically?
Can somebody who has done a similar report walk me through opening a
DB connection in Crystal?
Thanks in advance!
eric
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)