Re: odbc driver comunication link failure -- MIDRANGE-L

Angela - We use an EAI package called SeeBeyond that uses ODBC to connect to the i5 database.

Although not written in VB (SeeBeyond uses a language called Monk), what our team did to get around this time-out problem was to periodically (like every five minutes) execute a dummy SELECT statement against a file in their scripts, just to keep the ODBC connection alive.

Regards,
Steve

----- Original Message ----- From: "Angela Wawrzaszek" <awawrzaszek@xxxxxxxxxxxxxxx> To: <midrange-L@xxxxxxxxxxxx> Sent: Friday, March 25, 2005 7:11 AM Subject: odbc driver comunication link failure


Hi all,

We are running a VB app that connects to the iseries to verify data and
update data.   Everything works fine unless the app is idle for 20-25
minutes,  then the app gets a runtime error   2147467259.   Which is
stating that the ibm iseries access odbc driver communication link
failure,  comm. Re=10054   iseries server disconnection.

Looking this error up it appeared that we needed to change a parm on the
odbc driver to SQL_DRIVER_NOPROMPT.  However it is still occurring.   Is
there a timeout setting on the odbc somewhere that would disconnect on
an idle connection?   Any ideas on anything else or what to do to stop
this?

Thankyou,

Angela Wawrzaszek

IT Supervisor

Nucor Steel Auburn

(315) 258-4205

awawrzaszek@xxxxxxxxxxxxxxx

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