MIDRANGE dot COM Mailing List Archive

RE: v6r1 and SQL 0901


Hi Pete

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

Evan Harris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[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.


Pete Massiello
iTech Solutions

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact