1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

DAO to ADO

Discussion in 'Programming' started by leaderaa, Jul 28, 2010.

  1. leaderaa

    leaderaa New Member

    Joined:
    Jul 28, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    GM Technical
    Location:
    Karachi,Pakistan
    Home Page:
    Hi all,

    i have a code in which the data is being inserted in MS Access using DAO in VC++. but now since the usage has increased i want to change it and insert the data in SQL Server 08. Can any one help me out on this please, on how to get the data saved in SQL by using either ADO or ODBC from VC++.

    Thanks in advance....

    i am also pasting the current code i have which insert the data in MDB.

    Here is my code:::

    Code:
    daoDB.Open(filename);
    	daoTD.Open("Position");
    	daoRecSet.Open(&daoTD);
    	if (daoRecSet.CanAppend())
    	{
    		daoRecSet.AddNew();
    		daoRecSet.SetFieldValue("UnitID",(LPCTSTR) TransString(UnitID));
    		daoRecSet.SetFieldValue("GPSDateTime",(LPCTSTR) GPSDateTime);
    		daoRecSet.SetFieldValue("RTCDateTime",(LPCTSTR) RTCDateTime);
    		daoRecSet.SetFieldValue("SendDateTime",(LPCTSTR) SendDateTime);
    		daoRecSet.SetFieldValue("Longitude",(LPCTSTR) TransString(PosData.Longitude));
    		daoRecSet.SetFieldValue("Latitude",(LPCTSTR) TransString(PosData.Latitude));
    		daoRecSet.SetFieldValue("Heading",(LPCTSTR) TransString(PosData.Heading));
    		daoRecSet.SetFieldValue("ReportID",(LPCTSTR) TransString(PosData.ReportID));
    		daoRecSet.SetFieldValue("Odometer",(LPCTSTR) TransString(PosData.Odometer));
    		daoRecSet.SetFieldValue("GPSHDOP",(LPCTSTR) TransString(PosData.GPSHDOP));
    		daoRecSet.SetFieldValue("InputsStatus",(LPCTSTR) TransString(PosData.AllInput));
    		daoRecSet.SetFieldValue("VSSSpeed",(LPCTSTR) TransString(PosData.VSSSpeed));
    		daoRecSet.SetFieldValue("OutputsStatus",(LPCTSTR) TransString(PosData.AllOutput));
    		daoRecSet.SetFieldValue("AnalogInput#01",(LPCTSTR) TransString(PosData.AnalogInput[0]));
    		if( strlen((char*)PosData.DriverID) != 0)
    			daoRecSet.SetFieldValue("DriverID",(LPCTSTR) PosData.DriverID);
    		daoRecSet.SetFieldValue("TPSensor#01",(LPCTSTR) TransString(PosData.Temperature[0]));
    		daoRecSet.SetFieldValue("TPSensor#02",(LPCTSTR) TransString(PosData.Temperature[1]));
    		if( strlen((char*)PosData.TextMessage) != 0)
    			daoRecSet.SetFieldValue("TextMessage",(LPCTSTR) PosData.TextMessage);
    
    		daoRecSet.Update();
    	}
    
    }
    
     

Share This Page