pymssql.connect() seems to ignore database string argument

Question

I have 3 dbs in Azure which I tried connecting to one of them.

conn = pymssql.connect(server='hostname.database.windows.net',
                  user='username@hostname',
                  password='*****',
                  database='my_db',
                  timeout=0,
                  login_timeout=60,
                  charset='UTF-8',
                  as_dict=False,
                  host='',
                  port='1433')


cursor = conn.cursor()
cursor.execute('select db_name()')  #to get the name of my db (which should be "my_db")
result = cursor.fetchone()
print result

But what I've got is "master" which is default Azure database. This shouldn't happen because I've already specify 'databse' string argument to "my_db".

Please advice.

rm-vanda · Accepted Answer · 2014-11-21 17:05:34Z

1

Your problem is your version of pymssql. The latest version on pip is 2.1.0, but the version that supports azure is 2.1.1. So, if you install it from source, it will work. Also, make sure you have freeTDS > 0.91

edited Nov 21, 2014 at 17:05

rm-vanda

3,1763 gold badges25 silver badges35 bronze badges

answered Nov 21, 2014 at 16:05

Ricardo Serrano

111 silver badge1 bronze badge

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

2 Comments

rm-vanda Over a year ago

You may want to elaborate on why freeTDS is an additional requirement. Otherwise, welcome to SO

Ricardo Serrano Over a year ago

pymssql is a python interface to freetds.

Collectives™ on Stack Overflow

pymssql.connect() seems to ignore database string argument

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related