_ConnectionPtr 问题

[xscansou]

class CAdoDB
{
public:
CAdoDB();
virtual ~CAdoDB();
public:
//数据库连接
_ConnectionPtr GetConnection(){return m_pConn;};
BOOL Open(LPCTSTR lpszConnect=_T(""),long lOptions=adConnectUnspecified);
.....
}
提示如下错误,是怎么回事呢?
error C2146: syntax error : missing ';' before identifier 'GetConnection'

[依然做自己的软件]

好像是找不到_ConnectionPtr的声明，看看你的头文件部分

[xscansou]

C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(690) : error C2227: left of '->QueryInterface' must point to class/struct/union
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(75) : see reference to function template instantiation 'long __thiscall _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID _GUID_00000556_0000_0010_8000_00aa006d2ea4> >
::_QueryInterface(const bool &)' being compiled
===============================================
原来是没有找那个那dll文件,但现在又出现上面的错误了,

[xscansou]

.h
_RecordsetPtr Execute(LPCTSTR strSQL,long lOptions=adCmdText);
.cpp
_RecordsetPtr CAdoDB::Execute(LPCTSTR strSQL,long lOptions)///这里不能通过
{
_variant_t RecordsAffected;
try
{
return m_pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
return false;
}

[xscansou]

急..........

[一条晚起的虫]

在stdafx.h中
#import "C:\\Program Files\\Common Files\\System\\ado\\msado15.dll" no_namespace rename("EOF","adoEOF")

[一条晚起的虫]

_RecordsetPtr CAdoDB::Execute(LPCTSTR strSQL,long lOptions)///这里不能通过
----
什么错误？

[xscansou]

_RecordsetPtr CAdoDB::Execute(LPCTSTR strSQL)
{
return false;
}
现在我什么都没加还是同样的错误..是不是RecordsetPtr ??

如下错误
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(690) : error C2227: left of '->QueryInterface' must point to class/struct/union
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(75) : see reference to function template instantiation 'long __thiscall _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID _GUID_00000556_0000_0010_8000_00aa006d2ea4> >
::_QueryInterface(const bool &)' being compiled

[xscansou]

_RecordsetPtr CAdoDB::Execute(LPCTSTR strSQL);
{
return false;
}
///////////////////////////////////////////////////////////
error C2447: missing function header (old-style formal list?)

[xscansou]

.h
============================================
#ifndef ADO_DB_H
#define ADO_DB_H
#import "msado15.dll" no_namespace rename("EOF","adoEOF")
#include <vector>
//利用vector 数组结构构造一维字符串数组
typedef ::std::vector<CString> CStrs;
//利用vector数据结构构造二给字符串数组
typedef ::std::vector<CStrs> CDStrs;
class CAdoDB
{
public:
CAdoDB();
virtual ~CAdoDB();
public:
//数据库连接
_ConnectionPtr GetConnection(){return m_pConn;};//返回数据库连接指针

BOOL Open(LPCTSTR lpszConnect=_T(""),long lOptions=adConnectUnspecified);
void Close();
BOOL IsOpen();
_RecordsetPtr GetRecordset(){return m_pRs;};//返回记录集指针
CString GetConString() {return m_strConn;};//返回连接字符串
//执行SQL语句
_RecordsetPtr Execute(LPCTSTR strSQL);
CString vartostr(_variant_t&var);//_variant_t数据格式的数据转换为字符串格式化
//根据SQL语句查询数据库,获取的记录集保存在二维字符串数据中
void ExecuteQuery(LPCTSTR lpszSQL,CDStrs& Fields);
//根据SQL语句查询数据库,获取一个字段值值
void ExecuteQueryValue(LPCTSTR lpszSQL,CString& value);
protected:
CString m_strConn;//连接字符串
_ConnectionPtr m_pConn;//数据库连接指针
_RecordsetPtr m_pRs;//记录集指针
};
#endif
======================================================
.cpp
======================================================
#include "stdafx.h"
#include "ADODB.h"
CAdoDB::CAdoDB()
{
::CoInitialize(NULL);//调用CoInitialize初始化COM环境
}
CAdoDB::~CAdoDB()
{
::CoUninitialize();//释放COM对象
}
BOOL CAdoDB::IsOpen()
{
try
{
return (m_pConn!=NULL&&(m_pConn->State&adStateOpen));
}
catch(_com_error e)//处理异常
{
AfxMessageBox(e.ErrorMessage());
}
return false;
}

_RecordsetPtr CAdoDB::Execute(LPCTSTR strSQL,long lOptions)
{
_variant_t RecordsAffected;

try
{
return m_pConn->Execute(_bstr_t(strSQL),&RecordsAffected,adCmdText);
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}

return false;
}

BOOL CAdoDB::Open(LPCTSTR lpszConnect,long lOptions)
{
m_pConn.CreateInstance("ADODB.Connection");//创建Connection对象
//初始化Recordset指针
m_pRs.CreateInstance(_uuidof(Recordset));
m_strConn=lpszConnect;
if(m_strConn.IsEmpty())
{
return false;
}
if(IsOpen()) Close();
try
{
//连接数据库
return (m_pConn->Open(_bstr_t(m_strConn),"","",lOptions)==S_OK);
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
return false;
}
void CAdoDB::Close()
{
try
{
if(m_pConn!=NULL&&IsOpen())
{
m_pConn->Close();
}
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
}
void CAdoDB::ExecuteQueryValue(LPCTSTR lpszSQL,CString &value)
{
try
{
m_pRs->Open(_bstr_t(lpszSQL),(IDispatch*)m_pConn,adOpenDynamic,adLockOptimistic,adCmdText);
if(!m_pRs->adoEOF)
{
_variant_t thevalue=m_pRs->GetCollect(_variant_t((short)0));//获取字段值
value=vartostr(thevalue);
}
m_pRs->Close();
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
}
void CAdoDB::ExecuteQuery(LPCTSTR lpszSQL,CDStrs& Fields)
{
try
{
//打开记录订
m_pRs->Open(_bstr_t(lpszSQL),(IDispatch*)m_pConn,adOpenDynamic,adLockOptimistic,adCmdText);
while(!m_pRs->adoEOF)
{
CStrs strs;
_variant_t thevalue;
//获取一条记录中的所有字段值保存到字符串数组strs中
int size=m_pRs->Fields->Count;
for(long index=0;index<m_pRs->Fields->Count;index++)
{
thevalue=m_pRs->GetCollect(_variant_t(index));
CString temp=vartostr(thevalue);
strs.push_back(temp);
}
Fields.push_back(strs);//保存一条记录到二维字符数组中
m_pRs->MoveNext();
}
m_pRs->Close();
}
catch(_com_error e)
{
AfxMessageBox(e.ErrorMessage());
}
}
CString CAdoDB::vartostr(_variant_t &var)
{
CString strValue;
switch(var.vt)
{
//字符串
case VT_BSTR:
case VT_LPSTR:
case VT_LPWSTR:
strValue=(LPCTSTR)(_bstr_t)var;
}
return strValue;
}
====================================
调试结果:
====================================
--------------------Configuration: YoYoSoftware - Win32 Release--------------------
Compiling...
ADODB.cpp
f:\ssss\release\msado15.tlh(407) : warning C4146: unary minus operator applied to unsigned type, result still unsigned
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\vector(48) : warning C4786: '??0?$vector@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@V?$allocator@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@@2@@std@@QAE@IABV?$vector@VCStr
ing@@V?$allocator@VCString@@@std@@@1@ABV?$allocator@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@@1@@Z' : identifier was truncated to '255' characters in the browser information
F:\ssss\ADODB.cpp(111) : see reference to class template instantiation 'std::vector<class std::vector<class CString,class std::allocator<class CString> >,class std::allocator<class std::vector<class CString,class std::allocator<
class CString> > > >' being compiled
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\vector(61) : warning C4786: '??0?$vector@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@V?$allocator@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@@2@@std@@QAE@PBV?$vector@VCStri
ng@@V?$allocator@VCString@@@std@@@1@0ABV?$allocator@V?$vector@VCString@@V?$allocator@VCString@@@std@@@std@@@1@@Z' : identifier was truncated to '255' characters in the browser information
F:\ssss\ADODB.cpp(111) : see reference to class template instantiation 'std::vector<class std::vector<class CString,class std::allocator<class CString> >,class std::allocator<class std::vector<class CString,class std::allocator<
class CString> > > >' being compiled
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(690) : error C2227: left of '->QueryInterface' must point to class/struct/union
C:\Program Files\Microsoft Visual Studio\VC98\INCLUDE\comip.h(75) : see reference to function template instantiation 'long __thiscall _com_ptr_t<class _com_IIID<struct _Recordset,&struct __s_GUID _GUID_00000556_0000_0010_8000_00aa006d2ea4> >
::_QueryInterface(const bool &)' being compiled
Error executing cl.exe.
Creating browse info file...

YoYoSoftware.exe - 1 error(s), 3 warning(s)

===============================================
高手帮我看一下呀..我已经把msado15.dllcopy到目录下了