Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

IDM 4.8 - Restricted characters in iManager Driver's password field

Hello everyone.

A few days ago I finished a migration to IDM 4.8 in one of our customers. All the process executed fine, except for one JDBC driver that did not started fine.

That JDBC Driver point to a Microsoft SQL Server 2012 database, and of course requires authentication at the start to connect to the required tables and views. But when we tried to start the driver, the following and "pretty obvious" error message appared on the driver Log:

DirXML Log Event -------------------
Status: Error
Message: <description>Unable to connect. Authentication failed.</description>
<jdbc:exception jdbc:class="java.sql.SQLException" jdbc:error-code="18456" jdbc:sql-state="28000" xmlns:jdbc="urn:dirxml:jdbc">
<jdbc:message>Login failed for user 'integra'.</jdbc:message>

So of course we tested the user and password with SQL Studio, and the user logged in succesfuly on the database.

We reviewed the password and found that it contains a single quotation character ( ' ). And after changing the password by removing that character, the driver started fine. There was no question about it: that character was messing up the driver start procedure.

As of now, the issue has been solved, but my question is about a restricted list of characters in a driver's password. There is any? Or that issue might be related to the JDBC JAR driver itself?

Any suggestion or idea will be greatly appreciated.

Regards, Andres.

Labels (1)
0 Replies
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.