If the answer is “yes”, please share your knowledge and experience of multiple ORACLE instantclient and ODBC installations w/ me.Īny/all the help would be greatly appreciated! If the answer is “no”, perhaps use a separate PC for different Oracle Instantclients version is the solution. 32-bit, 64-bit and/or different Oracle versions), along w/ Oracle/ODBC drivers if required for connecting to Oracle database, be installed on a PC? ORA-12154: TNS:could not resolve the connect identifier specified SQLSetConnectAttr failed IM006 0 Driver’s SQLSetConnectAttr failed (#0)Īfter spending a lot of time in trying to resolve the above error, my question is:Ĭan multiple Oracle Instantclients(e.g. Configured the Oracle 10.1 driver in the following ODBC Data Source Administrator:īut, I kept receiving the following error message while trying to connect to Oracle instantclient 10.1 thru ODBC in MS Access 2016:.Verified the dB server name defined in the tnsnames.ora file which is assigned to the TNS_ADMIN System variable name is accurate. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |