| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle 9i !!!! |
« View previous topic :: View next topic » |
| Author |
Message
|
| elvis_gn |
 Posted: Sun Dec 05, 2004 6:21 am Post subject: Oracle 9i !!!! |
 |
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi,
I had been working all this while on DB2, but now I have to use an Oracle database for a simple SELECT statement in a msg flow.
I have it installed on a remote machine and i have a Oracle client on my system. I made the datasources in both with same names,when i do test connection it works.....
(SELECT VEHICLES.* FROM Database.tiger.VEHICLES WHERE VEHICLES.REGISTRATION_NUMBER = InputBody.VehicleInfoResponse.Vehicle.RegistrationNumber AND VEHICLES.REGISTRATION_TYPE = InputBody.VehicleInfoResponse.Vehicle.RegistrationType AND VEHICLES.STATUS = 'Y');
This is my select statement, I get an error in the Event Viewer as,
Database error: SQL State '08001'; Native Error Code '0'; Error Text '[DataDirect][ODBC Oracle driver]Cli'.
The error has the following diagnostic information: SQL State '08001' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC Oracle driver]Cli'
Can someone help..... |
|
| Back to top |
|
 |
| chenulu |
| Posted: Sun Dec 05, 2004 8:26 pm Post subject: |
|
|
Voyager
Joined: 27 Mar 2002
Posts: 87
Location: Research Triangle Park, NC
|
Hi,
could you please let me know what is the OS, WMQI/WBI-MB version and CSD levels are? Also, pelase post the complete error message,
-- Chenulu |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Sun Dec 05, 2004 8:47 pm Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
the OS is Windows 2000 in both the computers.The version of WBIMB is 5.0.2........
THE ERRORS I'M GETTING ARE
( WBRKBKMOI.CIO_TO_WPS_EXE ) Error detected whilst processing a message in node 'CIO_TO_WPS_MSGFLOW.Compute'.
( WBRKBKMOI.CIO_TO_WPS_EXE ) 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.
( WBRKBKMOI.CIO_TO_WPS_EXE ) Database error: SQL State '08001'; Native Error Code '0'; Error Text '[DataDirect][ODBC Oracle driver]Cli'.
The error has the following diagnostic information: SQL State '08001' SQL Native Error Code '0' SQL Error Text '[DataDirect][ODBC Oracle driver]Cli' |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Mon Dec 06, 2004 5:21 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Do i have to give any additional ESQL statements to connect to a Oracle Data source ????
I cant seem to find the option to enter the data source name with its user and password.......
Can i enter this in the ESQL (compute node) ?????
I am currently getting the error: login user and password wrong.....
I have created the data source using MERANT 3.10.....
Are there atleast any pdf's which talk about this clearly ???? |
|
| Back to top |
|
|
| EddieA |
| Posted: Mon Dec 06, 2004 9:41 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
| I cant seem to find the option to enter the data source name with its user and password....... |
mqsisetdbparms
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| 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
|
|
|
|
