M圜md.Parameters.AddWithValue('?field1Name', Textbox1. SQL = 'SELECT Field1 FROM Table1 WHERE Field1 = ?field1Name' M圜onn = New OdbcConnection(m圜onnectionString) M圜onnectionString = 'Provider=MSDASQL DRIVER= Server=localhost UID=user PWD=password database=db Option=16387' However, I just tried the following variation and it worked for me (Python 2.7 and pyodbc): However, I just tried the following variation and it worked for me (Python 2. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'field' at line 1 at .HandlerError syntax is not available to ODBC queries from external applications. I have received the following error message:ĮRROR You have an error in your SQL syntax. I have tried to connect to mySQL database through parameter SQL with ODBC 3.51 driver.
