[Baypiggies] Talking to Oracle from Python on a mac 10.5 ?

[Seth Friedman]

Hi folks

I find myself working in an Oracle environment with an intel Mac running
10.5.8, and getting the Python connectivity to Oracle just seems to be far
more difficult than seems reasonable.

With Oracle Instantclient and zx_Oracle I tried all the instructions I could
find online, a few different versions, and in all the different cases, it
blows up on the import:

seths-macbook-pro:py seth$ python -c 'import cx_Oracle'
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "build/bdist.macosx-10.3-fat/egg/cx_Oracle.py", line 7, in <module>
  File "build/bdist.macosx-10.3-fat/egg/cx_Oracle.py", line 6, in
__bootstrap__
ImportError:
dlopen(/Users/seth/.python-eggs/cx_Oracle-5.0.3-py2.6-macosx-10.3-fat.egg-tmp/cx_Oracle.so,
2): Symbol not found: _OCIAttrGet
  Referenced from:
/Users/seth/.python-eggs/cx_Oracle-5.0.3-py2.6-macosx-10.3-fat.egg-tmp/cx_Oracle.so
  Expected in: dynamic lookup

I've got to think it's possible, by mortals, to open a connection to a 10g
Oracle instance, from Python, in this kind of Mac.   I do hope I'm not being
naive there.

I've heard of this technology ODBC, maybe therein lies a solution.

~seth
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/baypiggies/attachments/20100312/09a5007e/attachment.html>