I've seen some similar things on other upgrades - mostly it turns out to be
that the SQL packages needed to be re-created. Usually just deleting them
will be sufficient, but identifying which ones are OK to delete is slightly
more difficult :)
In one case the model SQL packages had been deleted at some stage causing
some weird SQL errors with Stored procedures.
I mention this as a pointer to what might be happening rather than a
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Massiello
Sent: Thursday, 17 July 2008 2:25 p.m.
To: 'Midrange Systems Technical Discussion'
Subject: v6r1 and SQL 0901
I did another upgrade to V6R1 today from V5R4, and everything went very
smoothly, expect we can't Get External Data from Excel (Win XP using Office
2000 or Office 2007 same error) using ODBC. Has anyone else gotten this
0901 SQL error after upgrade. All the existing ODBC Excel downloads of data
work fine, only new ones that we try to create get this error as soon as you
try to signon to the i5 with ODBC.
I am at the latest Cumulative level, Hiper group level, and Database group.
Anyone had this problem and found a work around? I couldn't find anything.