| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| ODBC problem with MQSI |
« View previous topic :: View next topic » |
| Author |
Message
|
| artham |
 Posted: Thu Feb 14, 2002 6:30 am Post subject: |
 |
|
Novice
Joined: 13 Feb 2002
Posts: 12
|
I am having a problem with ODBC connection using MQSI. I am loosing my connection to the Oracle database when I am trying to connect to the database after a period of time.
I get an ODBC -1 error saying not connected to ORACLE or end-of-file error.
when I check the ODBC connection from ORACLE NETWORK ADMINISTRATION ODBC Test It works fine but it dosen't work from MQSI.
If I restart the BROKER it starts working fine but I get the problem back after a day or two when the application is not used for a period of time.
I am using Windows NT , Oracle ODBC driver , Oracle 8.1.6.
We are trying to move to MERANT ORACLE ODBC Driver Does this solve the problem?
Any feed back would be appreciated .
thanks in Advance.
|
|
| Back to top |
|
 |
| NickB |
| Posted: Thu Feb 14, 2002 6:57 am Post subject: |
|
|
Centurion
Joined: 20 May 2001
Posts: 107
Location: Zurich Financial Services
|
This is almost certainly due to the quality of the ODBC driver you are using to connect through to Oracle.
We have experienced similar intermittent problems when connecting from our broker to mainframe DB2.
|
|
| Back to top |
|
|
| Nick Lethbridge |
| Posted: Thu Mar 14, 2002 11:11 am Post subject: |
|
|
Voyager
Joined: 13 Aug 2001
Posts: 88
Location: Santander, UK
|
We had a similar problem with Sun Solaris 8 and Oracle 8.1.7, using the Merant ODBC driver.
We received an emergency fix from IBM (PMR 40440) which seems to have solved the problem.
Regards,
Nick. |
|
| Back to top |
|
|
| bgoldstein |
| Posted: Fri Mar 22, 2002 6:02 am Post subject: |
|
|
Novice
Joined: 14 Feb 2002
Posts: 19
Location: Ameren Services, St.Louis,Mo., USA
|
| What version of mqsi are you running? |
|
| 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
|
|
|
|
