PyODBC on Intel - Mac OS X to Oracle

[Phelipe]

Hi guys,

I'm trying to connect my app in python with a Oracle database. I've
installed pyodbc in my virtualenv but it's not working. The Oracle
instant client is working ok, I can connect using sqlplus. But when I
try to call .connect it throws an error:

cnxn = pyodbc.connect("user/password@//host:port/service")
pyodbc.Error: ('IM002', '[IM002] [iODBC][Driver Manager]Data source
name not found and no default driver specified. Driver could not be
loaded (0) (SQLDriverConnectW)')

Can anyone help me?

Thanks

[Michael Kleehammer]

Have you setup your data source in Library/ODBC/odbc.ini and Library/ODBC/odbcinst.ini?

If not, that's the problem.  If so, can you post them without the passwords and maybe someone can help.  I don't have an Oracle install to test against right now.