pyodbc.Error

[grec...@gmail.com]

Hello everybody! Help please!

I can't connect to database in ms sql server with python3.

My code: 

import pyodbc

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=(local);DATABASE=Laba2;UID=Julia-HP\Julia')

Error text:

Traceback (most recent call last):

  File "<pyshell#6>", line 1, in <module>

    conn = pyodbc.connect('DRIVER={SQL Server};SERVER=(local);DATABASE=Laba2;UID=Julia-HP\Julia')

pyodbc.Error: ('28000', '[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]������ ����� ������������ "Julia-HP\\Julia". (18456) (SQLDriverConnect)')

I try:

import pyodbc

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=(local);DATABASE=Laba2;UID=Julia-HP\Julia;PWD=''')

 becase i have not password in my database.

What i am doing wrong?

Thanks!!!

[Michael Kleehammer]

If you are trying to use SQL Server's integrated authentication, use this:

  DRIVER={SQL Server};SERVER=localhost;DATABASE=Laba2;Trusted_Connection=True

This is great for personal use during development, but I would recommend using a special user for production with a difficult password.  You can use a trusted connection in production, but then you need to run the process as that user.