Support - ADB error message : [DataDirect][ODBC 20101 driver]1906072

Como este blog não foi feito só para as baboseiras do Daniel, aqui vai algo que pode ajudar muito pessoal:

Em Inglês pá estrangeirada:

As it can be seen on the title of the blog, we are a support team for a tibco project in Portugal.
Recently we came across a problem that was hard to determine as ours.
The message [DataDirect][ODBC 20101 driver]1906072 appeared on one of our adb.
After some investigating we determined that this is related with problems in the odbc.ini file.
So if you come across with something similar, please start by checking the odbc.ini file.

In adition:
On Unix machines, the Adapter error 20101 implies that your locale settings are not appropriately set (or) that the InstallDir parameter of the DSN named [ODBC] in the odbc.ini file does not point to the correct ODBC Home Directory.

To correct this situation, please follow the steps below.

1) Ensure that the property "InstallDir" of the Data Source named [ODBC] in the odbc.ini file has the right path to the odbc home directory (i.e. .../adapter/adadb//odbc).

2) Verify that your LANG and LC_MESSAGES environment variables are set to en_US or C. You can check this by typing locale at a shell prompt. If for some reason it must be set to a different value, you should create a symbolic link in the $ODBCHOME/locale directory with the same name as $LANG that points to the en_US directory. For example, if LANG=fr_CA.utf8, you would create a symbolic link called fr_CA.utf8 that points to en_US. For help on creating symbolic links see the man page for the ln command.

3) Verify that the user that the application using ODBC is running under has read/execute permission to the directory the message files are contained in ($ODBCHOME/locale/en_US/LC_MESSAGES). Also verify the user has read permissions to the message files themselves.

4) Verify the locale directory is located in the parent directory of the lib directory. In other words, make sure the locale directory is in the same directory that the lib directory is located in. (Both locale and lib directories should be under odbc home directory)

5) Run the below simple test to make sure the driver message files are being loaded. The below test is to login to the database using dbtest utility with invalid userid. After the last step of this test, make sure that the error message does not contain the number 20101.

a. Open a shell prompt and browse to the Adapter bin directory.
b. Issue the command $ . ./adbagent_env.sh

eg. [adainfy@accrdlnxas3 bin]$ . ./adbagent_env.sh

c. At the prompt, issue the following command and try to login to the Adapter database by providing an invalid userid.

$ dbtest /@

eg. [adainfy@accrdlnxas3 bin]$ dbtest testuser/wrongpassword@ODBCDSN



Hope this may be of use :)