SQL + _RecordsetPtr [modified]

[C++ Programming]

Hi all

I have make connection through ODBC connection .Connection establish successful.Now i want to retrieve table name from database.

_RecordsetPtr rs;
_bstr_t bt;
HRESULT hr;
CString str;
bt=(_bstr_t)"select * from master.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'";
try
{
hr=rs.CreateInstance (__uuidof(Recordset));
ASSERT(SUCCEEDED(hr));
hr1=rs1->Open (bt,cn.GetInterfacePtr (),adOpenDynamic,adLockOptimistic,adCmdText);
ASSERT(SUCCEEDED(hr));

rs1->MoveFirst();
while(!rs1->EndOfFile)
{
str1=(char*)(_bstr_t)rs->Fields->GetItem("tablename")->Value;
m_database.AddString(str1);
rs->MoveNext();
}
rs->Close();
//m_database.SetCurSel(0);
}
catch(_com_error pCE)
{
CString str;
str.Format(_T("\n%s Error: %ld\r\n%s\r\n%s\r\n"),
(TCHAR*)pCE.Source(),
pCE.Error(),
(TCHAR*)pCE.Description(),
(TCHAR*)pCE.ErrorMessage());
MessageBox(str,"Message");
return ;

}

Error show
Microsoft OLEDB Provider for SQL Server Error:-2147217900
Plz help me

modified on Monday, December 28, 2009 4:44 AM