| Author |
Message |
 Topic: ODBC connetion to SQL Server on Windows. |
CHAK DE
Replies: 1
Views: 1812
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 11, 2007 2:51 am Subject: ODBC connetion to SQL Server on Windows. |
| Thanks the issue got resolved,it was due to firewall issue. |
| Topic: Network Error while connecting to sql server on windows |
CHAK DE
Replies: 3
Views: 6476
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 11, 2007 1:22 am Subject: Network Error while connecting to sql server on windows |
I am getting the following network error while connecting to sql server on windows from Linux server hosting the broker.
Oct 11 04:41:34 wgcwebsphere04 WebSphere Broker v6000[12436]: (AUS_BRK06.Ora ... |
| Topic: ODBC Connection from To Oracle |
CHAK DE
Replies: 3
Views: 2919
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 10, 2007 4:54 am Subject: ODBC connection to oracle |
| Is it not possible without installing the oracle client on broker's server?I mean can we add some more parameters (like hostname,ip and portnumber) in the stanza shown for oracle database in odbc.ini ... |
| Topic: ODBC Connection from To Oracle |
CHAK DE
Replies: 3
Views: 2919
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 10, 2007 2:49 am Subject: ODBC Connection from To Oracle |
I want to establish an ODBC connection to oracle database on a Linux server from another linux server which hosts the broker.I have configured the odbc.ini file as below:
[OODDB]
Driver=/opt/ibm/mqs ... |
| Topic: Accesing Oracle Database from ESQL. |
CHAK DE
Replies: 4
Views: 2679
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 05, 2007 4:32 am Subject: Accessing Oracle database using ESQL |
Hi Vitor,
I am not getting any error in the syslogs but data retrieval is not successful at the output queue.No messages are found on the output queue. |
| Topic: Accesing Oracle Database from ESQL. |
CHAK DE
Replies: 4
Views: 2679
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 05, 2007 4:22 am Subject: Accesing Oracle Database from ESQL. |
I need to retrieve data from a table in an oracle database.My ESQL code is as follows:
CREATE PROCEDURE GetData() BEGIN
SET OutputRoot.XML.Test.Result[] = (SELECT T.EMPID, T.NAME, T.DESIGNATION ... |
| Topic: SQL Error |
CHAK DE
Replies: 8
Views: 5886
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 02, 2007 10:03 pm Subject: Exception in Time Out Notification Node |
| The previous issue is resolved,it was due to missing MQMD part in ESQL code Compute Node.Now the issue I am facing is though I have configured the timeinterval property in time out notification node ... |
| Topic: SQL Error |
CHAK DE
Replies: 8
Views: 5886
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 27, 2007 10:31 pm Subject: SQL Error |
What properties have you set on the Compute node that is calling GetData()?
BASIC:
DataSource:SAMPLE
Transaction:Automatic
ComputMode:Message
Treat Warning as Error
Throw exception on database ... |
| Topic: SQL Error |
CHAK DE
Replies: 8
Views: 5886
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 27, 2007 6:09 am Subject: SQL Error |
Platform -Redhat Linux 2.4 i386
WMB Verison-6
I configured the data source by modifying the odbc.ini file as below:
[ODBC Data Sources]
WBRKBKDB=IBM DB2 ODBC Driver
MYDB=IBM DB2 ODBC Driver
... |
| Topic: SQL Error |
CHAK DE
Replies: 8
Views: 5886
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Sep 27, 2007 5:48 am Subject: SQL Error |
Hi,
I am new to WBIMB and I am testing a message flow to retrieve data from a table in SAMPLE database on the same server which hosts the broker.
I am getting the errors during runtime as below :
... |
