Click here to Skip to main content
15,914,258 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: structure checking Pin
Luc Pattyn28-Dec-09 5:29
sitebuilderLuc Pattyn28-Dec-09 5:29 
GeneralRe: structure checking Pin
Richard MacCutchan28-Dec-09 5:42
mveRichard MacCutchan28-Dec-09 5:42 
GeneralRe: structure checking Pin
Luc Pattyn28-Dec-09 5:44
sitebuilderLuc Pattyn28-Dec-09 5:44 
GeneralRe: structure checking Pin
Richard MacCutchan28-Dec-09 6:26
mveRichard MacCutchan28-Dec-09 6:26 
AnswerRe: structure checking Pin
CPallini28-Dec-09 1:28
mveCPallini28-Dec-09 1:28 
GeneralRe: structure checking Pin
kk.tvm30-Dec-09 19:45
kk.tvm30-Dec-09 19:45 
QuestionNamed pipes cross domains Pin
vikramlinux27-Dec-09 22:56
vikramlinux27-Dec-09 22:56 
QuestionSQL + _RecordsetPtr [modified] Pin
NVCprog27-Dec-09 22:34
NVCprog27-Dec-09 22:34 
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

QuestionA Bug with MFC Aero Wizards ? Pin
Ahmed Charfeddine27-Dec-09 22:18
Ahmed Charfeddine27-Dec-09 22:18 
AnswerRe: A Bug with MFC Aero Wizards ? Pin
Greg Marr13-Jan-10 12:08
Greg Marr13-Jan-10 12:08 
QuestionPragmas in C Pin
Razanust27-Dec-09 21:19
Razanust27-Dec-09 21:19 
AnswerRe: Pragmas in C [modified] Pin
Nuri Ismail27-Dec-09 21:36
Nuri Ismail27-Dec-09 21:36 
AnswerRe: Pragmas in C Pin
sashoalm27-Dec-09 23:06
sashoalm27-Dec-09 23:06 
AnswerRe: Pragmas in C Pin
Richard MacCutchan27-Dec-09 23:19
mveRichard MacCutchan27-Dec-09 23:19 
AnswerRe: Pragmas in C Pin
Bram van Kampen28-Dec-09 1:31
Bram van Kampen28-Dec-09 1:31 
GeneralRe: Pragmas in C //Is this a Bug in CP?? Pin
Bram van Kampen28-Dec-09 1:42
Bram van Kampen28-Dec-09 1:42 
GeneralRe: Pragmas in C //Is this a Bug in CP?? Pin
Nuri Ismail28-Dec-09 3:29
Nuri Ismail28-Dec-09 3:29 
GeneralRe: Pragmas in C //Is this a Bug in CP?? Pin
Bram van Kampen28-Dec-09 13:30
Bram van Kampen28-Dec-09 13:30 
QuestionError on CString Pin
Anu_Bala27-Dec-09 17:08
Anu_Bala27-Dec-09 17:08 
AnswerRe: Error on CString Pin
LunaticFringe27-Dec-09 17:24
LunaticFringe27-Dec-09 17:24 
GeneralRe: Error on CString Pin
Anu_Bala27-Dec-09 17:46
Anu_Bala27-Dec-09 17:46 
GeneralRe: Error on CString Pin
Rajesh R Subramanian27-Dec-09 19:27
professionalRajesh R Subramanian27-Dec-09 19:27 
QuestionDeveloping a gui toolkit Pin
bi0phaz327-Dec-09 16:03
bi0phaz327-Dec-09 16:03 
AnswerRe: Developing a gui toolkit Pin
«_Superman_»27-Dec-09 16:10
professional«_Superman_»27-Dec-09 16:10 
GeneralRe: Developing a gui toolkit Pin
bi0phaz327-Dec-09 16:12
bi0phaz327-Dec-09 16:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.