For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Help Needed: Fetching Data from SaaS Application to Oracle APEX Using GL_PERIODS, FND_FLEX_VALUES, and FND_FLEX_VALUES_SET APIs
I am not getting standard API's
Check the error reported in “Control panel→System and Securities→Administrative Tools→Event Viewer” under Windows Log→Application.
How did you set the Instant Client path in PATH? In command prompt?
If you have set it in a command prompt, then make sure you start that command prompt as administrator (i.e. opening it by right clicking on command prompt icon and select “run as administrator” from popped context menu). Also, you should start ODBC data source administrator by executing “odbcad32” from that command prompt. Have you?
Yes I started the cmd as run as Administrator.
I am using ODBC 64 bit not 32 bit.
I set the path using Windows UI (System properties), and if I open a cmd window and type set I can see the correct path.
starting “odbcad32” from the command line did not help.
I tried the same process on a different computer and got the same results.
odbcad32 is for ODBC 64 bit on Windows x64 versions. You need to start odbcad32 from syswow64 directory to configure ODBC 32 bit on Windows x64 versions.
Have you checked the Application error logs in Event viewer? Did you find any error related to your ODBC application?
I am running the 64bit version, if I start odbcad32 from syswow64 it starts the 32bit version.
There are no errors in the Event Viewer.
I have tried basic driver version 19.24, but when I click on the Test button, I get the following error:
--------------------------- Testing Connection --------------------------- Unable to connect SQLState=S1000 [Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
--------------------------- OK ---------------------------
Looks like the service name is missing in your connection string.
Here is a sample of connection string:
sales= (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp)(HOST=sales-server)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=sales.us.acme.com))) The part that is highlighted with bold characters seems to be missing in your connection string. Fix it.
This is what I am using.
JDEPRD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = testoda0)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jdeprd.test.com) ) )
Are you able to connect to your database using SQL*Plus?
No:
F:\instantclient_23_5>sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 17 07:55:39 2024 Version 19.24.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Enter user-name: testuser Enter password: ERROR: ORA-12560: TNS:protocol adapter error
Enter user-name:
The issue is fixed
In the ODBC Driver Configuration.
For the TNS Service Name you cannot type the name even if you type it exactly as it shows in the dropdown, you must select it from the dropdown, otherwise it won't work.