RE: ODBC

We had the same issue when migrating to our 520 from an 830 several
months ago.  A call to IBM Software Support gave us the solution that
Tim references below.  They had us delete all of the objects of type
*SQLPKG from QGPL.  They get recreated as soon as the connections are
reestablished.

Jim Reinardy
Badger Meter, Inc.
Milwaukee, WI

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hatzenbeler, Tim
Sent: Tuesday, October 25, 2005 2:53 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: ODBC

Googling I saw this..

http://www.tek-tips.com/viewthread.cfm?qid=1132272&page=1 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Snyder
Sent: Tuesday, October 25, 2005 12:36 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: ODBC

Message we get is SQL0901 - SQL system error.


>>> thatzenbeler@xxxxxxxxxxxxx 10/25/05 3:28:06 PM >>>
Are they getting an error message?  If so what is it?

I had a problem a few years ago, with crystal reports, because the
reports stores the database name, and when we got a new server, the
database name changed, so I had to re-update all those reports...  The
odbc DSN name still stayed the same...  It was an as/400 setting that
changed...  

Tim 

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.