Click here to Skip to main content
15,887,267 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: Access violation iin SendMessage Pin
Anu_Bala22-Dec-09 0:48
Anu_Bala22-Dec-09 0:48 
GeneralRe: Access violation iin SendMessage Pin
CPallini22-Dec-09 1:35
mveCPallini22-Dec-09 1:35 
Questionsh_read: Undeclared identifier Pin
Anu_Bala21-Dec-09 22:37
Anu_Bala21-Dec-09 22:37 
AnswerRe: sh_read: Undeclared identifier Pin
KingsGambit21-Dec-09 23:06
KingsGambit21-Dec-09 23:06 
GeneralRe: sh_read: Undeclared identifier Pin
Anu_Bala21-Dec-09 23:12
Anu_Bala21-Dec-09 23:12 
Questionerror C2487 Pin
Nandu_77b21-Dec-09 22:33
Nandu_77b21-Dec-09 22:33 
AnswerRe: error C2487 Pin
KingsGambit21-Dec-09 23:10
KingsGambit21-Dec-09 23:10 
QuestionRe-Mssql question Pin
MsmVc21-Dec-09 20:28
MsmVc21-Dec-09 20:28 
Hi All
USE database command is not working for me.I was asking same question in last week but still i have no solution then i ask one more time.Plz help me

connection code is here
CString str1="",str2="",str3="";
	HRESULT hr;
	if SUCCEEDED(hr = CoInitialize(NULL))
	{
		try
		{
		
			if (SUCCEEDED(spSQLServer.CreateInstance(__uuidof(SQLServer2))))
			{
				try
				{
					HOST=(_bstr_t)m_MHOST;
				
					if(rad1.GetCheck())
					{
						spSQLServer->LoginSecure = TRUE;
						spSQLServer->Connect((_bstr_t)m_MHOST);
					}
					else
					{
						spSQLServer->LoginSecure = FALSE;
						spSQLServer->Connect((_bstr_t)m_MHOST,(_bstr_t)m_MUSR,(_bstr_t)m_MPWD);
					}
					
				
					
				
				}
				catch(_com_error pCE)
				{
				
					str2.Format(_T("%s"),
					MessageBox(str2,"Message");
					return TRUE;
				}
			}
			else
			{
				str3.Format(_T("Unable to create the SQL Server object.\n"));
		
			}
		}
		catch(_com_error pCE)
		{
			str2.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());
		}

	
	}
	else
	{
		str2.Format(_T("Call to CoInitialize failed.\n"));
	}

Use database command code is here
QueryResultsPtr Qry;
_SQLServer2Ptr spSQLServer;
CString udata="use 'databasename'";
//(databasename is like master ,use create database)
Qry=spSQLServer->ExecuteWithResults((_bstr_t)udata,(LONG)udata.GetLength());

Select command is running fine like this
CString sel="select * from 'Database name'.dbo.'Table Name'"
Qry=spSQLServer->ExecuteWithResults((_bstr_t)sel,(LONG)sel.GetLength());

Can any one help me why
USE 'Database name'
not working.
Plz help me
AnswerRe: Re-Mssql question Pin
Code-o-mat21-Dec-09 21:00
Code-o-mat21-Dec-09 21:00 
GeneralRe: Re-Mssql question Pin
MsmVc21-Dec-09 21:05
MsmVc21-Dec-09 21:05 
GeneralRe: Re-Mssql question Pin
Code-o-mat21-Dec-09 21:13
Code-o-mat21-Dec-09 21:13 
GeneralRe: Re-Mssql question Pin
MsmVc21-Dec-09 21:17
MsmVc21-Dec-09 21:17 
GeneralRe: Re-Mssql question Pin
Code-o-mat21-Dec-09 22:01
Code-o-mat21-Dec-09 22:01 
GeneralRe: Re-Mssql question Pin
MsmVc21-Dec-09 22:04
MsmVc21-Dec-09 22:04 
GeneralRe: Re-Mssql question Pin
Code-o-mat21-Dec-09 22:40
Code-o-mat21-Dec-09 22:40 
AnswerRe: Re-Mssql question Pin
CPallini21-Dec-09 21:53
mveCPallini21-Dec-09 21:53 
GeneralRe: Re-Mssql question Pin
MsmVc21-Dec-09 21:56
MsmVc21-Dec-09 21:56 
QuestionRe: Re-Mssql question Pin
PCuong198321-Dec-09 21:58
professionalPCuong198321-Dec-09 21:58 
AnswerRe: Re-Mssql question Pin
MsmVc21-Dec-09 22:05
MsmVc21-Dec-09 22:05 
GeneralRe: Re-Mssql question Pin
PCuong198321-Dec-09 23:12
professionalPCuong198321-Dec-09 23:12 
GeneralRe: Re-Mssql question Pin
MsmVc21-Dec-09 23:18
MsmVc21-Dec-09 23:18 
GeneralRe: Re-Mssql question Pin
PCuong198322-Dec-09 3:55
professionalPCuong198322-Dec-09 3:55 
Questionneed delete a file in vc++ Pin
kamalilam21-Dec-09 20:04
kamalilam21-Dec-09 20:04 
AnswerRe: need delete a file in vc++ Pin
KingsGambit21-Dec-09 20:11
KingsGambit21-Dec-09 20:11 
AnswerRe: need delete a file in vc++ Pin
Jijo.Raj21-Dec-09 20:49
Jijo.Raj21-Dec-09 20:49 

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.