Retail Predictive Application Server (MOSC)

MOSC Banner

RPAS ODBC/JDBC not working as intented

edited Nov 13, 2017 6:52AM in Retail Predictive Application Server (MOSC) 8 commentsAnswered

Hi all,

I have an AIX machine with RPAS and RDF installed and configured.

I have successfully installed ODBC as Oracle recommended and I have configured DataSources.

I can connect to the ODBC agent through the management console (installed in Windows) and the "Test Connection" in the ODBC Data Source Administrator is successfull as well.

I can connect to my DataSource using the Interactive SQL tool (ISQL) but here is where the problems start.

Although the connection is successful, I am unable to do a query on the metadata tables (see below screenshot)

My final goal would be to be able to use Oracle SQL Developer to query the RPAS DB.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center