| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem with DSN configuration and Oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| artykito |
 Posted: Mon Sep 13, 2010 10:56 pm Post subject: Problem with DSN configuration and Oracle |
 |
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
Hi all,
I'm having problems with the ODBC configuration for an Oracle DB and doing a SELECT or INSERT by ESQL from a Compute node. I've never do this before and I'm stuck...
As I'm using Windows XP, my first step was to do this configuration for Oracle. Test connection is OK and my DSN is now called 'OWD'.
After that, I wrote this command in console and then reset the broker:
| Code: |
| mqsisetdbparms WBRK7_DEFAULT_BROKER -n [b]dsn::DSN[/b] -u UserId1 -p password1 |
*** (I used 'dsn::DSN' literally, is this correct or must I change 'DSN' for 'OWD'?) ***
And then, I revised my ODBC.ini and this is its content:
| Quote: |
[ODBC 32 bit Data Sources]
OWD=WebSphere Message Broker DataDirect Technologies 6.0 32-BIT Oracle Wire Protocol (32 bits)
[OWD]
Driver32=C:\Archivos de programa\IBM\MQSI\7.0\bin\UKORA24.DLL |
Anyway, checking the forum, I could see I can add parameters to this file, so I add manually the following params after the lines above:
| Quote: |
EnableSQLDescribeParam=1
EnableDescribeParam=1
OptimizePrepare=1
ServerName=<Server host>
WorkArounds=536870912
ProcedureRetResults=1 |
With this or without this lines, my problem is that I'm not able to write a SELECT or INSERT without warnings or errors... I could find a solution for a SELECT using the PASSTRHU statement, but I'm still having problems with the INSERT. My code is like the code of Data Warehouse sample:
| Code: |
| INSERT INTO Database.TEST (TEST1,TEST2) VALUES ('UNO','DOS'); |
Where TEST is a table I created in Oracle and TEST1, TEST2 are its fields. But in this sentence, I have 3 warnings:
| Quote: |
Unresolvable database table reference "Database.TEST"
Unresolvable database table reference "TEST1"
Unresolvable database table reference "TEST2" |
I have set the DSN in the Compute properties, and I know there isn't a connection problem (because when I do a SELECT trhu the PASSTHRU statement, it works), so I think is a configuration problem or something like that, but I was checking the help, the forum, etc... and I can't find anything useful.
For more information, I have added the DB in the Data Source Explorer perspective and I'm able to create tables, to do select, inserts, etc... with the SQL Script files (.sql). My problem is in the ESQL code. Also, my user is Administrator.
Please help me! I'm desperate...  |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Sep 14, 2010 2:02 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
