Attempt to open a table failed......

[vijay victory]

Hi Experts, I have created an Database application using CDatabase and CRecordset. Following is some part of code where the Exception occurs....

CRecordset UserRs(&UserCn);
.
.
Sql="Select * from UserInfo";
//Exception occured here
UserRs.Open(CRecordset::snapshot,Sql,CRecordset::none);

The Exception is : "Attempt to open a table failed-there were no columns to retrieve were specified.." I m confused..Becoz the same code run on my machine doesnt work on others machine. and the query also correct. plz Help me.. Waitng for ur Reply..

I have never failed,I just found 1000 ways that never works. Regards, Victory.

[Mike the Red]

Assuming that there is a table in your DB called UserInfo, I would check that the CDatabase object is connected to the datasource using UserCn.IsOpen before trying to open the RS. Check that the datasource is configured the same on the target machine as it is on yours - including permissions. In my experience, that is the most common source of this type of problem... though I admit my needs have never occasioned use of C++ for database connectivity. MZR