Hi and thanks a lot for taking the time to even read this post!

I'm dealing with a "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 'Info ASC' at line 1" error while working with a IdM 3.6 <-> MySQL 5 setup and while researching I came across Supported Database Versions in the 3.6 documentation for MySQL as 3.x and 4.x However, TID 3314621 lists MySQL 5. Am I missing something? I might be barking up the wrong tree altogether.

Any insights would be greatly appreciated.

Thanks,

Bill

More of the error, for what it's worth:

DirXML Log Event -------------------
Driver: \IDMVAULT\vault\DriverSet\webapps
Channel: Publisher
Status: Error
Message: <description>Unable to select row(s) from table/view 'idm'.</description>
<jdbc:exception jdbc:class="com.mysql.jdbc.exceptions.jdbc4.MySQLS yntaxErrorException" jdbc:error-code="1064" jdbc:sql-state="42000" xmlns:jdbc="urn:dirxml:jdbc" xmlns:jdbc-1="urn:dirxml:jdbc" xmlns:jdbc-2="urn:dirxml:jdbc" xmlns:jdbc-3="urn:dirxml:jdbc">
<jdbc:message>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 'Info ASC' at line 1</jdbc:message>
</jdbc:exception>




Bill Scully

Senior Network Engineer and Administrator
Trinity International University
Information Technology