MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2008

RE: v6r1 and SQL 0901



fixed

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

Regards
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

Pete Massiello
iTech Solutions
http://www.itechsol.com






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

This mailing list archive is Copyright 1997-2014 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