Bug #67758 erro migrar de SqlServer 7 para Mysql

Submitted:	29 Nov 2012 14:54	Modified:	21 Apr 2013 15:15
Reporter:	L R	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S1 (Critical)
Version:	5.2.44	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	workbench 5.2.44 migration

Description:
migrar desde un windows server 2000 , Sql server 7
para
windows server 2003 Mysql
workbench 5.2.44

ProgrammingError42000 Odbc SqlServerDriver ServerProperty no es un nombre de funcion reconocido(195) SqlExecDirectW. error calling module fun
conexion con servidor Sql - ok
conexion con servidor Mysql ok
para despues de ese paso. fallo, no continua

How to repeat:
Starting...

Connect to source DBMS...

- Connecting to source...

Traceback (most recent call last):

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\db_mssql_grt.py", line 173, in getServerVersion

    ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\db_mssql_grt.py", line 62, in execute_query

    return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'SERVERPROPERTY' no es un nombre de funci\xf3n reconocido. (195) (SQLExecDirectW)")

C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\migration_source_selection.py:407: DeprecationWarning: BaseException.message has been deprecated as of Python 2.6

  if "[Driver Manager]" in e.message and "image not found" in e.message:

Traceback (most recent call last):

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\db_mssql_grt.py", line 173, in getServerVersion

    ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\db_mssql_grt.py", line 62, in execute_query

    return get_connection(connection_object).cursor().execute(query, *args, **kwargs)

pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'SERVERPROPERTY' no es un nombre de funci\xf3n reconocido. (195) (SQLExecDirectW)")

Traceback (most recent call last):

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 65, in run

    self.func()

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\modules\migration_source_selection.py", line 415, in task_connect

    raise e

SystemError: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'SERVERPROPERTY' no es un nombre de funci\xf3n reconocido. (195) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Error during Connect to source DBMS: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'SERVERPROPERTY' no es un nombre de funci\xf3n reconocido. (195) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion

Traceback (most recent call last):

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 543, in update_status

    task.run()

  File "C:\Archivos de programa\MySQL\MySQL Workbench CE 5.2.44\workbench\wizard_progress_page_widget.py", line 80, in run

    raise e

SystemError: ProgrammingError("('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'SERVERPROPERTY' no es un nombre de funci\xf3n reconocido. (195) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion

ERROR: Exception in task 'Connect to source DBMS': SystemError('ProgrammingError("(\'42000\', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]\'SERVERPROPERTY\' no es un nombre de funci\\xf3n reconocido. (195) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion',)

Failed

Buen día.
Podrías por favor intentar con la nueva versión de WB (5.2.47)?
Cambios importantes han sido incluidos en nuevas versiones los cuales posiblemente arreglen tu problema.
Gracias.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.