PyODBC on Intel - Mac OS X to Oracle
161 views
Skip to first unread message
Phelipe
Nov 10, 2011, 6:58:17 PM11/10/11
to pyodbc
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
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
Dec 18, 2011, 6:29:00 PM12/18/11
to pyo...@googlegroups.com
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.
Reply all
Reply to author
Forward
0 new messages