MSACCESS to Progress via ODBC?

Yahoo Archive
1
We link to Vantage via Access using ODBC Merant 3.5. What exactly are you
looking for?


-----Original Message-----
From: Bruce D. Allen [mailto:ballen@...]
Sent: Friday, August 03, 2001 8:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] MSACCESS to Progress via ODBC?

We are in need of some documentation / installation procedures to create a
DSN for a MSACCESS to Progress link.
Anybody using Merant 3.50 ODBC?
Thanks,
Bruce D. Allen
Bracalente Mfg Co Inc
Vantage 4.00.807 Progress 9.0B


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, August 01, 2001 1:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 5.0 - ODBC Stability?



We are still on Vantage 4.0. We use ODBC to run some external applications
in MS Access linking to Vantage data in read-only mode. We also did the
same on Vantage 3.0. When we were on 3.0, it worked very smoothly, very
rarely was there a problem. Since we have been on 4.0 (over a year), we
find the ODBC connection to be very unstable, as I know others have. I was
wondering if anyone is using ODBC with 5.0 and if there have been
improvements in the stability?

Thanks,

Sarah


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/



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/
2
We are still on Vantage 4.0. We use ODBC to run some external applications
in MS Access linking to Vantage data in read-only mode. We also did the
same on Vantage 3.0. When we were on 3.0, it worked very smoothly, very
rarely was there a problem. Since we have been on 4.0 (over a year), we
find the ODBC connection to be very unstable, as I know others have. I was
wondering if anyone is using ODBC with 5.0 and if there have been
improvements in the stability?

Thanks,

Sarah
3
Hi Sarah,
I'm testing it now with 5.0 and there are till issues. Mainly, but not
limited to, the 255 character limit in Access fields.
I have a zip file from Tech Support that I will email to you. It contains
information on a fix that they claim will corrected
MOST of the issues. I haven't tried it yet, so I can't confirm the claim.

Les Tingley
Decorated Products

> -----Original Message-----
> From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
> Sent: Wednesday, August 01, 2001 1:53 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Vantage 5.0 - ODBC Stability?
>
>
> We are still on Vantage 4.0. We use ODBC to run some external
> applications
> in MS Access linking to Vantage data in read-only mode. We also did the
> same on Vantage 3.0. When we were on 3.0, it worked very smoothly, very
> rarely was there a problem. Since we have been on 4.0 (over a year), we
> find the ODBC connection to be very unstable, as I know others have. I
> was
> wondering if anyone is using ODBC with 5.0 and if there have been
> improvements in the stability?
>
> Thanks,
>
> Sarah
>
>
> 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/
>


[Non-text portions of this message have been removed]
4
We are using 5.0 with ODBC driver 3.5 (not 3.6 which doesn't seem to allow
more than 3 joins--3.6 ships with 5.0). Works very well. We had no issues
with ODBC in 4.0 either. I would recommend staying with the 3.5 driver. I
didn't have a do a thing when upgrading--the reports worked without any
adjustments.

Alex Neutgens
Controller
Circuit Check, Inc.
Phone 763-694-4110
Fax 763-694-4151

-----Original Message-----
From: sarah.vareschi@... [SMTP:sarah.vareschi@...]
Sent: Wednesday, August 01, 2001 12:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 5.0 - ODBC Stability?

<< File: ATT00027.htm >>
5
I am using the 3.5 drive as well, and what happens is, when we open the
linked table, or a query, form or report based on linked data, the entire
sheet is just filled with #error#. Usually, if we close and re-open or wait
a few seconds and try to form again, it'll work fine. However, this
'instability' is frustrating to the users. We did not have this problem
with 3.0, but have had it since going on 4.0. I'm hoping things are better
with 5.0.
6
We are in need of some documentation / installation procedures to create a
DSN for a MSACCESS to Progress link.
Anybody using Merant 3.50 ODBC?
Thanks,
Bruce D. Allen
Bracalente Mfg Co Inc
Vantage 4.00.807 Progress 9.0B


-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, August 01, 2001 1:53 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 5.0 - ODBC Stability?



We are still on Vantage 4.0. We use ODBC to run some external applications
in MS Access linking to Vantage data in read-only mode. We also did the
same on Vantage 3.0. When we were on 3.0, it worked very smoothly, very
rarely was there a problem. Since we have been on 4.0 (over a year), we
find the ODBC connection to be very unstable, as I know others have. I was
wondering if anyone is using ODBC with 5.0 and if there have been
improvements in the stability?

Thanks,

Sarah


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/