- Babu Ambalavanan
- PowerBuilder
- Tuesday, 8 October 2024 07:03 PM UTC
I am trying to migrate a PowerBuilder application built many years ago to the new 2022 R3 version. I created a connection profile for connecting the application to the Oracle database but I get the error "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA".
I have placed a TNSNames.ora file with the SERVICE_NAME in CONNECT_DATA parameter defined.
My questions are
1) Why is PowerBuilder not recognizing this tnsnames.ora file?
2) Should the TNSNames.ora file be placed in a specific folder?
3) Is there any other way to pass this SERVICE_NAME in CONNECT_DATA information when trying to connect from PowerBuilder to Oracle?
Thanks to anyone who can help with this.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.