Pyodbc – “Data source name not found, and no default driver specified”

by

I believe the answer to your problem is that in your ~/.odbc.ini file you are saying to use driver PostgreSQL – but you have not defined that driver in your /etc/odbcinst.ini file. Try changing PostgreSQL to PostgreSQL ANSI or PostgreSQL Unicode (both of which are defined in /etc/odbcinst.ini).

More Related Contents:

  1. Import psycopg2 Library not loaded: libssl.1.0.0.dylib
  2. Pyodbc error Data source name not found and no default driver specified paradox
  3. python 2.7 script to add a column
  4. Python 2: Conditional statement behaviour of lists with greater/smaller [duplicate]
  5. Not able to install Python packages [SSL: TLSV1_ALERT_PROTOCOL_VERSION]
  6. Reading an Excel file in python using pandas
  7. Insert an element at a specific index in a list and return the updated list
  8. Backporting Python 3 open(encoding=”utf-8″) to Python 2
  9. How to update the image of a Tkinter Label widget?
  10. 2D list has weird behavor when trying to modify a single value [duplicate]
  11. Accessing attributes on literals work on all types, but not `int`; why? [duplicate]
  12. RuntimeError: module compiled against API version a but this version of numpy is 9
  13. python how to decode http response
  14. Fastest way to process a large file?
  15. How to integrate Pygame and PyQt4?
  16. Cannot use Requests-Module on AWS Lambda
  17. UnicodeEncodeError: ‘ascii’ codec can’t encode characters in position 0-5: ordinal not in range(128) [duplicate]
  18. Can’t install mysql-python (newer versions) in Windows
  19. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  20. Create a Postgres database using python
  21. SQLAlchemy – performing a bulk upsert (if exists, update, else insert) in postgresql
  22. Python 3 urllib produces TypeError: POST data should be bytes or an iterable of bytes. It cannot be of type str
  23. How can I copy a Python string?
  24. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  25. Module imports and __init__.py
  26. How to set connection timeout in SQLAlchemy
  27. What does backward-slash b do in Python?
  28. ‘frozenset’ object is not callable
  29. How to filter a DataFrame column of lists for those that contain a certain item
  30. The ‘pip==7.1.0’ distribution was not found and is required by the application

Leave a Comment