conn = pyodbc.connect("DRIVER={SQL Native Client};SERVER=%s;DATABASE=%s;UID=%s;PWD=%s" %(server, dbname, login, password))

  
excur = conn.cursor()
key = input('Для продолжения\nНажмите ENTER ')
if ord(msvcrt.getch()) == 255 and len(key) == 0:
    excur.execute("exec dbo.proc_Repack @CaseFrom = ?, @CaseTo = ?, @UserName = ?", CaseFrom, CaseTo, UserName)
    conn.commit()

     
def MyFunction3(self):
        self.ui.textEdit_2.setText("")
        try:
            connection = pypyodbc.connect('Driver={SQL Server};Server=*;Database=*; uid=*;pwd=*')
            cursor = connection.cursor()
            code2=self.ui.textEdit_4.toPlainText() #ввод параметра с экрана
            date =  ("""
                declare @pmday_ int = datediff(day,'19900101','%s')
                exec dbo.spkz_autoretr_finder @lid_net = 623, @lid_ret = 17, @pmday = @pmday_;""" %code2)
            cursor.execute(date)
            connection.commit()
            self.ui.textEdit_2.setText('Successful')
        except Exception:
            self.ui.textEdit_2.setText('Error. Please, try again')