I need to be able to connect to an Oracle database (11g) from Mathematica 7.0.1, I assume using JDBC is the way to go.

My method of connection to the Oracle database is via a tnsnames.ora file.

When searching for related information, I have found:


http://theblasfrompas.blogspot.com/2008/04/jdbc-thin-connection-using-tnsnamesora.html



 "As of the 10.2.x JDBC driver we now allow you to connect to your database using a tnsnames.ora entry from JDBC THIN. Previously this was not possible without fully qualifying the description alias. To do this in 10.2.x JDBC driver you can do it one of 2 ways.



Option 1:



Pass a system property as follows at the command line



-Doracle.net.tns_admin=D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN



Option 2:





    System.setProperty("oracle.net.tns_admin",

                        "D:\\oracle\\product\\10.2.0\\db_1\\NETWORK\\ADMIN");"



How can I do either of these from within Mathematica (or does anyone have any other option)?



Thanks in advance

/Jan-Erik Brundell