ODBC or SQL connect to Progress 9.0b

Yahoo Archive
1
Jonathan,
You might want to consider just using a date formula in Crystal for now.
That would give you the date printed.
I would also agree that at 4.x and Progress 9.0b, now is not the time to
attempt ODBC, especially do to the fact that you are looking at getting up
to current where this process is much easier.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of jonnyfatman666
Sent: Monday, June 13, 2005 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC or SQL connect to Progress 9.0b


I have recently started work as an IT support guy and we use Vantage
4 (Progress 9.0b).
I am currently trying to modify a goods received label in Crystal
Reports to include the received date. This date seems to be in a
different table to the ones referred to in RcvLabel.rpt and I was
wondering how to get hold of this other data.
In terms of SQL and ODBC drivers etc I am a complete novice so any
information would be helpful.
Do I need to set up some sort of ODBC on the server (NT4sp6a) before
a client computer can connect to the database.

I understand that we have a pretty old version of Vantage and
Progress but are currently in the process of upgrading our server in
order to move to a newer version of Vantage. If its easier to resolve
this problem in more recent versions then I might hold off until we
get the new Vantage.

Cheers

Jonathan Waines
RTK Instruments Ltd




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
Yahoo! Groups Links
2
I have recently started work as an IT support guy and we use Vantage
4 (Progress 9.0b).
I am currently trying to modify a goods received label in Crystal
Reports to include the received date. This date seems to be in a
different table to the ones referred to in RcvLabel.rpt and I was
wondering how to get hold of this other data.
In terms of SQL and ODBC drivers etc I am a complete novice so any
information would be helpful.
Do I need to set up some sort of ODBC on the server (NT4sp6a) before
a client computer can connect to the database.

I understand that we have a pretty old version of Vantage and
Progress but are currently in the process of upgrading our server in
order to move to a newer version of Vantage. If its easier to resolve
this problem in more recent versions then I might hold off until we
get the new Vantage.

Cheers

Jonathan Waines
RTK Instruments Ltd
3
I would not even approach ODBC with your current version of Vantage if I
didnt have to. I had nothing but trouble with it. After your move to Progress
9.1C or 9.1D it gets so much better. If I remember correctly, you also have to
purchase the ODBC driver for each client with your current version of
Progress. With a newer version, it is free.

I believe the old version of ODBC was SQL-89 and the new version is
referenced as SQL-92.

Hope that helps,
Jeremy


[Non-text portions of this message have been removed]