conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost:1433;DATABASE=Test')

pyodbc.Error: ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. (14) (SQLDriverConnectW); [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()). (14)')

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhostTest,1433')

cur = conn.cursor()
cur.execute("SELECT * FROM Tags")

pyodbc.ProgrammingError: ('42S02', "[42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tags'. (208) (SQLExecDirectW)")

SELECT * FROM Test.dbo.Tags

conn = pyodbc.connect('Trusted_Connection=yes', driver = '{SQL Server}',
                      server = 'localhost', database = 'Test')
cursor = conn.cursor()
# assuming that Tags table is in dbo schema
cursor.execute("SELECT * FROM dbo.Tags")

cn=pyodbc.connect('DRIVER={SQL Server};SERVER=localhostSQLEXPRESS;PORT=1433;DATABASE=ybdb;UID=sa;PWD=*****')