How to install sql server driver while creating a python api

1k views Asked by At

I want to create a python api so that i can communicate with my database hosted on sql server. I am trying to create it with help og google cloud platform.But when i am doing it the pyodbc package is not getting installed as it has a sql drive requirement.So how should i install the sql server driver while creating it.

1

There are 1 answers

2
Sıddık Açıl On

https://colab.research.google.com/drive/1nYIQXfL3lpK34yl-cR1WHwMFkyEBE4qm

You should install ODBC driver for Linux before installing pyodbc as I have exemplified above.

!sudo apt-get install unixodbc-dev
!pip install pyodbc