Posts

Showing posts from May, 2020

python Database connections- MS SQL server connection.

Image
Microsoft SQL Server already installed in your local machine and you need to connect with python  using  Text editor or IDE  then this  article for you  to connect database you need pyodbc  library. pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the  DB API 2.0  specification but is packed with even more Pythonic convenience. The easiest way to install is to use pip: using CMD  and bellow command  it will install pyodbc pip install pyodbc Then using sublime or VS code or any IDE import  pyodbc library  if your  a user then use bellow code  import pyodbc conn= pyodbc.connect(         host= "DESKTOP-V5F828B\SQLEXPRESS" ,         USER = "Testlogin",         password = "1234" ,         Driver= 'ODBC Driver 13 for SQL Server' ,         Trusted_connection= 'no' ,   ...