Re: msgSQL0518 in ODBC after IBM i 7.1 Upgrade

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

IIRC that happened to a couple of *SQLPKG when I did the upgrade myself. 
(our Cognos guy was going nuts lol)


Thanks,
Tommy Holden
Direct: 615-259-5814
Main Line: 615.256.2424 ext. 5814
Toll-Free:  1.800.228.3644 ext.5814
fax:  615-793-7617



From:   Pete Helgren <pete@xxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>, 
Date:   11/08/2011 02:26 PM
Subject:        Re: msgSQL0518 in ODBC after IBM i 7.1 Upgrade
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



It's a stretch but I have seen some weirdness happen in *SQLPKG types on 
an upgrade.  Usually I delete them (they recreate automatically) and see 
if that fixes it.

Pete Helgren
Value Added Software, Inc
www.petesworkshop.com
GIAC Secure Software Programmer-Java


On 11/8/2011 1:02 PM, Scott Klement wrote:
> hi folks,
>
> One of our company VP's is getting a SQL0518 when trying to connect via
> Microsoft Query (via the iSeries Access ODBC driver) to our IBM i 
database.
> The message is something like "Prepared statement FIFABTALL0002 not
> found" (I may have gotten the name of the prepared statement wrong, I'm
> going from memory.)
>
> We recently upgraded IBM i from v5r4m0 to i 7.1 -- and that may have
> been where this issue began.  He was originally running V5R4 of iSeries
> Access (despite that the OS was now 7.1) but, I tried upgrading his PC
> to IBM i Access 7.1, and the problem remains.
>
> He is running Windows 7 and Office 2007 (if that matters.)
>
> A Google search found many PTFs for msgSQL0518 related issues, but they
> all seemed to be for earlier releases of the operating system.
>
> The PC that I use does not exhibit this problem, but I'm running Windows
> XP, so that might be the difference.