I am trying to connect to Oracle using ADO.NET / OLEDB connection in SSIS
package, but the Oracle servers that we have here are not using the default
port 1521, so how do I specify the port when using he ADO.NET / OLEDB
Connection for Oracle.

I have oracle client 9i installed on the box and can connect to both the
servers using SQL*Plus Oracle DB Client. Any inputs on this will be much
appreciated.

Thanks,
Monisha

If you have not done so already setup and use sql*net, because in the
tnsnames.ora file where the connection information is specified so is the
port.
Then I used an Oracle Provider for OLE DB as a data source and for
connection information used sqlnet connection info

"Monisha Shah" wrote:

Brian,
SQL Net 9i is installed and configured and I connect uisng SQL Plus to
oracle database server from that box. But when using an OLEDB connection I
still get the following error when trying to test the connection by hitting
the test connection button in the Connection Manager dialog box:

Test connection failed because of an error in initializing provider.
ORA-06413: Connection not open.

I provided the Service Name as the Oracle Service Name from the tnsnames.ora
file.

Thanks,
Monisha

"brian_harris" wrote:

I don't have an idea at this point about what is wrong. I would suggest that
you turn on sqlnet tracing and/or go to oracle metalink and research the
oracle error you are getting. You may also look in the database alert files
or trace files see if any additional information is given.

"Monisha Shah" wrote: