mirror of
https://github.com/hanzoai/pymssql.git
synced 2026-10-30 14:54:29 +00:00
Ramiro Morales
378f0be254
Also, highlight note about the fact the required format of the username field is a shorter one, update examples.
33 lines
1010 B
ReStructuredText
33 lines
1010 B
ReStructuredText
================================
|
|
Connecting to Azure SQL Database
|
|
================================
|
|
|
|
Starting with version 2.1.1 pymssql can be used to connect to *Microsoft Azure
|
|
SQL Database*.
|
|
|
|
Make sure the following requirements are met:
|
|
|
|
* Use FreeTDS 0.91 or newer
|
|
* Use TDS protocol 7.1 or newer
|
|
* Make sure FreeTDS is built with SSL support
|
|
* Specify the database name you are connecting to in the *database* parameter of
|
|
the relevant ``connect()`` call
|
|
* **IMPORTANT**: Do not use ``[email protected]`` for the
|
|
*user* parameter of the relevant ``connect()`` call! You must use the shorter
|
|
``username@server`` form instead!
|
|
|
|
Example::
|
|
|
|
pymssql.connect("xxx.database.windows.net", "username@xxx", "password", "db_name")
|
|
|
|
or, if you've defined ``myalias`` in the ``freetds.conf`` FreeTDS config file::
|
|
|
|
[myalias]
|
|
host = xxx.database.windows.net
|
|
tds version = 7.1
|
|
...
|
|
|
|
then you could use::
|
|
|
|
pymssql.connect("myalias", "username@xxx", "password", "db_name")
|