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,

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.

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,

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.

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.

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.