0

Am relatively beginner level python dev here. I am just not able to connect to Oracle from pypyodbc

import pypyodbc as pyodbc
connstr = 'DSN = IDW;PWD=XXXXX'
connection = pyodbc.connect(connstr)

errs out with the below:

File "C:\Users\PRXM\Desktop\JobReadings\PythonIDE\eclipse-standard-luna-R-win32-x86_64\eclipse\plugins\org.python.pydev_4.1.0.201505270003\pysrc\pydevd.py", line 1709, in run
    pydev_imports.execfile(file, globals, locals)  # execute the script
File "C:\Users\PRXM\workspace\tests\gettingstarted.py", line 10, in <module>
    connection = pyodbc.connect(connstr)
File "C:\Users\PRXM\Desktop\JobReadings\PythonIDE\Anaconda_64\lib\site-packages\pypyodbc.py", line 2434, in __init__
    self.connect(connectString, autocommit, ansi, timeout, unicode_results, readonly)
File "C:\Users\PRXM\Desktop\JobReadings\PythonIDE\Anaconda_64\lib\site-packages\pypyodbc.py", line 2483, in connect
    check_success(self, ret)
File "C:\Users\PRXM\Desktop\JobReadings\PythonIDE\Anaconda_64\lib\site-packages\pypyodbc.py", line 988, in check_success
    ctrl_err(SQL_HANDLE_DBC, ODBC_obj.dbc_h, ret, ODBC_obj.ansi)
File "C:\Users\PRXM\Desktop\JobReadings\PythonIDE\Anaconda_64\lib\site-packages\pypyodbc.py", line 964, in ctrl_err
    raise Error(state,err_text)
pypyodbc.Error: (u'IM002', u'[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified')
chinna_82
  • 6,353
  • 17
  • 79
  • 134
schuler
  • 175
  • 2
  • 4
  • 12
  • I further tried with connstr = 'Driver = {Oracle in OraClient11g_home1};DBQ = IDW_PRD;Uid=myusername;Pwd=mypassword' and I still see the same error message – schuler Jun 08 '15 at 20:10

1 Answers1

2

Try this:

Connection_String = 'Driver={Oracle in OraClient11g_home1};DBQ=MyDB;Uid=MyUser;Pwd=MyPassword;'
spongebob
  • 8,370
  • 15
  • 50
  • 83
oracle
  • 31
  • 4
  • While this code may answer the question, providing additional context regarding _how_ and/or _why_ it solves the problem would improve the answer's long-term value. – spongebob Aug 13 '15 at 11:43