sql.h not found when installing PyODBC on Heroku

by

To follow up on the answer below…

Example for Ubuntu:

sudo apt-get install unixodbc unixodbc-dev

Example for CentOS:

sudo yum install unixODBC-devel

Example for Fedora:

sudo dnf install unixODBC-devel

On Windows:

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=yourserver.yourcompany.com;DATABASE=yourdb;UID=user;PWD=password')

On Linux:

conn = pyodbc.connect('DRIVER={FreeTDS};SERVER=yourserver.yourcompany.com;PORT=1433;DATABASE=yourdb;UID=user;PWD=password;TDS_VERSION=7.2')

More Related Contents:

  1. How to speed up bulk insert to MS SQL Server using pyodbc
  2. Django: Deploying an application on Heroku with sqlite3 as the database
  3. setting an environment variable in virtualenv
  4. python pip specify a library directory and an include directory
  5. H14 error in heroku – “no web processes running”
  6. How to import a text file on AWS S3 into pandas without writing to disk
  7. How can I modify Procfile to run Gunicorn process in a non-standard folder on Heroku?
  8. PYODBC–Data source name not found and no default driver specified
  9. Get data from pandas into a SQL server with PYODBC
  10. How to customize a requirements.txt for multiple environments?
  11. Writing a csv file into SQL Server database using python
  12. No web processes running Django in heroku
  13. “Data source name not found and no default driver specified” with Access ODBC
  14. gunicorn command not found, but it’s in my requirements.txt
  15. App not compatible with buildpack – Heroku
  16. Pyodbc – “Data source name not found, and no default driver specified”
  17. How to use Google API credentials json on Heroku?
  18. pyodbc insert into sql
  19. Error while pushing to Heroku: requested runtime is not available for this stack
  20. to_sql pyodbc count field incorrect or syntax error
  21. Pyodbc error Data source name not found and no default driver specified paradox
  22. Django staticfiles not found on Heroku (with whitenoise)
  23. python pandas to_sql with sqlalchemy : how to speed up exporting to MS SQL?
  24. django makemigrations and migrate on heroku server don’t create tables
  25. Django: sudden DB reset after Heroku sleep
  26. how to pip uninstall with virtualenv on heroku cedar stack?
  27. How to resolve the following error in discord.py: “TypeError __init__() missing 1 required keyword-only argument: ‘intents'” [duplicate]
  28. Collectstatic error while deploying Django app to Heroku
  29. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip [duplicate]
  30. how to catch specific pyodbc error message

Leave a Comment