how to use oracle tables using VC++?
-
Megha
-
Megha
Tell us what u want to do?
-
Tell us what u want to do?
I have one table in an Oracle Db.. I want to access that DB in my application so for that i want to create one class. When i m trying to creat enew class using CDaorecordset as base class. I m not getting Table name to select under "SELECT DATABASE TABLE" dialogue. Did u get me?? Could you please help me now? megha
-
I have one table in an Oracle Db.. I want to access that DB in my application so for that i want to create one class. When i m trying to creat enew class using CDaorecordset as base class. I m not getting Table name to select under "SELECT DATABASE TABLE" dialogue. Did u get me?? Could you please help me now? megha
Hi megha, Did you to first create the DSN for that Recordset??? And after that you may use RFX and DDX for exchanging data.
-
Hi megha, Did you to first create the DSN for that Recordset??? And after that you may use RFX and DDX for exchanging data.
Hi alok, I have created DSN Name. On class view when i clicked on new class and selected CRecordset (as baseclass) -> selected ODBC -> and in List box DSN which i have created -> after entering pasword clicked on OK -> then it should display list of tables for which i need to make a class but it not showing that table at all...
-
Hi alok, I have created DSN Name. On class view when i clicked on new class and selected CRecordset (as baseclass) -> selected ODBC -> and in List box DSN which i have created -> after entering pasword clicked on OK -> then it should display list of tables for which i need to make a class but it not showing that table at all...
Hi megha, First we will have to see whether you have successfully established the connection with your Oracle. For This :- 1. Test your connection to Oracle by opening a DOS Prompt and typing tnsping rep 2. The result should say "OK" at the bottom. Any failure to connect most likely indicates a problem with the sqlnet.ora file on the system. Replace the sqlnet.ora and tnsnames.ora files in C:\oracle\ora92\network\ADMIN.