一个问题我刚刚学OLEDB不懂,老想不出来头痛~~~~~~~~啊!请各位老大帮忙解答谢谢!
/////////////连接语句: HRESULT hr;
CDBPropSet dbinit(DBPROPSET_DBINIT);
dbinit.AddProperty(DBPROP_AUTH_INTEGRATED, "SSPI");
dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
dbinit.AddProperty(DBPROP_INIT_CATALOG, "Employees");
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, "JACKIE"); hr = m_Connect.Open("SQLOLEDB.1", &dbinit);
if (FAILED(hr)) return; hr = m_Session.Open(m_Connect);
if (FAILED(hr)) return;
////////////////////////////////
CString strSQLString;
strSQLString = _T("Select 部门ID, 部门名称 from 部门");
CCommand<CManualAccessor> rs;
struct MYBIND* pBind = NULL;
UINT nColumns=2;
pBind = new MYBIND[nColumns];
TRY{
rs.CreateAccessor(nColumns, pBind, sizeof(MYBIND));
for (ULONG l=0; l<nColumns; l++)
rs.AddBindEntry(l+1, DBTYPE_STR, sizeof(TCHAR)*40, &pBind[l].szValue,
NULL, &pBind[l].dwStatus);
到这个地方就出现错误信息
---------------->>>>>>>if (rs.Open(m_Session, strSQLString) != S_OK)
AfxThrowOLEDBException(rs.m_spCommand, IID_ICommand); CATCH(.......///////错误信息:
Expression:session.m_spOpenRowset != 0for information on how your program can cause an assertion
failure,see the Visual C++ documentation on asserts
////////////////
最后还想请问怎样加*.mdb到SQL中?针对这个例子!例子程序来自《Visual C++ 6.0 数据库高级编程》。还有就是我SQL SERVER都不懂,还要很深入的学习它吗?还是只要会用就行?那么给我推荐一本书好吗?谢谢各位老大!
/////////////连接语句: HRESULT hr;
CDBPropSet dbinit(DBPROPSET_DBINIT);
dbinit.AddProperty(DBPROP_AUTH_INTEGRATED, "SSPI");
dbinit.AddProperty(DBPROP_AUTH_PERSIST_SENSITIVE_AUTHINFO, false);
dbinit.AddProperty(DBPROP_INIT_CATALOG, "Employees");
dbinit.AddProperty(DBPROP_INIT_DATASOURCE, "JACKIE"); hr = m_Connect.Open("SQLOLEDB.1", &dbinit);
if (FAILED(hr)) return; hr = m_Session.Open(m_Connect);
if (FAILED(hr)) return;
////////////////////////////////
CString strSQLString;
strSQLString = _T("Select 部门ID, 部门名称 from 部门");
CCommand<CManualAccessor> rs;
struct MYBIND* pBind = NULL;
UINT nColumns=2;
pBind = new MYBIND[nColumns];
TRY{
rs.CreateAccessor(nColumns, pBind, sizeof(MYBIND));
for (ULONG l=0; l<nColumns; l++)
rs.AddBindEntry(l+1, DBTYPE_STR, sizeof(TCHAR)*40, &pBind[l].szValue,
NULL, &pBind[l].dwStatus);
到这个地方就出现错误信息
---------------->>>>>>>if (rs.Open(m_Session, strSQLString) != S_OK)
AfxThrowOLEDBException(rs.m_spCommand, IID_ICommand); CATCH(.......///////错误信息:
Expression:session.m_spOpenRowset != 0for information on how your program can cause an assertion
failure,see the Visual C++ documentation on asserts
////////////////
最后还想请问怎样加*.mdb到SQL中?针对这个例子!例子程序来自《Visual C++ 6.0 数据库高级编程》。还有就是我SQL SERVER都不懂,还要很深入的学习它吗?还是只要会用就行?那么给我推荐一本书好吗?谢谢各位老大!
http://www.vccode.com/file_show.php?id=203
http://dev.csdn.net/develop/article/3/3901.shtm
OLE DB摸板库与OLE DB SDK哪个更实用在企业级应用中?
谢谢先!^_^