Oracle ODBC connectivity - Explain how to create a Data Source. posted by
Babu Kunwar
Explain how to create a Data Source.
In database terms, a data source is a specific set of data, and we can have one
or more data sources active in our application at one time.
Creating an Oracle ODBC data source is much simpler than a MSSQL ODBC. The only
thing that we need to keep in mind is the use of ODBC data sources for Oracle
usually requires an Oracle client to be installed.
Steps involved are:
-
Select the Microsoft ODBC for Oracle, or the Oracle Client ODBC driver.
-
Set the Data Source Name which is the VODBC name that is referred to in the
vconfig.txt files. Here the Username property is optional.
More links
What is replication? Explain its purpose.
Oracle Server supports two different forms of replication: basic and advanced
replication. Explain difference between these.
What is the difference between a snapshot and a materialized view?
Describe how to implement basic snapshot replication.
What object types can and cannot be replicated in oracle?
Describe how to monitor replication..............
|
