On Wednesday 10 January 2007 02:31, Andy Todd wrote: > Sean Davis wrote: > > I am new to the list, so if I am in the wrong place, feel free to direct > > me elsewhere. > > > > I am trying to connect to an Oracle installation on a remote machine. I > > have installed the oracle instant client on my machine (linux x84_64) and > > can connect via Oracle's sqlplus client to the remote machine. > > > > So, my question is what are the working options for connecting from > > python when I do not have an entire installation in place but only > > instantclient? > > > > Thanks, > > Sean > > _______________________________________________ > > DB-SIG maillist - DB-SIG@python.org > > http://mail.python.org/mailman/listinfo/db-sig > > Sean, > > If you can connect using SQL*Plus then you can connect with a Python > DB-API 2.0 module such as cx_Oracle [1] because they use the same > connection mechanism. Just use the same connection string. > > e.g. if you use > > $ sqlplus scott/[EMAIL PROTECTED] > > at the command line then in Python you can just do something like; > > >>> import cx_Oracle > >>> remote_db = cx_Oracle.connect('scott/[EMAIL PROTECTED]') > > I'd have a look at the documentation of whichever module you choose to > find out how to get the best out of it though. > > [1] http://www.python.net/crew/atuining/cx_Oracle/
Thanks, Andy. This is indeed the route I have gone and it works like a charm. Just an aside, I learned that one must install the SDK from oracle, a requirement above-and-beyond the standard SQL*Plus, which will work fine without the SDK. A minor point, but it was cause for a bit of confusion for me. Sean _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig
