4.0 ODBC Question


(system) #1
Thanks for your help, John! I am so thankful that I don't have to redo them
all!

Sarah

(system) #2
This weekend we finally upgraded to Vantage 4.0. For the most part, it went
really well. The only problem that I am having so far is with ODBC.
Changing the ODBC to handle 4.0 was simple, I just had to do a couple of
things on the server, and change the client system variables to point to the
newly created Progress folder. This was explained clearly in the ODBC 4.0
install instructions.

My problem came when trying to run ODBC reports in ACCESS that were created
in 3.0. These reports use 'linked' rather than 'imported' data. When I try
to run these reports in 4.0, I get a message saying "[MERANT][ODBC PROGRESS
driver]Driver's SQL SetConnectAttr failed[MERANT][ODBC PROGRESS
driver]Optional feature not implemented. However, I can create new reports
through linked data without a problem. Did anybody else have this problem?
Has anybody successfully run reports using linked data after the upgrade?
Thanks for any feedback!

Sarah

(system) #3
Sarah,

All you have to do is go into each Access application and relink the tables.
Use the linked table manager under Tools...Addins....linked table manager.
Then selcet all the tables and point them to the new location....

John Yohannan
Bracalente Mfg.

------------------------------------------------------------------------
Wish you had something rad to add to your email?
We do at www.supersig.com.
http://click.egroups.com/1/6810/13/_/411782/_/963834657/
------------------------------------------------------------------------

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.)