Description:
I am not able to connect to a remote MSSQL server from a Redhat VM. I connect to the VM via a vnc viewer called Remina, and launch mysql-workbench. I have tried
both ODBC(FreeTDS) and ODBC Data Source(FreeTDS) connection methods.
ODBC(FreeTDS) gives error - "NotConnectedError("No open connection to %s" % connection_object.hostIdentifier)
ODBC Data Source(FreeTDS) -- Connects but gives error below when it tries to execute "execute SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR) () {}":
NameError: ('420', '[420] 0\x000\x00\x00\x00e\x00e\x00T\x00D\x00S\x00]\x00[\x00S\x00Q\x00L\x00 \x00S\x00e\x00r\x00v\x00e\x00r\x00]\x00I\x00n\x00c\x00o\x00r\x00 (102) (SQLExecDirectW)')
After ODBC Data Source(FreeTDS) connection fails, if I try ODBC(FreeTDS) connection again, it gives the same error as the ODBC Data Source(FreeTDS) (that is, it does not give the NotConnectedError like it does the very first time)
Below is the ouptput from 3 times I tried to connect. First ODBC(FreeTDS), then ODBC Data Source(FreeTDS), then again ODBC(FreeTDS):
[WRN][ mforms]: Resource file not found: migration_check_open_win.png
13:09:15 [WRN][ mforms]: Resource file not found: migration_check_open_win.png
13:09:15 [WRN][ mforms]: Resource file not found: migration_check_open_win.png
13:09:16 [WRN][ mforms]: Resource file not found: migration_check_open_win.png
13:09:18 [WRN][ mforms]: Resource file not found: migration_check_current_win.png
13:09:47 [INF][ grt]: Connecting to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433...
13:09:47 [INF][ grt]: Opening ODBC connection to DRIVER={freetds};SERVER=40.75.119.172;PORT=1433;DATABASE=;UID=AAbraham;PWD=XXXX;TDS_VERSION=7.4;DriverUnicodeType=UTF16...
13:09:47 [ERR][ grt]: Connection failed No open connection to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433
13:09:47 [ERR][ python]: error calling DbMssqlRE.connect
Traceback:
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 121, in connect
con = get_connection(connection)
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 52, in get_connection
raise NotConnectedError("No open connection to %s" % connection_object.hostIdentifier)
NameError: No open connection to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433
13:09:47 [DB1][ mforms backend]: Looking up password for 'AAbraham'@'Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433' has failed
13:09:47 [DB1][ mforms backend]: Creating and showing password dialog
13:09:59 [INF][ grt]: Connecting to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433...
13:09:59 [INF][ grt]: Opening ODBC connection to DRIVER={freetds};SERVER=40.75.119.172;PORT=1433;DATABASE=;UID=AAbraham;PWD=XXXX;TDS_VERSION=7.4;DriverUnicodeType=UTF16...
13:09:59 [ERR][ grt]: Connection failed No open connection to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433
13:09:59 [ERR][ python]: error calling DbMssqlRE.connect
Traceback:
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 121, in connect
con = get_connection(connection)
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 52, in get_connection
raise NotConnectedError("No open connection to %s" % connection_object.hostIdentifier)
NameError: No open connection to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433
13:12:31 [DB1][ mforms backend]: Looking up password for 'AAbraham'@'Mssql@mssqldsn' has failed
13:12:31 [DB1][ mforms backend]: Creating and showing password dialog
13:12:53 [INF][ grt]: Connection to Mssql@mssqldsn apparently lost, reconnecting...
13:12:53 [INF][ grt]: Connecting to Mssql@mssqldsn...
13:12:53 [INF][ grt]: Opening ODBC connection to DSN=mssqldsn;DATABASE=;UID=AAbraham;TDS_VERSION=7.2;PWD=XXXX...
13:12:53 [INF][ grt]: Connected to Mssql@mssqldsn,
13:12:53 [DB3][ db.mssql]: execute SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR) () {}
13:12:53 [ERR][ python]: error calling DbMssqlRE.connect
Traceback:
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 158, in connect
_connections[connection.__id__]["version"] = getServerVersion(connection)
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 184, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 66, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
NameError: ('420', '[420] 0\x000\x00\x00\x00e\x00e\x00T\x00D\x00S\x00]\x00[\x00S\x00Q\x00L\x00 \x00S\x00e\x00r\x00v\x00e\x00r\x00]\x00I\x00n\x00c\x00o\x00r\x00 (102) (SQLExecDirectW)')
13:18:03 [DB1][ mforms backend]: Looking up password for 'AAbraham'@'Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433' has failed
13:18:03 [DB1][ mforms backend]: Creating and showing password dialog
13:18:16 [INF][ grt]: Connection to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433 apparently lost, reconnecting...
13:18:16 [INF][ grt]: Connecting to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433...
13:18:16 [INF][ grt]: Opening ODBC connection to DRIVER={freetds};SERVER=40.75.119.172;PORT=1433;DATABASE=;UID=AAbraham;PWD=XXXX;TDS_VERSION=7.4;DriverUnicodeType=UTF16...
13:18:16 [INF][ grt]: Connected to Mssql@DRIVER=freetds;SERVER=40.75.119.172;PORT=1433,
13:18:16 [DB3][ db.mssql]: execute SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR) () {}
13:18:16 [ERR][ python]: error calling DbMssqlRE.connect
Traceback:
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 158, in connect
_connections[connection.__id__]["version"] = getServerVersion(connection)
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 184, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "/usr/lib64/mysql-workbench/modules/db_mssql_grt.py", line 66, in execute_query
return get_connection(connection_object).cursor().execute(query,
How to repeat:
To repeat launch WB, then "Start Migration", enter Source RDBMS Connection parameters, and click "Test Connection"