CODEWITHSUNDEEP
pythonazurepyodbc
MikeB2019x
MikeB2019x

Reputation: 1205

Using pyodbc in Azure Data Studio: no drivers

I'm working in Azure Data Studio for the first time. I have successfully installed 'python'(3.7) and 'pyodbc' (if I try to reinstall I get the message that the dependency is already satisfied). I have also tried running the same script locally on macOS with the same result: empty list. I was expecting a list of the drivers. Any ideas as to what might be happening?

UPDATE/SOLUTION: I learned that for MacOS drivers will be in Library/ODBC. If that is empty or non-existent then you have have no drivers for pyodbc to use. If you have no driver then you get it from somewhere so in my case here.

enter image description here

Upvotes: 0

Views: 388

Answers (1)

Tony Ju
Tony Ju

Reputation: 15629

Just make the solution visible to others, thanks @MikeB2019x for sharing the solution.

For MacOS, drivers will be in Library/OBDC. If that is empty or non-existent then you have have no drivers for pyodbc to use. If you have no driver then you get it here.

Upvotes: 1

Related Questions