Actually, this could be used from anything that uses OLEDB/ODBC. Here are the steps:
(ADDRESS = (PROTOCOL = TCP)(HOST = <my oracle server address>)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = <oracle service name>)))
Random rant: It’s 2012 Oracle, why do we still have to find and setup a tnsnames.ora file?…. since this is one of the most important and must do steps to connect to your databases I would think you would have some kind of front end to streamline this. You have a robust database server but your tools are lacking (a lot). Take a cue from some of the tools you’ve put out with MySQL as of recent. The MySQL Workbench is a great offering… replicate that for your Oracle product.