Prev: ORA-01654 Fix?
Next: Oracle MERGE to remote DB with ORA-01008: not all variables bound
From: rfd@outb.com on 8 Jan 2006 04:29
I'm running Windows XP and want to connect MS Access to a remote Oracle
10g database. I have installed Instant Client 10.2.0.1.0 and the ODBC
package. The ODBC package includes odbc_install.exe. When I run that
file I get an error message "Could't find Oracle Instant Client in
present directory." I have the directory set in the path variable and
have ORACLE_HOME pointing to the same directory. Here is the contents
of the instant client directory:

classes12.jar
glogin.sql
oci.dll
ocijdbc10.dll
ociw32.dll
ODBCRelnotesJA.htm
ODBCRelnotesUS.htm
ODBC_IC_Readme_Win.html
odbc_install.exe
odbc_uninstall.exe
ojdbc14.jar
orannzsbb10.dll
oraocci10.dll
oraociicus10.dll
Orasqlplusic10.dll
sqlplus.exe
sqora.chm
sqora32.dll
sqoraja.chm
sqoras32.dll
sqresja.dll
sqresus.dll

I can connect to the remote using TOAD for Oracle from Quest Software,
but would like to be able to us MS Access.

Can anyone tell me why the odbc_install.exe is not working?

From: Maxim Demenko on 9 Jan 2006 06:40
rfd(a)outb.com schrieb:
> I'm using Windows XP. I want to connect to a remote Oracle 10g
> database. I have installed the Instant Client 10.2.0.1.0 Basic Lite and
> the ODBC package. The directory is included in the PATH and ORACLE_HOME
> is set to that same directory. The ODBC package includes a file
> odbc_install.exe. When I run that file I get the error message "Could't
> find Oracle Instant Client in present directory." Here is the contents
> of the directory:
>
> classes12.jar
> glogin.sql
> oci.dll
> ocijdbc10.dll
> ociw32.dll
> ODBCRelnotesJA.htm
> ODBCRelnotesUS.htm
> ODBC_IC_Readme_Win.html
> odbc_install.exe
> odbc_uninstall.exe
> ojdbc14.jar
> orannzsbb10.dll
> oraocci10.dll
> oraociicus10.dll
> Orasqlplusic10.dll
> sqlplus.exe
> sqora.chm
> sqora32.dll
> sqoraja.chm
> sqoras32.dll
> sqresja.dll
> sqresus.dll
>
> I can connect to the remote database using TOAD for Oracle from Quest
> Software but want to use MS Access to front-end the database for
> economic reasons.
>
> Can anyone tell me why odbc_install.exe fails in this manner?
>

In the ODBC_IC_Readme_Win.html is stated, that you have to install
instant client basic (not instant client basic lite) package.
You should also ensure to have mfc71.dll and msvcrt.dll in your PATH as
well set TNS_ADMIN to your instant client directory.

Best regards

Maxim
 | 
Pages: 1
Prev: ORA-01654 Fix?
Next: Oracle MERGE to remote DB with ORA-01008: not all variables bound