I want get some value on maximo (oracle database), when I try to connect with table connection but I get error.
Look at the picture.
Any solution for solve this problem? Or whats should I gonna check?
Since the error is directly related to the Oracle ODBC driver (not involving the interface yet), you may have better luck looking at Oracle ressources.
Here are some resources to get you going:
Did you install Oracle Client which include sqlnet ? If so, can you test your connection to the database with TNSPING ?
not yet. Can you tell me how to get Oracle client and how to install it?
Request you to check below KB article on this topic. It has a link to Oracle website download page and would request you to download Oracle Provider for OLE DB version as mentioned. Once it is installed, would suggest configuring the oraclient connectivity from PI AF server to Oracle Database.
How to Set up an Oracle Linked Table in AF
hi Mr Lal
I still found error pop up, any solution?
Request you to use oracle net manager to configure TNS entries required for connectivity. You can use this to test the connectivity first and create TNS entries either on server or client. Entries in TNSnames.ora can be copied to AF server , oracle client configuration.
I've successed to make a table connection. But I got trouble on data update. any things which maybe can I set to solve this problem?
Could you please provide more information on what you are trying to achive and will let you know accordingly.
Are you configuring an interface or a linked table in AF?
Please go through this link: Database Connection Issues
In above link you will see Oracle Database connection error codes, their causes, and suggested remedies.
I hope this link will help you.
Thanks & Regards,
Do you work for MindMajix or something? All of your comments so far are on old content and contain a link to the MindMajix website, and the linked page has very little to do with the topic at hand.
Retrieving data ...