upgrading from acc97 to acc2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have successfully imported the linked tables, tables, forms, modules etc.
The linked tables come from an Oracle db. The problem I am having is with a
memo data type (in excess of 4096 bytes, some records look like War and Peace
excerpts) . When included on an Inner join, I receive an “ODBC call failed /
ora-00602 internal programming exception†error message. I can run the form
if I change the select from “Select *†to “Select elementnames†and exclude
the memo type field, however I can query the same table and display the
element fine by itself. Any suggestions?

Thanks

Denis
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

I am not sure what version of Oracle you are using and if you are using the
driver provided by Microsoft, but you might want to try using the latest
driver. Check your driver version. It might need to be updated. You can
obtain the latest MDAC. Once you have the most current driver version,
create a new DSN using the Microsoft ODBC for Oracle Driver. Delete and
then relink the Oracle tables using the new dsn. Also, verify that you
have the latest service packs applied for your version of Office.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Thanks for your reply Amy, my odbc32 dl version is 3.520.4403.2, oracle is
2.573.9030.00. ms office 2002 sp3 ver 10.6612.6714, mdac ver 2.7 sp1 on xp
sp1. Our change control group is still evaluating sp2 for xp. I am able to
access the element from an independant query so I thought the drivers were
fine. I also have both acc97 and acc2002 on the same desktop, installed by
renaming the exe, etc. I am in the admin group across all domains.

The sql that failed is :
SELECT APPLICATIONS.*, [STAKEHOLDER TABLE].*
FROM APPLICATIONS INNER JOIN [STAKEHOLDER TABLE] ON APPLICATIONS.[BUSINESS
UNIT] = [STAKEHOLDER TABLE].[BUSINESS UNIT]
WHERE (((APPLICATIONS.[MBS NUMBER1])<>0))
ORDER BY APPLICATIONS.[BUSINESS UNIT], APPLICATIONS.[APPLICATION NAME];

The successful sql is:

SELECT AIO_APPLICATIONS.APPLICATION_KEY, AIO_APPLICATIONS.DESCRIPTION
FROM AIO_APPLICATIONS;

And AIO is the DSN and "Description" is datatype memo that is giving me the
problem.

Thanks again for your help,

Denis
 
Back
Top