Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC - Connection Falure in MS Access

404421Sep 22 2003 — edited Sep 23 2003
I am attempting to use MS Access to run queries on our Oracle 9.2 database. I have downloaded and installed the 9.2.0.5.0 oracle driver. However, I cannot see it as a driver choice in ODBC Data Source Administrative Tool. This is an XP Professional OS. How do I get the oracle driver to appear on the list of drivers in the administrative tool?

Below is the installActions file
Environment variables:
ORACLE_HOME =
PATH = .\bin\win32;c:\oracle\ora92\bin;C:\Program Files\Oracle\jre\1.3.1\bin;C:\Program Files\Oracle\jre\1.1.8\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\PC-Doctor for Windows\services;"C:\Program Files\Oracle\jre\1.3.1\bin";""C:\Program Files\Oracle\jre\1.1.8\bin";"c:\oracle\ora92\bin;c:\oracle\ora92\network\admin;""";";
CLASSPATH =
Username is: dickinss

The installer version is 2.2.0.12.0

*** Welcome Page***
Setting value of SHOW_COMPONENT_LOCATIONS_PAGE to true
Setting value of SHOW_CUSTOM_TREE_PAGE to true
Setting value of SHOW_SUMMARY_PAGE to true
Setting value of SHOW_INSTALL_PROGRESS_PAGE to true
Setting value of SHOW_REQUIRED_CONFIG_TOOL_PAGE to true
Setting value of SHOW_OPTIONAL_CONFIG_TOOL_PAGE to true
Setting value of SHOW_RELEASE_NOTES to true
Setting value of SHOW_END_SESSION_PAGE to true
Setting value of SHOW_SPLASH_SCREEN to true
Setting value of SHOW_WELCOME_PAGE to true
Setting value of SHOW_ROOTSH_CONFIRMATION to true
Setting value of SHOW_EXIT_CONFIRMATION to true
Setting value of NEXT_SESSION to true
Setting value of NEXT_SESSION_ON_FAIL to true
Setting value of SHOW_DEINSTALL_CONFIRMATION to true
Setting value of SHOW_DEINSTALL_PROGRESS to true
Setting value of INVENTORY_LOCATION to C:\Program Files\Oracle\Inventory
Setting value of UNIX_GROUP_NAME to
Initializing inventory setup WCCE
Doing operation in inventory setup WCCE
Setting value of CLUSTER_NODES to

*** Cluster Node Selection Page***
ClusterNodes = CLUSTER_NODES =
Setting value of FROM_LOCATION to D:\stage\products.jar
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_NAME to OraHome92

*** File Locations Page***
FromLocation = FROM_LOCATION = D:\stage\products.jar
ToLocation = ORACLE_HOME = c:\oracle\ora92
ToName = ORACLE_HOME_NAME = OraHome92
Initializing installer access setup
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_KEY to Software\ORACLE\HOME1
Setting value of ORACLE_HOME_FOLDER to Oracle - OraHome92
Setting value of ORACLE_HOME_SERVICE to OraHome92
Error :*** Alert: File D:/stage/products.jar not found. ***
User selected: Yes/OK

Doing operation for installer access setup

*** File Locations Page***
FromLocation = FROM_LOCATION = null
ToLocation = ORACLE_HOME = null
ToName = ORACLE_HOME_NAME = null
Setting value of CLUSTER_NODES to

*** Cluster Node Selection Page***
ClusterNodes = CLUSTER_NODES =
Doing operation in inventory setup WCCE
*** Welcome Page***
Setting value of FROM_LOCATION to D:\stage\products.jar
Setting value of ORACLE_HOME_NAME to OraHome92
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of SHOW_COMPONENT_LOCATIONS_PAGE to true
Setting value of SHOW_CUSTOM_TREE_PAGE to true
Setting value of SHOW_SUMMARY_PAGE to true
Setting value of SHOW_INSTALL_PROGRESS_PAGE to true
Setting value of SHOW_REQUIRED_CONFIG_TOOL_PAGE to true
Setting value of SHOW_OPTIONAL_CONFIG_TOOL_PAGE to true
Setting value of SHOW_RELEASE_NOTES to true
Setting value of SHOW_END_SESSION_PAGE to true
Setting value of SHOW_SPLASH_SCREEN to true
Setting value of SHOW_WELCOME_PAGE to true
Setting value of SHOW_ROOTSH_CONFIRMATION to true
Setting value of SHOW_EXIT_CONFIRMATION to true
Setting value of NEXT_SESSION to true
Setting value of NEXT_SESSION_ON_FAIL to true
Setting value of SHOW_DEINSTALL_CONFIRMATION to true
Setting value of SHOW_DEINSTALL_PROGRESS to true
Setting value of INVENTORY_LOCATION to C:\Program Files\Oracle\Inventory
Setting value of UNIX_GROUP_NAME to
Initializing inventory setup WCCE
Doing operation in inventory setup WCCE
Setting value of CLUSTER_NODES to

*** Cluster Node Selection Page***
ClusterNodes = CLUSTER_NODES =
Setting value of FROM_LOCATION to D:\stage\products.jar
Setting value of ORACLE_HOME to C:\oracle\ora817
Setting value of ORACLE_HOME_NAME to Ora817

*** File Locations Page***
FromLocation = FROM_LOCATION = D:\stage\products.jar
ToLocation = ORACLE_HOME = C:\oracle\ora817
ToName = ORACLE_HOME_NAME = Ora817
Initializing installer access setup
Setting value of ORACLE_HOME to C:\oracle\ora817
Setting value of ORACLE_HOME_KEY to Software\ORACLE\HOME0
Setting value of ORACLE_HOME_FOLDER to Oracle - Ora817
Setting value of ORACLE_HOME_SERVICE to Ora817
Error :*** Alert: File D:/stage/products.jar not found. ***
User selected: Yes/OK

Doing operation for installer access setup
Setting value of FROM_LOCATION to D:\stage\products.jar
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_NAME to OraHome92
Setting value of FROM_LOCATION to C:\Program Files\Oracle\products.jar
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_NAME to OraHome92

*** File Locations Page***
FromLocation = FROM_LOCATION = C:\Program Files\Oracle\products.jar
ToLocation = ORACLE_HOME = c:\oracle\ora92
ToName = ORACLE_HOME_NAME = OraHome92
Initializing installer access setup
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_KEY to Software\ORACLE\HOME1
Setting value of ORACLE_HOME_FOLDER to Oracle - OraHome92
Setting value of ORACLE_HOME_SERVICE to OraHome92
Error :*** Alert: File C:/Program Files/Oracle/products.jar not found. ***
User selected: Yes/OK

Doing operation for installer access setup
Setting value of FROM_LOCATION to D:\stage\products.jar
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_NAME to OraHome92
Setting value of FROM_LOCATION to C:\oracle\ora92\stage\Disk1\stage\products.jar
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_NAME to OraHome92

*** File Locations Page***
FromLocation = FROM_LOCATION = C:\oracle\ora92\stage\Disk1\stage\products.jar
ToLocation = ORACLE_HOME = c:\oracle\ora92
ToName = ORACLE_HOME_NAME = OraHome92
Initializing installer access setup
Setting value of ORACLE_HOME to c:\oracle\ora92
Setting value of ORACLE_HOME_KEY to Software\ORACLE\HOME1
Setting value of ORACLE_HOME_FOLDER to Oracle - OraHome92
Setting value of ORACLE_HOME_SERVICE to OraHome92
Setting value of ToplevelComp to oracle.odbc.toplevel, 9.2.0.5.0, >0.0.0.0.0, [ 912 ][OH:2]
Setting value of SELECTED_LANGUAGES to [en]
Setting value of PROD_HOME to c:\oracle\ora92/oracle_odbc_toplevel
Setting value of PROD_HOME to c:\oracle\ora92in
Doing operation for installer access setup

*** Available Products Page***
TopLevelComp = ToplevelComp = oracle.odbc.toplevel, 9.2.0.5.0, >0.0.0.0.0, [ 912 ][OH:2]
Setting value of ToplevelComp to oracle.odbc.toplevel, 9.2.0.5.0, >0.0.0.0.0, [ 912 ][OH:2]
Setting value of DEP_MODE to Custom
Setting value of TLDepModes to Custom,

*** Installation Types Page***
DepMode = DEP_MODE = Custom
TLDepModes = TLDepModes = Custom,
The selected install type is "null"
Setting value of DEP_MODE to Custom
Install type for "Oracle 9i ODBC Driver 9.2.0.5.0 " is "Custom"
Install type for "Oracle ODBC Driver 9.2.0.5.0 " is "Custom"
Setting value of PRE_REQUISITE to true
Calling query areasQueries2.2.0.7.0 getComponentInstallTypeName
Query returned : Custom
Setting value of PRE_REQUISITE to true

*** Component Locations Page***
ShowCompLocs = SHOW_COMPONENT_LOCATIONS_PAGE = true
Entering component: oracle.odbc.toplevel installation
Setting value of s_OPSSelectedNodes to
Entering component: oracle.p2k.odbc installation
Setting value of s_OPSSelectedNodes to
Calling query WindowsGeneralQueries2.2.0.7.0 getWindowsDirectory
Query returned : C:\WINNT
Setting value of WINS32ROOT to C:\WINNT
Calling query WindowsGeneralQueries2.2.0.7.0 getWindowsSystemDirectory
Query returned : C:\WINNT\System32
Setting value of WINS32DIR to C:\WINNT\System32
Setting value of RegistryRoot to HKEY_LOCAL_MACHINE
Setting value of DRIVER_NAME to Oracle in
Setting value of ORCLBIN to c:\oracle\ora92\BIN
Setting value of ODBCDIR to c:\oracle\ora92\ODBC
Setting value of NET_ADMIN_FOLDER to Oracle - OraHome92\Network Administration
Setting value of ODBCMesgDir to c:\oracle\ora92\ODBC\mesg
Setting value of ODBCKey to software\odbc\odbcinst.ini\Oracle in OraHome92
Setting value of ODBCHtmlDir to c:\oracle\ora92\ODBC\html
Setting value of ODBCHelpDir to c:\oracle\ora92\ODBC\help
Setting value of SHOW_SUMMARY_PAGE to true

*** Summary Page***
ShowSummary = SHOW_SUMMARY_PAGE = true
Global Settings
Source : C:\oracle\ora92\stage\Disk1\stage\products.jar
Oracle Home : c:\oracle\ora92 (OraHome92)
Installation Type : Custom
Product Languages
English
Space Requirements
C:\ Required 2MB (includes 500KB temporary) : Available 30.52GB
New Installations (2 products)
Oracle 9i ODBC Driver 9.2.0.5.0
Oracle ODBC Driver 9.2.0.5.0
*** Install Page***
Starting install install phase 1 of component Oracle ODBC Driver
Warning :*** Alert: This install was unsuccessful because: java.lang.NullPointerException Would you like to end this session now? ***
User selected: No

Starting install install phase 1 of component Oracle 9i ODBC Driver
Starting install install phase 2 of component Oracle ODBC Driver
Starting install install phase 2 of component Oracle 9i ODBC Driver
Initializing installer save inventory WCCE
Current Inventory:
Independent Products:
Java Runtime Environment 1.1.8.16.0
Java Runtime Environment 1.3.1.1.0a
Oracle Universal Installer 2.2.0.12.0
Oracle Home: Ora817
Oracle Home: OraHome92
Oracle9i Client 9.2.0.1.0
Bali Share 1.1.17.0.0
Oracle JFC Extended Windowing Toolkit 4.1.10.0.0
RDBMS Required Support Files 9.2.0.1.0
Oracle Trace Required Support Files 9.2.0.1.0
Enterprise Manager Minimal Integration 9.2.0.1.0
Oracle Extended Windowing Toolkit 3.4.13.0.0
Oracle Ice Browser 5.06.8.0.0
Oracle Client Required Support Files 9.2.0.1.0
Precompiler Required Support Files 9.2.0.1.0
Agent Required Support Files 9.2.0.1.0
SSL Required Support Files 9.2.0.1.0
Parser Generator Required Support Files 9.2.0.1.0
Oracle Help For Java 4.1.13.0.0
Oracle Code Editor 1.2.1.0.0A
PL/SQL Required Support Files 9.2.0.1.0
Platform Required Support Files 9.2.0.1.0
Oracle Core Required Support Files 9.2.0.1.0
Oracle9i Globalization Support 9.2.0.1.0
Oracle Help For Java 3.2.13.0.0
LDAP Required Support Files 9.2.0.1.0
Installation Common Files 9.2.0.1.0
Sun JDK extensions 9.2.0.1.0
Documentaion Required Support Files 9.2.0.1.0
Oracle Net Required Support Files 9.2.0.1.0
Sun JDK 1.3.1.0.1a
DBJAVA Required Support Files 9.2.0.1.0
XDK Required Support Files 9.2.0.1.0
Required Support Files 9.2.0.1.0
Assistant Common Files 9.2.0.1.0
Oracle Net Configuration Assistant 9.2.0.1.0
SQL*Plus 9.2.0.1.0
Oracle Net Manager 9.2.0.1.0
Oracle Net 9.2.0.1.0
Oracle Network Utilities 9.2.0.1.0

Setting value of SHOW_END_SESSION_PAGE to true

*** End of Installation Page***
ShowEndSession = SHOW_END_SESSION_PAGE = true
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 21 2003
Added on Sep 22 2003
2 comments
813 views