title: Pyodbc error Data source name not found and no default driver specified paradox
body: <p>I am attempting to use <code>pyobdc</code> to read data from a paradox database, and I keep getting the following error when attempting to connect to the database:</p>
  
  <pre><code>pyodbc.Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
  </code></pre>
  
  <p>I have tried to create new DNS links for the database but it has not helped what so ever.</p>
  
  <p><strong>My system links are as follows:</strong></p>
  
  <p><img src="https://i.stack.imgur.com/KZ3cD.png" alt="This is what the system DNS looks like"></p>
  
  <p><strong>My code is:</strong></p>
  
  <pre><code>import os
  import sys
  import time
  import pyodbc
  
  LOCATION = "c:\Users\Marcello\Desktop\DATA\ScorMonitor.db"
  
  cnxn = pyodbc.connect(r"Driver={{Microsoft Paradox Driver (*.db )}};Fil=Paradox 5.X;DefaultDir={0};Dbq={0}; CollatingSequence=ASCII;")
  cursor = cnxn.cursor()
  cursor.execute("select last, first from test")
  row = cursor.fetchone()
  print row
  </code></pre>