MQSeries.net :: View topic - DATA Base ISSUE

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DATA Base ISSUE

DATA Base ISSUE

« View previous topic :: View next topic »

Author

Message

lerner

Posted: Fri May 18, 2012 12:58 am Post subject: DATA Base ISSUE

Apprentice

Joined: 17 May 2012
Posts: 26

[IBM][CLI Driver][Apache Derby] SQL0001N Binding or precompilation did not complete successfully. SQLSTATE=42Y07

Iam getting this error when iam trying to insert values into database table

i have used the compute node

ESQL code is

CALL CopyMessageHeaders();
--CALL CopyEntireMessage();

INSERT INTO Database.APPDB.test(sid,sname) VALUES(11,'ABCD');

my database name is APPDB, dsn is also same

i have created ODBC driver dsn but in database properties it is showing jdbcdriver.

any suggestions plz..?

mqjeff

Posted: Fri May 18, 2012 1:24 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Be specific and exact.

HOW did you create the odbc dsn? WHAT Os is it on? Unix?

You appear to be trying to use ODBC to talk to a database that is not one of the supported ODBC databases. Did you use the ODBC extender, per the instructions in the Info Center?

Again.

Be SPECIFIC. We can't help you if you don't show us the right information.

lerner

Posted: Mon May 21, 2012 11:37 pm Post subject:

Apprentice

Joined: 17 May 2012
Posts: 26

thnks for the reply..i'm using windows xp,wmb 7.0,db2 9.7

dsn was automatically created..i just configured User id and password.

and i used that dsn in my database node..

Database error: SQL State ''IM014''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application''.

could you pls tel me when these type errors will come.where i went wrong ..

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DATA Base ISSUE

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