Создал базу misha,таблицу test с 3 полями(last_name,first_name,location).Хочу получить поле с помощью скрипта питона.
import pyodbc db = pyodbc.connect(driver='{MySQL ODBC 5.5.21 Driver}',server='localhost',database='misha',uid='root',pwd='ololo') dbc = db.cursor() dbc.execute("select test.last_name from test") rows = dbc.fetchall() for row in rows: print row.last_name
выдаёт какой-то ужас:
C:\Users\m1cky\Desktop\PYTHON>connect_db.py Traceback (most recent call last): File "C:\Users\m1cky\Desktop\PYTHON\connect_db.py", line 2, in <module> db = pyodbc.connect(driver='{MySQL ODBC 5.5.21 Driver}',server='localhost',data base='misha',uid='root',pwd='пароль') pyodbc.Error: ('IM002', '[IM002] [Microsoft][\ufffd\ufffd\ufffd\ufffd\ufffd\ufff d\ufffd\ufffd\ufffd \ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd ODBC] \ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd \ufffd\ufffd\ufffd\ufffd\ufffd \ufffd \ufffd\ufffd \ufffd\ufffd\ufffd\ufffd\ufffd\ufffd \ufffd \ufffd\ufffd \uf ffd\ufffd\ufffd\ufffd\ufffd\ufffd \ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd, \u fffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd \ufffd\uf ffd \ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd\ufffd (0) (SQLDriverConnect )')
в чём проблема?и ещё вопрос что вот тут писать то правильно?не нашёл инфы
driver='{MySQL ODBC 5.5.21 Driver}'