How to connect ms access to oracle servers?



How to connect ms access to oracle servers?..

Answer / Yash Kumar

To connect MS Access to an Oracle server, you need an ODBC (Open Database Connectivity) driver for Oracle. After installing the driver, create a new data source in MS Access and specify the appropriate connection details.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What are named parameters?

1 Answers  


I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?

1 Answers  


What are the type of Synonyms?

1 Answers  


Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?

1 Answers  


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1 Answers  


Explain an integrity constrains?

1 Answers  


How to start your 10g xe server from command line?

1 Answers  


What are the original export and import utilities?

1 Answers  


What is Data Dictionary Cache in Oracle?

1 Answers   MCN Solutions,


What is Normalization ?

55 Answers   ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1 Answers  


What is SQL access advisor in Oracle?

1 Answers   MCN Solutions,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)