"Protocol error in TDS stream" when trying to connect to MySQL server

Asked Jul 02 '20 at 21:51

Active Jul 03 '20 at 04:17

Viewed 1,032 times

I am trying to connect with Python to my MySQL server which I run on another PC. The server works fine and I am able to connect to it with HeidiSQL client.

But when I try to do it with Python with the following code:

import pypyodbc
connection_string2='Driver={ODBC Driver 13 for SQL Server};Server=LinuxPC,3306;Database=sqldb;uid=sqlusr;pwd=usrpasswd;'
connection2 = pypyodbc.connect(connection_string2)

I get this error:

Error: ('HY000', '[HY000] [Microsoft][ODBC Driver 13 for SQL Server]Protocol error in TDS stream')

Any advice for me?

PS: if it is important I had installed ODBC Driver 13 for SQL Server and Driver={SQL Server} does not work

edited Jul 03 '20 at 04:17

marc_s

732,580
175
1,330
1,459

asked Jul 02 '20 at 21:51

Kosh

2

You're trying to use a SQL Server driver for MySQL? That won't work of course. Use a MySQL driver instead. – sticky bit Jul 02 '20 at 22:08
@stickybit thanks a lot! With mysql.connector it works. Is there any way to make it work with pypyodbc? – Kosh Jul 02 '20 at 22:36
Probably with an ODBC MySQL driver. – sticky bit Jul 02 '20 at 22:38

"Protocol error in TDS stream" when trying to connect to MySQL server

0 Answers0