RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question

When we were experiencing space leaks related to distributed queries MS support told us that MS does not support MSDAORA and to use the OraOledb provider. There is also no 64 bit version of MSDAORA and according to the last document I reviewed at MS support, MS has no plans to create on as the Oracle provider is recommended.  

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mary Bahrami

	Sent: Wednesday, November 19, 2008 4:01 PM
	To: Chris.Taylor_at_ingrambarge.com; ORACLE-L
	Subject: RE: MSDAORA.DLL (Microsoft OLE DB For Oracle)

        We had a similar problem with db links from sql2005 to ora10.2; I initially used msdaora.dll. It caused errors: WARNING: inbound connection timed out (ORA-3136)

        And eventually prevented new oracle logins; this is fixed in 10.2.0.4. Switching to the OraOledb.oracle provider fixed the problem until we can patch.          

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David

	Sent: Wednesday, November 19, 2008 11:58 AM
	To: ORACLE-L
	Subject: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity

        We have a VB app using MSDAORA.DLL that doesn't seem to be disconnecting from the DB even though we have a connection close command in the VB program.          

        Any of you seen something like this? We're eating up our "OPEN_CURSOR" count for this session as it process a lot of events and then finally errors out.          

        I really think the problem is that the "OpenConnection" command from VB isn't getting sucessfully closed and reconnected.          

        Thoughts?          

        Chris Taylor

        Sr. Oracle DBA

        Ingram Barge Company

        Nashville, TN 37205

        Office: 615-517-3355

        Cell: 615-354-4799

        Email: chris.taylor_at_ingrambarge.com          

--
http://www.freelists.org/webpage/oracle-l