高分救助!!!大虾救命啊!! 存储过程没有问题。因为在一台机器上已经通过了。存储过程是dbo的,两台机器上都是用sa访问。对了,此时刚刚才CreateInstance,还没有跟SQL SERVER发生任何关系阿! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 void dump_com_error(_com_error &e) {printf("Error\n");printf("\a\tCode = %08lx\n", e.Error());printf("\a\tCode meaning = %s", e.ErrorMessage());_bstr_t bstrSource(e.Source());_bstr_t bstrDescription(e.Description());printf("\a\tSource = %s\n", (LPCSTR) bstrSource);printf("\a\tDescription = %s\n", (LPCSTR) bstrDescription); }int main(int argc, char* argv[]){ printf("Hello World!\n"); ::CoInitialize(NULL); try { _ConnectionPtr pCon=NULL; _RecordsetPtr pRs=NULL; pCon.CreateInstance(__uuidof(Connection)); pCon->Open("Export","dongsong","dongsong",adConnectUnspecified); pRs.CreateInstance(__uuidof(Recordset)); pRs->CursorLocation=adUseClient; pRs->Open("select name from sysobjects where type='u'", _variant_t((IDispatch *) pCon, true),adOpenStatic, adLockReadOnly, adCmdUnknown); while (!(pRs->EndOfFile)) { printf("%s\n",(char*)_bstr_t(pRs->Fields->Item["name"]->Value)); pRs->MoveNext(); } }catch (_com_error &e) { dump_com_error(e); } ::CoUninitialize(); return 0;} CreateInstance不会抛出异常。只返回错误。 SQL Server 总题 基础问题。如何给新增的列添加相应的值? VC中使用数据库的UpData函数提示未能更新怎么办?哪位帮帮忙 oracle 数据导入 sql sql server安装问题,请大家帮忙! 如何用SQL统计每半小时内某个表的新增记录数? 急:sql语句的问题! 想由sql语句想得到这样的效果! 如何在sql语句的结果中加入序号? 关于VC下使用ADO的问题 请各位大侠帮帮忙,感激不尽! 字符串的长度问题!!!!急!急!!急!!!
void dump_com_error(_com_error &e)
{
printf("Error\n");
printf("\a\tCode = %08lx\n", e.Error());
printf("\a\tCode meaning = %s", e.ErrorMessage());
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
printf("\a\tSource = %s\n", (LPCSTR) bstrSource);
printf("\a\tDescription = %s\n", (LPCSTR) bstrDescription);
}
int main(int argc, char* argv[])
{
printf("Hello World!\n");
::CoInitialize(NULL);
try
{ _ConnectionPtr pCon=NULL;
_RecordsetPtr pRs=NULL;
pCon.CreateInstance(__uuidof(Connection));
pCon->Open("Export","dongsong","dongsong",adConnectUnspecified);
pRs.CreateInstance(__uuidof(Recordset));
pRs->CursorLocation=adUseClient;
pRs->Open("select name from sysobjects where type='u'",
_variant_t((IDispatch *) pCon, true),adOpenStatic, adLockReadOnly, adCmdUnknown);
while (!(pRs->EndOfFile))
{
printf("%s\n",(char*)_bstr_t(pRs->Fields->Item["name"]->Value));
pRs->MoveNext();
}
}catch (_com_error &e)
{
dump_com_error(e);
}
::CoUninitialize();
return 0;
}