关于ADO编程的小问题～ 急啊！都3天了还没解决，高手们救我

[develoer]

bstr_t m_strFileDSN = L"";
m_strFileDSN = L"DSN=data;UID=sa;PWD=;";
HRESULT hr;
hr = ::CoCreateInstance(__uuidof(Connection), NULL, CLSCTX_SERVER,__uuidof(_Connection), (LPVOID*)&m_pADOConnection);
if( m_pADOConnection )
hr = m_pADOConnection->Open(m_strFileDSN, (BSTR)NULL,(BSTR)NULL, -1);

// 以上是通过ODBC访问SQL Server中的表资源代码。
// 我想不通过ODBC直接访问SQL Server中的表资源怎么做？
// 我是用的msado15.dll 请大侠们帮我啊！
m_pConnection->Open("driver={SQLServer};
Server=127.0.0.1;DATABASE=vckbase;UID=sa;PWD=139","","",adModeUnknown);

[ufox]

在头文件中包含如下语句：其中C：指的是系统盘。
#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \no_namespace rename("EOF", "adoEOF")

int CCommManager::InitDBConn()
{
//在其他地方已经定义了的：_ConnectionPtr pDBConn

time_t tCurrent;
time(&tCurrent);
if((m_tAdoConn != 0) && (tCurrent-m_tAdoConn < MIN_ADO_CONN_PERIOD))
return 0;

time(&m_tAdoConn);
::CoInitialize( NULL );

HRESULT hr = 0;

// 与数据库建立ADO连接
try
{
// 初始化数据库实例句柄
hr = pDBConn.CreateInstance( __uuidof( Connection ) );
if ( !SUCCEEDED( hr ) )
{
TRACE( "\ntServerDll Error: CreateInstance failed..." );
return 0;
}

// 连接数据库串
CString strConnect;
strConnect.Format( "Provider=SQLOLEDB;Data Source=%s;Initial CataLog=%s;"
"User ID=%s; Password=%s",m_config.strDBServer,
m_config.strDBName, m_config.strUserID,
m_config.strPassword );

// 连接数据库
hr = pDBConn->Open( _bstr_t( strConnect ), L"", L"", adModeUnknown );
if ( !SUCCEEDED( hr ) )
{
TRACE("\n%s:%dConnect Database failed but no exception",__FILE__,__LINE__);
return 0;
}
}
catch ( _com_error &e )
{
TRACE("\n异常！%x: %s; %s:%d",
e.Error(),(LPCTSTR)e.Description(),__FILE__,__LINE__);

m_bDBConnOK = FALSE;
return 0;
}
catch ( ... )
{
g_logObj.writeLog(LOG_ERR, "tServer.DLL-- 异常！ 不明异常; %s:%d",__FILE__,__LINE__);
m_bDBConnOK = FALSE;
return 0;
}

TRACE("\n%s:%d建立数据库连接成功",__FILE__,__LINE__);
m_bDBConnOK = TRUE;

return pDBConn;
}


使用：
CString strSQL = "INSERT (...) VALUES(...)";
m_pDBConn->Execute(_bstr_t(strSQL),NULL,adCmdText);

[叶子哟]

http://www.vckbase.com/document/viewdoc.asp?id=668
http://www.vckbase.com/document/viewdoc.asp?id=669

[叶子哟]

http://www.vckbase.com/document/viewdoc.asp?id=719

[flyever]

up

[叶子哟]

http://www.vckbase.com/document/viewdoc.asp?id=556