Guest User

Untitled

a guest
Aug 23rd, 2018
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. django.core.exceptions.ImproperlyConfigured: 'django-pyodbc-azure' isn't an available database backend.
  2. Try using 'django.db.backends.XXX', where XXX is one of:
  3. 'mysql', 'oracle', 'postgresql', 'sqlite3'
  4.  
  5. C:Users\AppDataLocalProgramsPythonPython37-32Libsite-packages
  6. - django_pyodbc
  7. - django_pyodbc-2.0.0a1.dist-info
  8. - django_mssql-1.8.dist-info
  9. - django_pyodbc_azure-2.1.0.0.dist-info
  10.  
  11. import pyodbc
  12. server = 'test-server-local'
  13. database = 'TEST-DB'
  14. username = 'sql_username'
  15. password = 'password'
  16. cnxn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password)
  17. cursor = cnxn.cursor()
  18.  
  19. cursor.execute("SELECT DepartmentName, DepartmentID from dbo.Departments;")
  20. row = cursor.fetchone()
  21. while row:
  22. print(row.DepartmentID, row.DepartmentName)
  23. row = cursor.fetchone()
Add Comment
Please, Sign In to add comment