The following was done on XP machine, Access 2003 and Oracle Database Express 10.2.0 server
For a good cookbook on how to set up Access-Oracle with ODBC see this:
http://aspalliance.com/893
Preparation:
1) -->Check listener, tnsnames that they have entries for xe, host,port
-->lsnrctl status, lsnrctl services, reload (if necessary)
-->connect to sqlplus via listener: sqlplus hr/oracle@dell
-->If on local machine best switch off firewalls such as ZAlarm (I had big mistake here
having MS Access blocked off for Trusted Zone)
Troubleshooting:
1) Setup the ODBC source so that you can run Access front-end with Oracle XE back-end:
Data Sources (ODBC), File DSN
--> Add
--> Look in Data Sources
--> Type in Name
--> Pick either Microsoft ODBC for Oracle or Oracle in XE
--> Service name --> name of the db -->xe
Username : hr
Pswd:oracle
--> Ok
2)
-->Still can't connect to oracle or ms odbc driver out of Administrative Tools
getting messages of ora-12541 - says there's no listener
3)
-->Proceed as per these links - basically need to modify registry entries for MS odbc
setup. Look these:
--> http://www.experts-exchange.com/Databases/Oracle/Tools_Development/Q_21887808.html
-->
269600
-->For Oracle Application Express change registry entries as per this:
SQLLib80.dll change to: orasql10.dll
xa80.dll change to: oraclient10.dll
4) Best restart just to make sure
5) In my case problem was fixed....
May the force be with us
Icecube