Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 289280 - Last Review: December 5, 2003 - Revision: 4.1
BUG: Oracle ODBC Connectivity Slow with MDAC 2.5/2.6 on Windows 95/98/NT
This article was previously published under Q289280
When using the Microsoft ODBC for Oracle driver that ships with MDAC 2.5 or 2.6, establishing a connection to an Oracle database may take a long time (approximately 11 seconds) on the platforms listed above. This problem does not occur on Microsoft Windows Millennium Edition (Me) or Microsoft Windows 2000.
This problem is partially due to a bug in the version of Mtxoci.dll (1999.6.854.0) that ships with MDAC 2.5 and 2.6.
You can resolve this problem in either of the following ways:
- Replace Mtxoci.dll with an updated version which ships with Windows 2000 or later.
-or-
- Follow the resolution that is described in the following article in the Microsoft Knowledge Base:
286204Â
(http://kbalertz.com/Feedback.aspx?kbNumber=286204/EN-US/
)
PRB: Slow CGI Performance with Microsoft ODBC for Oracle on Windows NT 4.0
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
There are several ways to reproduce this problem; two methods are shown below.
To reproduce the problem from the ODBC datasource administrator, follow these steps:
- Click either the User DSN or System DSN tab, and then click Add to create a new data source name (DSN).
- On the Create New Data Source dialog box, select Microsoft ODBC for Oracle, and then click Finish.
- In the Microsoft ODBC for Oracle Setup dialog box, add the required information, and then click OK.
To reproduce the problem from the ODBC Test tool (in the MDAC SDK), follow these steps:
- On the Conn menu, select Full Connect.
- Select a DSN that is associated with the Microsoft ODBC for Oracle driver, add the user name and password, and then click OK.
In both cases, it takes a long time for the connection to be established. If you follow the above steps after updating Mtxoci.dll, you will notice that the time to establish a connection is reduced.
APPLIES TO
- Microsoft Data Access Components 2.5, when used with:
- Microsoft Windows 95
- Microsoft Windows 98 Standard Edition
- Microsoft Windows NT 4.0
- Microsoft Data Access Components 2.5 Service Pack 1, when used with:
- Microsoft Windows 95
- Microsoft Windows 98 Standard Edition
- Microsoft Windows NT 4.0
- Microsoft Data Access Components 2.5 Service Pack 2, when used with:
- Microsoft Windows 95
- Microsoft Windows 98 Standard Edition
- Microsoft Windows NT 4.0
- Microsoft Data Access Components 2.6, when used with:
- Microsoft Windows 95
- Microsoft Windows 98 Standard Edition
- Microsoft Windows NT 4.0
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate