Post reply

how to specify a the port when using ADO.NET or OLEDB Connection for oracle?

  • February 15, 2006 at 10:03 am

    #166978

    How do I specify the port when creating a new ADO .NET connection for Oracle or an OLEDB connection for Oracle in a package?  Oracle DB uses a default port of 1521, but if we are using a port other than 1521 then hos should that be specified when using a new ADO.NET or OLEDB Connection.

    I do not see a way of doing that and the connection keeps failing.

    Thanks,

    Monisha

  • February 17, 2006 at 6:11 am

    #621613

    I'm no Oracle expert, but I thought that was set in the TNSNAMES file.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 17, 2006 at 10:01 am

    #621735

    I have done that but still the problem persists when using an OLE DB Connection or ADO .NET connection.  I am on a 64 bit Win 2003 OS with Oracle 9i installed and SQL Server 2005 for 64 bit installed.

    Thanks,

    Manisha

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply