RE: Release connection, OracleClient

Hi Peter,

I can see the connection in Oracle remains unclosed after the package is
executed. With further investigation, I found this only occurrs when the
package is called through managed dts. When it's run stand-alone, the
connection will be closed. It seems that the connection closes with the
process that the package is executed. If I call the project from my C#
program and the program doesn't exit after the package execution, the
connection will remain there. Is there any way to walk around this?
As for the provider issues, I used to work with the OLEDB provider, but it
has some problem with decimal type in oracle. So I switched to the .net
built-in one. But this decimal problem is just solved temporarily, and it
just came back this morning:
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DataReader Source"
(1)" failed because error code 0x80131938 occurred, and the error row
disposition on "output column "Client_Spend" (4178)" specifies failure on
error. An error occurred on the specified object of the specified component.
There may be error messages posted before this with more information about
the failure.

This doesn't happen on all my data, only a portion of the data will trigger
this error. Is there any known issue about decimal in Oracle?

Thanks.

--

Thanks.

Daniel


""Peter Yang[MSFT]"" wrote:

Hello Daniel,

I didn't find any known issue about this. How do you find the connectin is
not closed? Did you try other connection such as Micrtosoft OLEDB provider
(MSDAORA) and Oracle provider for OLE DB (OraOLEDB.Oracle.1)?

Although Microsoft supports MSDAORA, the Oracle provider for OLE DB
(OraOLEDB.Oracle.1) is the one suggested for best results.

In addition to OLE DB providers for Oracle, at least two ADO.NET data
providers for Oracle exist, and are useable with SSIS. The Microsoft .NET
Data Provider is part of the .NET base-class libraries; it lives in
System.Data.OracleClient. Oracle
has a .NET 2.0–compliant provider, ODP.NET. Both can support the latest
Oracle data types, and ODP.NET has some Oracle-specific optimizations, such
as the ability to use multiple parameter sets. .NET data providers work
with 64-bit versions of .NET 2.0, as well as with 32-bit versions. ODBC
drivers for Oracle are available, but not commonly used with SSIS.

ODP.NET is a joint venture from MS and ORACLE for native client
connectivity to oracle, ORACLE Owns it.

You may want to refer to the following article for more related information:


Connectivity and SQL Server 2005 Integration Services
http://msdn2.microsoft.com/en-us/library/bb332055.aspx

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================
Please note that the newsgroups are staffed weekdays with a goal to provide
ONE BUSINESS DAY RESPONSE to all posts.
If this response time does not meet your needs, please contact CSS for more
immediate assistance:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone#faq607
<http://support.microsoft.com/default.aspx?scid=fh;EN-US;OfferProPhone>.
Feedback on your service and satisfaction can be posted to:
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
======================================================
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... >Oracle 10g Client is installed on the Windows Server. ... >This is my standard DSN Less connection. ... >Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... Microsoft SQL Server 2000 Standard with SP3a installed on same box. ... Oracle 10g Client is installed on the Windows Server. ... This is my standard DSN Less connection. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • Re: oracle db connection with VB 2005 express BETA 2
    ... Each provider has other specific attributes. ... Connection String Assistant of my add-in. ... I already installed Oracle Data ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Password is not saved for Oracle connections
    ... table in SQL Server 2005. ... The package runs just fine from the BID. ... It gives a "ORA-01017: invalid username/password; logon denied" error when I use the Microsoft OLE DB Provider for Oracle, and a "ORA-10005: null password; logon denied" error when I use the Oracle provider for OLE. ...
    (microsoft.public.sqlserver.dts)
  • Re: Connecting to Oracle From VB6
    ... Is this the provider that rewuires you to know how big your Return Data is ... > - Oracle connectivity. ... > string this connection string looks like: ... > If you choose ODBC you connection string should look like ...
    (microsoft.public.data.oledb)