Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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)?

share|improve this question
add comment

1 Answer 1

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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