rpadminserver
Board Regular
- Joined
- Nov 7, 2007
- Messages
- 111
- Office Version
- 365
Hello all.
My laptop is Window 7 64 bit.
I have office 2010 32 bit.
I was able to create and ODBC connection using \windows\syswow64\odbcad32.exe
Now I'm attempting to make an ODBC connection to an ORACLE database thought ACCESS so I can create a linked table. and I get "ORA-12154: tns could not resolve the connect identifier....".
I suspect the problem is that ACCESS2010 is using the odbcad32.exe in the system32 folder, and not the one in the syswow64 folder.
Is there anyway to change windows (or office) to use the ODBCAD32.exe in the syswow64 folder?
Thanks
My laptop is Window 7 64 bit.
I have office 2010 32 bit.
I was able to create and ODBC connection using \windows\syswow64\odbcad32.exe
Now I'm attempting to make an ODBC connection to an ORACLE database thought ACCESS so I can create a linked table. and I get "ORA-12154: tns could not resolve the connect identifier....".
I suspect the problem is that ACCESS2010 is using the odbcad32.exe in the system32 folder, and not the one in the syswow64 folder.
Is there anyway to change windows (or office) to use the ODBCAD32.exe in the syswow64 folder?
Thanks