Connection Problem to MSSQL Server with pyodbc from python

Question

I'm using ubuntu and trying to connect MSSQL server from python with pyodbc. I'm using pycharm professional. I'm trying to connect to sql server but I'm getting

pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' : file not found (0) (SQLDriverConnect)").

Here is my code:

 def read_data(self):
    conn = pyodbc.connect('Trusted_Connection=yes', driver='FreeTDS', TDS_Version=7.3,    server='XXXXXXXXXX/SQL2014',
               port= 1433, database = 'YYYY')

I researched from the documents, I've already installed odbc and freetds.

Actually it didn't work. I'm trying to connect with pymssql now. I haven't met any problem with the connection when I'm using windows. But I'm using ubuntu for a short time and I couldn't connect since 5 hours. I tried many things, now I2m installing sql server to ubuntu. — Beyza
– Beyza, Commented Mar 9, 2020 at 10:55
Yes but I didn't understand that where I'll create my text file. In pycharm or a tet file in anywhere? — Beyza
– Beyza, Commented Mar 9, 2020 at 11:15
@Beyza - The text file is temporary. It can reside in any folder where you have read/write access, and it can be created with any text editor, even a console-based tool like vim or nano. (Also, remember to use "@..." on your reply comments so the person to whom you are replying gets notified.) — Gord Thompson
– Gord Thompson, Commented Mar 9, 2020 at 11:35

Beyza · Accepted Answer · 2020-03-09 12:52:23Z

0

My problem is solved. The source of my problem was my local db settings. Thanks for your comments.

answered Mar 9, 2020 at 12:52

Beyza

1491 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connection Problem to MSSQL Server with pyodbc from python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related