Migrate from .accdb to MySQL
Hi everyone,
I'm trying to migrate my .accdb file (DATI.accdb) in MySQL.
I create DSN connector for my accdb database but, in "Fetch Schemata List" step I have this log:
Starting...
Connect to source DBMS...
- Connecting to source...
Connecting to Mssql@DATI...
Opening ODBC connection to DSN=DATI;DATABASE=;UID=sa;PWD=XXXX...
Connected
Traceback (most recent call last):
File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 147, in connect
_connections[connection.__id__]["version"] = getServerVersion(connection)
File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "C:\MySQL\MySQL Workbench 5.2 CE\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][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell'espressione della query 'CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)'. (-3100) (SQLExecDirectW)")
Traceback (most recent call last):
File "C:\MySQL\MySQL Workbench 5.2 CE\modules\db_mssql_grt.py", line 173, in getServerVersion
ver_string = execute_query(connection, "SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)").fetchone()[0]
File "C:\MySQL\MySQL Workbench 5.2 CE\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][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell'espressione della query 'CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)'. (-3100) (SQLExecDirectW)")
Traceback (most recent call last):
File "C:\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 65, in run
self.func()
File "C:\MySQL\MySQL Workbench 5.2 CE\modules\migration_source_selection.py", line 415, in task_connect
raise e
SystemError: ProgrammingError("('42000', "[42000] [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell'espressione della query 'CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)'. (-3100) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion
ERROR: Error during Connect to source DBMS: ProgrammingError("('42000', "[42000] [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell'espressione della query 'CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)'. (-3100) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion
Traceback (most recent call last):
File "C:\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 543, in update_status
task.run()
File "C:\MySQL\MySQL Workbench 5.2 CE\workbench\wizard_progress_page_widget.py", line 80, in run
raise e
SystemError: ProgrammingError("('42000', "[42000] [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell'espressione della query 'CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)'. (-3100) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion
ERROR: Exception in task 'Connect to source DBMS': SystemError('ProgrammingError("(\'42000\', "[42000] [Microsoft][Driver ODBC Microsoft Access] Errore di sintassi (operatore mancante) nell\'espressione della query \'CAST(SERVERPROPERTY(\'ProductVersion\') AS VARCHAR)\'. (-3100) (SQLExecDirectW)")"): error calling Python module function DbMssqlRE.getServerVersion',)
Failed
Please help me ;)