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 |
What are named parameters?
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?
What are the type of Synonyms?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain an integrity constrains?
How to start your 10g xe server from command line?
What are the original export and import utilities?
What is Data Dictionary Cache in Oracle?
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.
What is SQL access advisor in Oracle?