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 » oracle driver error

Post new topic  Reply to topic
 oracle driver error « View previous topic :: View next topic » 
Author Message
arun57
PostPosted: Fri Feb 15, 2008 4:23 am    Post subject: oracle driver error Reply with quote

Novice

Joined: 14 Jan 2008
Posts: 21
hi,
when i run a test message across one of our message flows deployed to the version 6.0 broker on XP, i am gettin following error:

( WBRK6_DEFAULT_BROKER.test ) Database error: SQL State ''IM001''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] Driver does not support this function''.

The error has the following diagnostic information: SQL State ''IM001'' SQL Native Error Code '0' SQL Error Text ''[Microsoft][ODBC Driver Manager] Driver does not support this function''

This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.

WBRK6_DEFAULT_BROKER.test ) Database error: ODBC return code '-1'.

The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.

Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.



( WBRK6_DEFAULT_BROKER.test ) ('.SimpleFlow_Compute.Main', '9.4') Error detected whilst executing the SQL statement ''SET temp = THE (SELECT ITEM COLUMN(0) FROM DATABASE(, FIELDVALUE(myRef)));''.

The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.

See the following messages for details of the error.


WBRK6_DEFAULT_BROKER.test ) Error detected whilst processing a message in node 'SimpleFlow.Compute'.

The message broker detected an error whilst processing a message in node 'SimpleFlow.Compute'. An exception has been thrown to cut short the processing of the message.

i am using oracle database and using DataDirect drivers but still facing issue.

could someone shed some light on what the issue might be?
Back to top
View user's profile Send private message
AJStar
PostPosted: Sun Feb 17, 2008 9:32 pm    Post subject: Reply with quote

Acolyte

Joined: 27 Jun 2007
Posts: 64
Check if you are using the correct DataDirect driver for your env.

Confirm that your DSN has the "Enable SQLDescribeParam" set, and the "WorkArounds" value is set to 536870912.
_________________
Regards
AJ
Back to top
View user's profile Send private message
ishaq
PostPosted: Mon Feb 18, 2008 2:15 am    Post subject: Reply with quote

Novice

Joined: 18 Feb 2008
Posts: 11
i enabled SQLDescribeParam. and its working now. thanks....
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 » oracle 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.