m_pConnection->Open(strConnect,"","",adModeUnknown);出错！

[consuvi]

#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")
#include <iostream>
#include <iomanip> //for setw()
using namespace std;

int main()
{
	::CoInitialize(NULL); 
	_RecordsetPtr m_pRecordset("ADODB.Recordset");
	_ConnectionPtr m_pConnection("ADODB.Connection");

	try
	{
		m_pConnection.CreateInstance("ADODB.Connection");
		// 设置连接字符串，必须是BSTR型或者_bstr_t类型
		_bstr_t strConnect= "Provider=SQLOLEDB;Server=(local);Database=grid;uid=sa;pwd=ksh;";
		//_bstr_t strConnect = "Provider=SQLNCLI10;Password=ksh;Persist Security Info=True;User ID=sa;Initial Catalog=grid;Data Source=(local);";
		
		//m_pConnection->Open("driver={SQL Server};Server=127.0.0.1;DATABASE=grid;UID=sa;PWD=ksh","","",adModeUnknown);
		//m_pConnection->Open("driver={SQL Server};User ID=sa;Password=ksh;Server=(local);DATABASE=grid","","",adModeUnknown);
		m_pConnection->Open(strConnect,"","",adModeUnknown);
}
catch(_com_error e)
	{
		cerr << "\nERROR:" << (char*)e.Description();//抛出异常
	}

注释掉的哪几种连接都试过了，还是连不上
右边是我的数据库
是连接字符串不对还是什么？都搞一天了还没搞定

[蒋晟]

_com_error里面错误信息是？

[yaorugang]

HRESULT hr = m_pConnection.CreateInstance("ADODB.Connection"); 看一下hr成功否 另外是否初始化ole?

[consuvi]

hr = 0;

[consuvi]

open函数总是失败

[consuvi]

引用 1 楼 jiangsheng 的回复:

_com_error里面错误信息是？

[嘿了个咻]

[consuvi]

		_bstr_t strConnect = "Provider=SQLOLEDB;Password=ksh;Persist Security Info=True;User ID=sa;Initial Catalog=ksh;Data Source=PC\\SQLEXPRESS;Extended Properties=\"Server=127.0.0.1,1433;Database=grid;uid=sa;pwd=ksh\"";

果然是连接字符串格式写错了，改成这样就可以了

[MrWayne111]

引用 7 楼 a502961969 的回复:

		_bstr_t strConnect = "Provider=SQLOLEDB;Password=ksh;Persist Security Info=True;User ID=sa;Initial Catalog=ksh;Data Source=PC\\SQLEXPRESS;Extended Properties=\"Server=127.0.0.1,1433;Database=grid;uid=sa;pwd=ksh\"";

果然是连接字符串格式写错了，改成这样就可以了

请问楼主各个熟悉分别是什么意思，为什么Initial Catalog=ksh 而Database=grid 小弟也是这个问题，被困扰了好久了，谢谢