MySQL Forums
Forum List  »  Microsoft Access

Migrate from .accdb to MySQL
Posted by: Paolo Ermini
Date: November 22, 2012 04:05AM

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 ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
Migrate from .accdb to MySQL
2838
November 22, 2012 04:05AM
659
November 22, 2012 08:04AM
786
November 22, 2012 08:49AM
600
November 22, 2012 08:56AM
858
November 22, 2012 10:16AM
627
November 22, 2012 02:48PM


Sorry, you can't reply to this topic. It has been closed.

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.