kingrox
02-19-2023, 07:12 AM
olá, alguém sabe o que está errado nesse código
import pyodbc
server = '(local)' # ou o endereço IP do servidor
database = 'MuOnline'
username = 'sa'
password = '123456'
driver = 'MuOnline' # ou o driver ODBC que você está usando
conn = pyodbc.connect('DRIVER=' + driver + ';SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
erro que eu obtenho
Traceback (most recent call last): File "C:\Users\nicho\PycharmProjects\MainLauncher\teste. py", line 9, in <module>
conn = pyodbc.connect('DRIVER=' + driver + ';SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado (0) (SQLDriverConnect)')
:mad::mad::mad::mad::mad:
import pyodbc
server = '(local)' # ou o endereço IP do servidor
database = 'MuOnline'
username = 'sa'
password = '123456'
driver = 'MuOnline' # ou o driver ODBC que você está usando
conn = pyodbc.connect('DRIVER=' + driver + ';SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
erro que eu obtenho
Traceback (most recent call last): File "C:\Users\nicho\PycharmProjects\MainLauncher\teste. py", line 9, in <module>
conn = pyodbc.connect('DRIVER=' + driver + ';SERVER=' + server + ';DATABASE=' + database + ';UID=' + username + ';PWD=' + password)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado (0) (SQLDriverConnect)')
:mad::mad::mad::mad::mad: