Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How-To Setup ODBC Connection To An Oracle DB In WebFOCUS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
How-To Setup ODBC Connection To An Oracle DB In WebFOCUS
 Login/Join
 
Ron Woods
Member
posted
I've installed the Oracle ODBC driver and setup/tested the ODBC connection via the Control Panel.

I've added the connection to the list of ODBC Adapters with security set to 'Explicit'.

When I try to bring in the metadata for the table descriptions I get the following error:
(FOC1394) CONNECT FAILURE (FOC1400) SQLCODE IS 160 (HEX: 000000A0) : [IM003] Specified driver could not be loaded due to system error 1114 ( : Oracle in OraDb10g_home1). (FOC1405) SQL PREPARE ERROR.

The driver location (OraDB10g_home1) is pointing to the correct folder. Am I missing something in the setup?

Thanks,
Ron Woods
San Antonio Express-News


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
GinnyJakes
Expert
posted Hide Post
Ron,

Can you please add to your signature your product suite, release, and most importantly your platform? That will make it easier for us to help you.

For instance, if you are on a Unix box, you have to make sure that you have access to the ODBC drivers.

Also, what happens when you log onto the reporting server console, go to adapters, and click sample data on your connection? That is a good test to make sure that everything is in place in order to access the data.

So, give us a bit more info and hopefully we'll be able to help you.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Ron Woods
Member
posted Hide Post
Whoops, I knew I forgot something.

Product/Platform Info - WebFOCUS 711 Server on System: Windows NT-5.2 x86 32bit

The ODBC adapter only has Create Synonym, Delete and Properties setting - no test setting like the SQL Server and MVS adapters


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
GinnyJakes
Expert
posted Hide Post
Ron,

You need to log onto the reporting server web console as I mentioned above. URL is

http://yourservername:8121

or whatever your port is for the http listener. You must be an admin to do this. Click on the Adapter link, find your connection, and test. If you do not have a connection here, then that is your problem and you must set it up here.

Add that wonderful platform information to your profile signature and it will show up every time you post.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Ron Woods
Member
posted Hide Post
I believe I have found the problem. I added my Oracle ODBC connection to an ODBC adapter setup that uses the MS Excel driver. I suspect I have to add a totally new adapter with Oracle info.

I am at my license limit for adapters so I'll have to get with my sales rep to see what needs to be done.

Thanks for your help.


Ron Woods
San Antonio Express-News
Release: WebFOCUS 7.1.1
OS/Platform: Windows XP SP2 x86 32bit
O/P Formats: Primarily pdf and xls
 
Posts: 22 | Location: San Antonio, Tx | Registered: October 20, 2005Report This Post
OPALTOSH
Platinum Member
posted Hide Post
Why don't you use the native Oracle adapter which uses the Oracle client software (SQL NET). It's much faster and more efficient than the ODBC adapter.
 
Posts: 140 | Location: Adelaide South Australia | Registered: October 27, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     How-To Setup ODBC Connection To An Oracle DB In WebFOCUS

Copyright © 1996-2020 Information Builders