如何用vc+ado动态创建sql server数据库,请高手指教

2006-03-31 10:29:58 204 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Java后台生成二维码，前端页面调用二维码三部曲，这三个就可以直接生成二维码了到页面了工具类public class QuickMarkUtil { /** 37 * 生成包含字符串信息的二维码图片 38 * @param outputStream 文件输出流路径 39 * @param content 二维码携带信息 40 * @param qrCodeSiz... 阅读详情

以下是我写的代码，但是不行，请各位高手指教

//create a Connection
_ConnectionPtr pConnection;
pConnection.CreateInstance(__uuidof(Connection));
//crate a Command
_CommandPtr pCommand;
pCommand.CreateInstance(__uuidof(Command));
//create a connection string
CString sql="Provider=SQLOLEDB.1;Password=123;"
"Persist Security Info=True; User ID=sa;"
"Initial Catalog=Northwind; Data Source=LFP82\\LFP";

try
{
pConnection->Open(_bstr_t(sql),"","",adModeUnknown);
_variant_t vNULL;
vNULL.vt = VT_ERROR;
vNULL.scode = DISP_E_PARAMNOTFOUND;//define non_para
CString strcratedatabase = "crate database robin";
pCommand->ActiveConnection = pConnection;
pCommand->CommandText = _bstr_t(strcratedatabase);
pCommand->Execute(&vNULL,&vNULL,adCmdText);
pConnection->Close();
}
catch (_com_error* e)
{
AfxMessageBox(e->ErrorMessage());
}
catch(...)
{
//AfxMessageBox("")
}

...全文