NOTICE: Significant community changes coming soon
The header menu and the home page on our community will be changing soon. Get more information HERE.
Absent Member.. Absent Member..
Absent Member..

(SM) Support Tip: Connecting to SM by using 64 bit database (Oracle)

1. In order to connect to SM you have to install 32 bit Oracle client because SM is 32 bit application. Otherwise, you won't be able to make the connection between SM and Oracle.


2. You have to create an environment variable which you have to  point it to directory where the 32 bit client is installed. For example:

Variable name: TNS_ADMIN

Variable value: C:\app\orcl\product\(oracle version) \ (client directory)\NETWORK\ADMIN


After that the issue should be solved and the connection will be successful.


In addition the error message in this situation that you can find in the log should look like this:


"Unable to connect, SQLState=08004 [ORACLE] [ODBC] ORA-12154 TNS could not resolve the connect identifier specified"


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.