CRecordset and Oracle 8
-
I have created a simple VC Dialog based application and added a CRecordSet through the wizard over a table in the Oracle database using an ODBC connection. The ODBC connection is fine cause the ODBC test for Oracle has verified it. The problem is when I call COracleRecSet recset; recset.Open(); The application hangs :confused: . Can anybody please tell what can be the problem.
-
I have created a simple VC Dialog based application and added a CRecordSet through the wizard over a table in the Oracle database using an ODBC connection. The ODBC connection is fine cause the ODBC test for Oracle has verified it. The problem is when I call COracleRecSet recset; recset.Open(); The application hangs :confused: . Can anybody please tell what can be the problem.
Maybe oracle only support open with: CRecordset::forwardOnly
-
I have created a simple VC Dialog based application and added a CRecordSet through the wizard over a table in the Oracle database using an ODBC connection. The ODBC connection is fine cause the ODBC test for Oracle has verified it. The problem is when I call COracleRecSet recset; recset.Open(); The application hangs :confused: . Can anybody please tell what can be the problem.
Did you open a CDatabase object first to the database? Something like : CDatabase DB; DB.OpenEx(...) COracleRecSet recset (&DB); recset.Open(...) Best regards, Alexandru Savescu
-
Did you open a CDatabase object first to the database? Something like : CDatabase DB; DB.OpenEx(...) COracleRecSet recset (&DB); recset.Open(...) Best regards, Alexandru Savescu
-
Is it necessary. I think for CRecordSet that was not necessary. But I tried that too. Sorry same problem. :confused: It hangs when calling recset.Open() :((
Well I think it necessary. Try stepping into the MFC code and see where it hangs more specifically. There are a lot of reasons for which a Open will fail. Good luck! Best regards, Alexandru Savescu
-
Well I think it necessary. Try stepping into the MFC code and see where it hangs more specifically. There are a lot of reasons for which a Open will fail. Good luck! Best regards, Alexandru Savescu
First of all thanks that you are taking interest in this. I traced into the MFC recordset code. The database object gets allocated fine. The application hangs on the actual SC_ API call that connects to the oracle database. Someone suggested that it can be the problem of the drivers. Can you comment...This problem is really bugging me.