try
{
_bstr_t bstr=(_bstr_t)_T("Provider=SQLOLEDB.1;Password=weblogic;Persist Security Info=True;User ID=sa;Initial Catalog=RestoreTest;Data Source=ly");
m_pConn.CreateInstance(__uuidof(Connection));
m_pConn->Open(bstr,"","",NULL);bstr=(_bstr_t)"backup database report to disk='e:\\back.dat'";
_variant_t RecordsAffected;
m_pConn->Execute((_bstr_t)bstr,&RecordsAffected,adCmdText);}
catch(_com_error& e)
{
MessageBox(e.ErrorMessage());
return;
}
{
_bstr_t bstr=(_bstr_t)_T("Provider=SQLOLEDB.1;Password=weblogic;Persist Security Info=True;User ID=sa;Initial Catalog=RestoreTest;Data Source=ly");
m_pConn.CreateInstance(__uuidof(Connection));
m_pConn->Open(bstr,"","",NULL);bstr=(_bstr_t)"backup database report to disk='e:\\back.dat'";
_variant_t RecordsAffected;
m_pConn->Execute((_bstr_t)bstr,&RecordsAffected,adCmdText);}
catch(_com_error& e)
{
MessageBox(e.ErrorMessage());
return;
}
解决方案 »
- IOCTL_DISK_GET_DRIVE_LAYOUT调用在Vista中成功,XP中失败
- IE自定义右键菜单(超急)
- 初学者如何能够尽快使用VC++
- 关于时间表示的问题
- 扩展动态链接库的父类是否必须是CObject??不能是我定义的类
- CRecordset中Open函数的执行时间?(急需解决)
- ListCtrl只显示了标题,下面的内容怎么也显示不出来,已经摸索了三天了,请指教!还有...
- 删除某个表中的前1000条记录的SQL语句怎么写?
- 请推荐几本Visual C++的入门好书(我是指VC++这个工具,不是指C++语言)
- 如何向魔兽客户端的密码框中发送数据?
- 请教高手一个有难度的网络开发问题!
- 如何让三个可执行文件依次执行
把SQL语句在SQL SERVER的查询器上运行看有没有问题
我的程序:
ADODB::_ConnectionPtr Conn1;
_bstr_t bstrConnect( L"driver={sql server};server=small_xp;Database=hsdb;UID=hs;PWD=hs;" );
_bstr_t bstrEmpty;
_bstr_t bstr;
Conn1.CreateInstance( __uuidof( ADODB::Connection ) );
Conn1->ConnectionString = bstrConnect;
Conn1->Open( bstrConnect, bstrEmpty, bstrEmpty, -1 );
bstr=(_bstr_t)"backup database hsdb to disk='e:\\back.dat'";
_variant_t RecordsAffected;
Conn1->Execute((_bstr_t)bstr,&RecordsAffected,1);