MySQL Forums
Forum List  »  Microsoft SQL Server

Re: WorkBench Migration error
Posted by: Sergio Andres De La Cruz Rodriguez
Date: March 04, 2013 05:52PM

Hi Philippe:

As I can read from what you pasted, here's the problem:

pyodbc.ProgrammingError: ('42000', '[42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36]FUNCTION SERVERPROPERTY does not exist (1305) (SQLExecDirectW)')

As you see, it is complaining about the SERVERPROPERTY function. It seems strange to me since the official SQL Server 2008 R2 documentation says it is indeed supported: http://msdn.microsoft.com/en-us/library/ms174396(v=sql.105).aspx

Can you run this query in your SQL Server server and report the results back here?:

SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)

Also, can you tell us which Workbench version are you using?

Cheers,

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.

Options: ReplyQuote


Subject
Written By
Posted
February 28, 2013 05:13AM
Re: WorkBench Migration error
March 04, 2013 05:52PM


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.