RE: Receiving SQL0440 error on ODBC connection

[Bob Cagle <bcagle@xxxxxxxxxxx>]

Follow-up to this for the archives:

I ended up running into another SQL error - SQL7008 'File in Library not valid for operation'.

After a little Googling found this link: https://www-304.ibm.com/support/docview.wss?uid=nas8N1017566

The usual cause of this error is an attempt to update a file that is not journaled.  I had to make another change to the ODBC configuration: on the Server tab, click Advanced and then set the commit mode.  It was set to *CHG, but since I am not journaling, I changed it to *NONE.

Thanks

Bob Cagle
IT Manager
Lynk, Inc.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Cagle
Sent: Monday, March 16, 2015 1:41 PM
To: Midrange Systems Technical Discussion
Subject: RE: Receiving SQL0440 error on ODBC connection

Rob

Thanks for those links.  The reference to unchecking the 'Enable extended dynamic support' on the Packages tab of the ODBC configuration is what worked - no more SQL errors!

Now if I could just get someone to fix the bug in the Crossware export script that's keeping the tracking numbers from uploading...

Thanks

Bob Cagle
IT Manager
Lynk, Inc.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, March 16, 2015 11:59 AM
To: Midrange Systems Technical Discussion
Subject: Re: Receiving SQL0440 error on ODBC connection

I'd report this to Worldship.  Post back what you hear.  Here is some other avenue of interest
https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000000292

IDK if this is related
https://www.ibm.com/developerworks/community/forums/html/topic?id=77777777-0000-0000-0000-000014797658&ps=25
I wouldn't think so if "the only thing that changed was an upgrade of Worldship".


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to:  2505 Dekko Drive
          Garrett, IN 46738
Ship to:  Dock 108
          6928N 400E
          Kendallville, IN 46755
http://www.dekko.com





From:   rob@xxxxxxxxx
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   03/16/2015 12:41 PM
Subject:        Re: Receiving SQL0440 error on ODBC connection
Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



The 6.1 knowledge center lists 3 new columns added.
7.1 lists one more.
7.2 doesn't list any new ones.


Rob Berendt