Connection with mysql an Crecordset
-
Hi i am using VC7 and i want to connect mysql 5.1 through odbc driver mysql 5.0. i have conncect database by cdatabase class . after successfuly open the database we called open method of Crecordset but it give exception. CRecordSet rs(m_db);// rs.open(CRecordSet::Dynaset,"Select * form Tablename",CRecordSet::none); above line guve exception aboiut dynaset. we are unable to call open function of Crecordset. but CRecordSet::snapshot work fine.
-
Hi i am using VC7 and i want to connect mysql 5.1 through odbc driver mysql 5.0. i have conncect database by cdatabase class . after successfuly open the database we called open method of Crecordset but it give exception. CRecordSet rs(m_db);// rs.open(CRecordSet::Dynaset,"Select * form Tablename",CRecordSet::none); above line guve exception aboiut dynaset. we are unable to call open function of Crecordset. but CRecordSet::snapshot work fine.
Please check
CDBException::m_strError: it should give you useful info about the problem. :)If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
Please check
CDBException::m_strError: it should give you useful info about the problem. :)If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]i got proper exception in case of "Creordset::dynaset". How can call open method of Crecordset with Creordset::dynaset to fetch record from Mysql
-
i got proper exception in case of "Creordset::dynaset". How can call open method of Crecordset with Creordset::dynaset to fetch record from Mysql
shivanandgupta wrote:
i got proper exception in case of "Creordset::dynaset".
What is 'proper exception'? Why didn't you report the erreor message? :)
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles]