Hi, this is my first post, hope I'm doing this correctly. I'm working with SAP Predictive Analytics and trying to create a connection via ODBC to Oracle. I'm using a driver called, "SAP PA Automated Analytics Oracle Wire Protocol. I fill out the panel with Host, Port and SID, (all provided by my Oracle DBA). When I try to connect I get a error, "SAP ODBC Oracle Wire Protocol Driver Oracle TNS-12505 TNS Listener could not resolve SID given in connect descriptor.
Things I've tried.....
Modifying file, TNSNames.ora on my client machine
Modifying file ODBC.ini on my client machine
I've also tried using the service name as the SID, (I read somewhere that someone had success with that)
None of the above have worked.
Is there something else that I can try that I'm not reviewing?
Any suggestions are greatly appreciated.....
thanks!