ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ODBC Oracle Wire Protocol driver Error

Post new topic  Reply to topic
 ODBC Oracle Wire Protocol driver Error « View previous topic :: View next topic » 
Author Message
kirankinnu
PostPosted: Thu Jul 29, 2010 7:53 am    Post subject: ODBC Oracle Wire Protocol driver Error Reply with quote

Centurion

Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL

Hi All,
I am trying to retrieve some data from Oracle Tables. I am using ODBC Oracle Wire Protocol driver for establishing connection. The very first call runs fine, but I keep getting the below error for subsequent call.

"[IBM][ODBC Oracle Wire Protocol driver]Data type for parameter 1 has changed since first SQLExecute call.'

If i give a time delay of 1 minute between each call, it runs fine. I have Enable SQLDescribeParams and Procedure Returns Results checked under Driver Setup.

Am I missing any setup or do i need to handle the DB calls any different.

I would really appreciate any suggestions.

Thank you,
Kiran
Back to top
View user's profile Send private message
sunny_30
PostPosted: Thu Jul 29, 2010 11:34 am    Post subject: Reply with quote

Master

Joined: 03 Oct 2005
Posts: 258

try adding this stanza in the odbc.ini ->
Quote:
WorkArounds=536870912


reference:
http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/bh26070_.htm
http://web.synametrics.com/databagerror.htm
Back to top
View user's profile Send private message
kirankinnu
PostPosted: Thu Jul 29, 2010 1:17 pm    Post subject: Reply with quote

Centurion

Joined: 12 Jun 2004
Posts: 128
Location: Chicago, IL

Hi,
I tried adding this but did not work. After adding in workarounds, i even rebooted. but of no use.

Thank you,
Kiran
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » ODBC Oracle Wire Protocol driver Error
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.