From: email@example.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:
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
> 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:
> 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.
Prev: ORA-01654 Fix?
Next: Oracle MERGE to remote DB with ORA-01008: not all variables bound