OLE DB Provider for ODBC err when open a diagram

[fknEA]

Always have 0x80040E14 (DB_E_ERRORSINCOMMAND) when opening a diagram.

Even when I create an empty repository with one empty diagram only I get it.  Any suggestions ?

Database is MySQL. The driver is ANSY 5.2 and all sparx suggested parameters (matched vs affected and large sets) are set correctly.

I spent 4 hours searching here for answers but no success

[qwerty]

Have a look into %appdata%/sparx.../dberror.txt

q.

[fknEA]

I wish I could.
I am an administrator on this windows 7 piece of garbage and I have no access to the ApplicationData folder and there is no way for me to change the permissions. "Access Denied" all the way.

... cant figure out the fkn windows anymore. It seems with each version it's loosing its grip on reality more and more.

[Dermot]

Check this post:
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1370293118

[Geert Bellekens]

I wish I could.
I am an administrator on this windows 7 piece of garbage and I have no access to the ApplicationData folder and there is no way for me to change the permissions. "Access Denied" all the way.

... cant figure out the fkn windows anymore. It seems with each version it's loosing its grip on reality more and more.

You are looking at the wrong folder. Type: %appdata% in the address bar of your windows explorer and start from there.
That should bring you to a folder in your own profile, completely read-write.

Geert

[fknEA]

I wish I could.
I am an administrator on this windows 7 piece of garbage and I have no access to the ApplicationData folder and there is no way for me to change the permissions. "Access Denied" all the way.

... cant figure out the fkn windows anymore. It seems with each version it's loosing its grip on reality more and more.

You are looking at the wrong folder. Type: %appdata% in the address bar of your windows explorer and start from there.
That should bring you to a folder in your own profile, completely read-write.

Geert

Thank you for your advice. Here's the error and I have no idea what to do with it.

Microsoft OLE DB Provider for ODBC Drivers [-2147217900]

[MySQL][ODBC 5.2(a) Driver][mysqld-5.6.11]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Partition as Signed)' at line 1

Context:
      Select * from t_xref where `Type`='swimlane' and Client='{66B250B8-A393-4cf8-BC7E-1E41DC89B26F}' order by Cast(Partition as Signed)

Running it in an SQL window (ea/find/sql) reproduced the error.
Changing the query to "... order by Cast(t_xref.Partition as Signed)" fixes the query but I am not sure how can I reconfigure EA or the database ...

please help

[qwerty]

You need to report that as bug to Sparx (link bottom right of this page).

q.

[Eve]

I notice the problem query includes the Partition column.

I believe the answer is that the current version doesn't support MySQL 5.6. (Support is planned and coming though)

[fknEA]

@Simon: Do you have some ETA for MySQL 5.16 support?
It appears that this is the only issue we have and it is easily fixable just using canonical/full naming in "order by" clauses, something which is best practice anyway...

[Eve]

Sorry, I stopped giving any ETAs long ago.