Hi All,
I am new to this oracle world.
I am very curious and also confused after going through a lot of study on oracle database access methodology.
I am also using OLEDB provider for oracle which i am using my MFC application to connect to oracle database.
my connection string looks like
"Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; PLSQLRSet=/;"
Before starting i need to setup my Oracle server placed remotely and Oracle client then my MFC application starts working.
I have below questions:
1. Which driver/library is being used in above case. I mean JDBC/ODBC driver, or OraOLEDB through OLE DB or ADO?
How can i identify which one i am using.
2. What is the difference between these three methodology?
3. I am suspecting that i am using oracle provided oledb(oraOLEDB). How shall i move to another drivers?Any references or link??
4. How to use ODBC/JDBC driver to access database server from any windows client application? Any online reference??
5. Which is more efficient/faster ??
I am sorry if i am posting silly question.
I want to understand these.
Thanks in advance.