locked
how to write oledb connection string for oracle8i(in a remote machine) RRS feed

  • Question

  • User878603653 posted

    This is a cross post at :

     

    http://stackoverflow.com/questions/5726025/how-to-write-oledb-connection-string-for-oracle8iin-a-remote-machine

     

    Since I can not get the answer so  post it here:

    Hi:

    How to write oledb connection string for oracle8i(in a remote machine)?

    I mean the iis is setup in my machine(the win7 platform),but the oracle8i is installed in another win xp system,how to write the connection string?

    Wednesday, April 20, 2011 9:57 AM

Answers

  • User269602965 posted

    First

    Install the Oracle Client on the IIS machine.  It is okay to install the Oracle 11g client, but you might find some infrequently used Oracle 8i commands deprecated in the 11g SQL client.  But there are work-arounds for this low risk probability event. 

    Then provide the Oracle client TNSNAMES.ORA file with the appropriate remote database connection information.

    Instead of Host Name, I like to use the more definitive IP address of the oracle database server.

    The application on IIS will then communicate with the remote database server by the Oracle Client running on the IIS machine.

    You may have to solve hardware and/or software firewall issues between the two machines to support the Oracle listener port (by default install is TCP Port 1521).

    I would use the TNSNAMES.ORA like configuration method for your Web.Config connection string.

    I would replace OLEDB with ODP.NET (ODAC) if possible, faster and supports more SQL capabilities.

    http://download.oracle.com/docs/cd/E11882_01/win.112/e17726.pdf

    http://download.oracle.com/docs/cd/E11882_01/win.112/e17727.pdf

    http://download.oracle.com/docs/cd/E11882_01/install.112/e16774.pdf

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 21, 2011 7:00 PM

All replies

  • User269602965 posted

    First

    Install the Oracle Client on the IIS machine.  It is okay to install the Oracle 11g client, but you might find some infrequently used Oracle 8i commands deprecated in the 11g SQL client.  But there are work-arounds for this low risk probability event. 

    Then provide the Oracle client TNSNAMES.ORA file with the appropriate remote database connection information.

    Instead of Host Name, I like to use the more definitive IP address of the oracle database server.

    The application on IIS will then communicate with the remote database server by the Oracle Client running on the IIS machine.

    You may have to solve hardware and/or software firewall issues between the two machines to support the Oracle listener port (by default install is TCP Port 1521).

    I would use the TNSNAMES.ORA like configuration method for your Web.Config connection string.

    I would replace OLEDB with ODP.NET (ODAC) if possible, faster and supports more SQL capabilities.

    http://download.oracle.com/docs/cd/E11882_01/win.112/e17726.pdf

    http://download.oracle.com/docs/cd/E11882_01/win.112/e17727.pdf

    http://download.oracle.com/docs/cd/E11882_01/install.112/e16774.pdf

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 21, 2011 7:00 PM
  • User878603653 posted
    Thanks for your attention and your reply. I will have a try. :)
    Saturday, April 23, 2011 8:47 AM