recently I got a task to migrate the back end of an access database to oracle (the front end should still remain in access), I need an odbc connection for that and on the PC I am working on I don't have any administrative privilages. Whenever I am trying to add an Oracle ODBC driver an error message appears stating that I need an Oracle(tm) Client + some network ingredients first. The ODBC I am choosing from the list of currently available is : Microsoft ODBC for Oracle.

Is there any way to make it work without installing any client (that probably needs to save stuff in the registry which will lead to permission being denied)?


Use the oracle instant client. You just need to unzip and if you want to use tnsnames.ora set the TNS_ADMIN environment variable.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.