Click here to Skip to main content
16,016,605 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
QuestionRe: C++ and MySQL - Structures Pin
David Crow9-Jul-09 2:59
David Crow9-Jul-09 2:59 
QuestionRe: C++ and MySQL - Structures Pin
CPallini8-Jul-09 20:45
mveCPallini8-Jul-09 20:45 
Questiondevice context vs GDI Pin
Member 5903108-Jul-09 20:23
Member 5903108-Jul-09 20:23 
AnswerRe: device context vs GDI Pin
Sarath C8-Jul-09 20:26
Sarath C8-Jul-09 20:26 
AnswerRe: device context vs GDI Pin
Adam Roderick J8-Jul-09 20:30
Adam Roderick J8-Jul-09 20:30 
Question.ptf file details Pin
Rakesh58-Jul-09 20:13
Rakesh58-Jul-09 20:13 
QuestionRe: .ptf file details Pin
David Crow9-Jul-09 3:01
David Crow9-Jul-09 3:01 
QuestionMysql Select * from Table Pin
Davitor8-Jul-09 19:31
Davitor8-Jul-09 19:31 
Hi All

i am useing _ConnectionPtr and _RecordsetPtr for connection and get information from mysql databases.i have a problem to get values when i am useing "Select * from table".How can i get table information.
_ConnectionPtr pConn = NULL;
    // Define string variables for ADO connection
    _bstr_t strCon("Driver={MySQL ODBC 5.1 Driver};Database="";User=root; Password=root;Option=3;");

    HRESULT hr = S_OK;

    //Initialize the COM Library
    CoInitialize(NULL);

	   hr = pConn.CreateInstance((__uuidof(Connection)));
        if(FAILED(hr))
        {
            AfxMessageBox("Error instantiating Connection object\n");
           
        }


        hr = pConn->Open(strCon,"root","root",0);
        if(FAILED(hr))
        {
            AfxMessageBox("Error Opening Database object using ADO _ConnectionPtr \n");
            
        }
		
		
	
		::_RecordsetPtr rs;

		rs = pConn->Execute(_bstr_t("use Databases"), 0, adCmdText);
		
		 rs = pConn->Execute(_bstr_t("Select * from tatblename"), 0, adCmdText);

Plz help me
AnswerRe: Mysql Select * from Table Pin
Rajesh R Subramanian8-Jul-09 22:12
professionalRajesh R Subramanian8-Jul-09 22:12 
GeneralRe: Mysql Select * from Table Pin
Davitor8-Jul-09 22:24
Davitor8-Jul-09 22:24 
GeneralRe: Mysql Select * from Table Pin
Rajesh R Subramanian8-Jul-09 22:32
professionalRajesh R Subramanian8-Jul-09 22:32 
GeneralRe: Mysql Select * from Table Pin
Davitor8-Jul-09 23:03
Davitor8-Jul-09 23:03 
QuestionRe: Mysql Select * from Table Pin
David Crow9-Jul-09 3:03
David Crow9-Jul-09 3:03 
QuestionCombo Box Pin
Padmanabha_M8-Jul-09 18:51
Padmanabha_M8-Jul-09 18:51 
AnswerRe: Combo Box Pin
Adam Roderick J8-Jul-09 19:07
Adam Roderick J8-Jul-09 19:07 
AnswerRe: Combo Box Pin
«_Superman_»8-Jul-09 19:08
professional«_Superman_»8-Jul-09 19:08 
GeneralRe: Combo Box Pin
Padmanabha_M8-Jul-09 19:39
Padmanabha_M8-Jul-09 19:39 
Questionclipboard Pin
samira forooghi8-Jul-09 18:28
samira forooghi8-Jul-09 18:28 
AnswerRe: clipboard Pin
Adam Roderick J8-Jul-09 19:38
Adam Roderick J8-Jul-09 19:38 
GeneralRe: clipboard Pin
samira forooghi8-Jul-09 21:47
samira forooghi8-Jul-09 21:47 
QuestionStartProcess/Inject DLL or Detours Pin
Daedro8-Jul-09 12:16
Daedro8-Jul-09 12:16 
AnswerRe: StartProcess/Inject DLL or Detours Pin
Baltoro8-Jul-09 14:25
Baltoro8-Jul-09 14:25 
AnswerRe: StartProcess/Inject DLL or Detours Pin
Adam Roderick J8-Jul-09 18:59
Adam Roderick J8-Jul-09 18:59 
QuestionHow to retrieve Public IP Address Pin
gamefreak22918-Jul-09 8:53
gamefreak22918-Jul-09 8:53 
QuestionRe: How to retrieve Public IP Address Pin
David Crow9-Jul-09 4:12
David Crow9-Jul-09 4: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.