title: Oracle connection issues in Python
body: <p>I have been trying to set up a connection directly to an oracle database in Python. I have added the connections into ODBC data sources on both user DSN and system DSN. Both connections were successful and now it is time to connect it in python. I think it may be an issue with the driver I am selecting but I am not sure which driver to use to make this possible.</p>
  <p><strong>Here is the code:</strong></p>
  <p>import pyodbc as pyodbc</p>
  <p>cnxn = pyodbc.connect('Driver = {Oracle in instantclient_19_8} ; DSN = [server name] ;UID=[myid],PWD=[password]')</p>
  <p>print('finished connecting to data sources')</p>
  <p><strong>Here is the error:</strong></p>
  <p>('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')</p>