Re: Workbench Migration Problem

[Howard Perkins]

yeah sorry i didnt think to attach a log. im using workbench versions 6.0 and FreeTDS o.99.0157

here is the log



Starting...
Connect to source DBMS...
- Connecting to source...
Connect to source DBMS done
Check target DBMS connection...
- Connecting to target...
Check target DBMS connection done
Retrieve schema list from source....
- Checking connection...
- Fetching catalog names...
- Fetching schema names...
- Fetching schema names from C
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/db_mssql_grt.py", line 192, in getSchemaNames
execute_query(connection, 'USE %s' % quoteIdentifier(catalog_name))
File "/usr/lib/mysql-workbench/modules/db_mssql_grt.py", line 62, in execute_query
return get_connection(connection_object).cursor().execute(query, *args, **kwargs)
pyodbc.ProgrammingError: ('42000', "[42000] [FreeTDS][SQL Server]Unclosed quotation mark after the character string 'C'. (105) (SQLExecDirectW)")

Traceback (most recent call last):
File "/usr/share/mysql-workbench/libraries/workbench/wizard_progress_page_widget.py", line 192, in thread_work
self.func()
File "/usr/lib/mysql-workbench/modules/migration_source_selection.py", line 432, in task_fetch_schemata
self.main.plan.migrationSource.doFetchSchemaNames(only_these_catalogs)
File "/usr/lib/mysql-workbench/modules/migration.py", line 255, in doFetchSchemaNames
schema_names = self.getSchemaNames(catalog)
File "/usr/lib/mysql-workbench/modules/migration.py", line 209, in getSchemaNames
return self._rev_eng_module.getSchemaNames(self.connection, catalog or '')
SystemError: ProgrammingError("('42000', "[42000] [FreeTDS][SQL Server]Unclosed quotation mark after the character string 'C'. (105) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getSchemaNames
ERROR: Retrieve schema list from source: ProgrammingError("('42000', "[42000] [FreeTDS][SQL Server]Unclosed quotation mark after the character string 'C'. (105) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getSchemaNames
Failed