?
Solved

ISeries ODBC Disconnection With UPS Worldship

Posted on 2008-11-12
2
Medium Priority
?
4,030 Views
Last Modified: 2013-12-06
We are trying to connect UPS' Worldship (Version 10) to a database on an ISeries that contains all the relevant shipping informmation via an ODBC connection. The connection works fine except for two issues. Firstly, the initial connection take about 3-4 minutes to establish itself. Once the connection is established, the data is populated in a timely fashion. I have heard that the UPS Worldship software indexes every table on its initial connection and not being an ODBC or Client Access guru I was wondering if there was a way to tell the ODBC connection to only look at the table that actually has the information we need.

Secondly, the ODBC connection times out after about 30 minutes of non-use with the following message:

ODBC Error: State=08S01 Error=[IBM} ISeries Access ODBC Driver
Communication link failure, comm rc=10054
CWBC01047-The ISeries server application disconnected the connection.

I had the system value of "QINACTITV" on the ISeries changed to the Max Value of 300 minutes, but the error is still occuring. When this occurs, the users must re-establish the connection and are stuck waiting for the connection like in issue one.

I am not an expert on either Client Access or ODBC, but we are transitioning to the Worldship software and need to get either a quicker startup on the initial connection or eliminate the timeout issue. UPS has not been very helpful in this matter, so once again I turn to the Experts.

Thank you very much for any insight!
0
Comment
Question by:ctsuhako
2 Comments
 
LVL 5

Accepted Solution

by:
JBart_17 earned 1500 total points
ID: 22944862
The time out probably is occurring with the ODBC driver, try adding  "QUERYTIMEOUT=0" to your connection string
for more info on the connection string check out
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/rzaik/rzaikconnstrkeywordsperfprop.htm
 
0
 

Expert Comment

by:Joe0635
ID: 26195193
How is the innitial connection part of this problem solved? UPS has used it's middleware solution CrossWare to use a VBScript to pass information back and forth.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question