Return
-
Title
[IBM][iSeries Access ODBC Driver]Communication link failure...User xXxX on server xXxX has been disabled - When accessing AS400 -
Description
Toad Data Point (TDP) 3.8 was working just fine, but after installing 4.3, the issue came up, and now even 3.8 has the issue.
One can run a query, but, for the second one it says that the account has been disabled.
Quest.Toad.Exceptions.DatabaseException: [IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=xXxX -xXxX - User xXxX on server xXxX has been disabled, Password length = 9, Prompt Mode = Never, System IP Address = xXxXStack trace:at Quest.Toad.NativeOdbc.OdbcDriverManager.PerformConnectionWithCompletionMode(OdbcHandle connectionHandle, IntPtr parentWindowHandle, String connectionStringIn, DRIVER_COMPLETION_MODES completionMode)at Quest.Toad.NativeOdbc.NativeOdbcConnection.Open()at Quest.Toad.Db.Connection.OpenConnection(IDbConnection connection)at Quest.Toad.Odbc.OdbcToadConnection.OpenConnection(IDbConnection connection)at Quest.Toad.Db.Connection.AllocConnection()at Quest.Toad.Db.Connection.Connect(Boolean notify)at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection() -
Resolution
1. Close Toad
2. Go to : "C:\Users\ [ Windows User ] \AppData\Local\Quest Software\Toad Data Point Hub Data"
3. Rename the folder: "Toad Data Point Hub Data" to "Toad Data Point Hub Data.OLD"
4. Open Toad again ( the issue shouldn't be a problem any more)
Note:
Once It was needed to rename the "Quest Software" folder, instead of: "Toad Data Point Hub Data"
" C:\Users\ [ Windows User ] \AppData\Local\Quest Software_old "