// SqlConn.cpp : 定义控制台应用程序的入口点。
//
#include "stdafx.h"
#include
#include
using namespace std;
int _tmain(int argc, _TCHAR* argv[])
{
::CoInitialize(NULL);
_ConnectionPtr m_con=NULL;
if(FAILED(m_con.CreateInstance("ADODB.Connection"))){
cout<<"connection is failed"<<endl;< p="">
return 0;
}
cout<State<<endl;< p="">
_RecordsetPtr m_Rset;
m_Rset.CreateInstance("ADODB.Recordset");
_bstr_t strCon="Provider=SQLOLEDB.1;Data Source=PC--LI;Integrated Security=SSPI;Initial Catalog=student;";
//Connect to the database server now
try{m_con->Open(strCon,"","",adModeUnknown);
cout<State<<endl;< p="">
}
catch(_com_error &e){
cout<<"can not open the database"<<endl;< p="">
::MessageBox(NULL,e.Description(),"Warning",MB_OK|MB_ICONWARNING);
}
_bstr_t sql="CREATE TABLE T(ContId int PRIMARY KEY,LeaseName varchar(50) NOT NULL, LeasePhon varchar(50) NOT NULL,LessorDele varchar(50) NOT NULL,)";
m_con->Execute(sql,NULL,NULL); ///execute successfully
cout<State<<endl;< p="">
/*_RecordsetPtr m_Rset;
m_Rset.CreateInstance("ADODB.Recordset");*/
cout<State<<endl;< p="">
if (m_Rset->State)
m_Rset->Close();
if (m_Rset==NULL)
return 0;