OraDb10g_home1 does not show up in ODBC
BenSMay 8 2009 — edited May 11 2009I've started the tutorial: Creating a Repository Using the Oracle Business Intelligence Administration Tool
Locagted at: http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/bi_admin/biadmin.html
I've Installed (in the following order)
Oracle Express 10g
Oracle client 10g
Microsoft .Net Framework SDK 2.0
Microsoft SQL Server 2005
Visual Studios 2005
Oracle ODAC Home1 (Oracle Developer Tools)
Oracle Business Intelligence Suite
In the tutorial we are asked to craete an ODBC Data Source. The data source is supposed to use driver Oracle in OraDb10g_home1. This does not show up in my list of data sources. I believe I have installed everything that was required for this tutorial and for the BI Suite. Can you please advise as to what I need to do to get this data source installed or to show up?
Current data sources that show up are:
Oracle BI Server
Oracle in XE
Oracle in XE Client
Oracle Merant ODBC Driver
I was reading some threads that suggested the contents of the System Path variable should contain a link to the sqora32.dll file.
Here are the contents of my System Path variable (the sqora32.dll file is located in the first path):
C:\oraclexe\app\oracle\product\10.2.0\server\BIN;
C:\OracleBI\server\Bin;
C:\OracleBI\web\bin;
C:\OracleBI\web\catalogmanager;
C:\OracleBI\SQLAnywhere;
C:\Program Files\Java\jdk1.6.0_12\bin;
E:\oracle\product\10.2.0\client_1\bin;
C:\XEClient\bin;
C:\oraclexe\app\oracle\product\10.2.0\server\bin;
%SystemRoot%\system32;
%SystemRoot%;
%SystemRoot%\System32\Wbem;
C:\Program Files\Intel\WiFi\bin\;
C:\Program Files\Microsoft SQL Server\90\Tools\binn\
Thanks...