HRESULT hr=pApp->m_pRecordset->Open(sql.AllocSysString(),pApp->m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText);
if(!SUCCEEDED(hr))
{
AfxMessageBox("´³ö´í");
return false;
}
& ......
ÎÒдµÄ³ÌÐòÊÇasp+accessÊý¾Ý¿âµÄ
ÒÔǰÔÚWindows server 2000¡¢Windows server 2003ϲ¿Êð¶¼Ã»ÓÐÎÊÌâ
ÏÖÔÚÐèÒª²¿Êðµ½Windows server 2008ϵͳÏÂ
¿ªÊ¼µÄʱºò³öÏÖÁËһЩÎÊÌâ
ÕâЩÎÊÌâ»ù±¾ÉÏÓÃWindows7ϵIJ¿ÊðµÄ·½·¨¾Í¿ÉÒÔ½â¾ö
µ«ÊÇ×îºó·¢ÏÖ»¹ÊDz»ÐÐ
ÎÊÌâÊdzöÏÖÔÚodbcÊý¾ÝÔ´Çý¶¯ÉÏÁË
ÎÒ´ò¿ªodbcÊý¾ÝÔ´Çý¶ ......
ÎÒдµÄ³ÌÐòÊÇasp+accessÊý¾Ý¿âµÄ
ÒÔǰÔÚWindows server 2000¡¢Windows server 2003ϲ¿Êð¶¼Ã»ÓÐÎÊÌâ
ÏÖÔÚÐèÒª²¿Êðµ½Windows server 2008ϵͳÏÂ
¿ªÊ¼µÄʱºò³öÏÖÁËһЩÎÊÌâ
ÕâЩÎÊÌâ»ù±¾ÉÏÓÃWindows7ϵIJ¿ÊðµÄ·½·¨¾Í¿ÉÒÔ½â¾ö
µ«ÊÇ×îºó·¢ÏÖ»¹ÊDz»ÐÐ
ÎÊÌâÊdzöÏÖÔÚodbcÊý¾ÝÔ´Çý¶¯ÉÏÁË
ÎÒ´ò¿ªodbcÊý ......
ÎÒÔÚÇ°Ì¨Ò³ÃæÊäÈë¿òÊäÈë 20091208 µã»÷Ìá½»Ö®ºó±¨´í,˵ÀàÐͲ»Æ¥Åä.
Êý¾Ý¿âÀï Õâ¸ö×ֶεĸñʽӦ¸ÃÊÇ 2009-12-8 14:27:40
ÊDz»ÊÇÒª°Ñ 20091208 ת»»³É¸ñʽ 2009-12-8 14:27:40
ÇëÎÊÎÒÄܲ»ÄÜÊäÈë20091208 ¾ÍĬÈÏת»»³É 2009-12-8 10:00:00
ÊäÈë20091209¾ÍĬÈÏת»»³É 2009-12-9 10:00:00
......
ÔÚvc6Öд´½¨.mdbÎļþ£¬´ò¿ªÎļþºóÏÔʾΪaccess 95Îļþ¸ñʽ£¬ÎÒ×°µÄofficeΪ2003µÄ£¬´´½¨.mdbµÄ·½·¨Îª£º
CString lpDbStruct = _T("CREATE TABLE Êý¾Ý (".....")");
pDao->Execute(LPCTSTR(lpDbStruct));
pTable=new CDaoTableDef(pDao);
pTable->Open("Êý¾Ý");
p ......
1¡¢sqlstr = "select distinct(²¿ÃÅ) from result where not isnull(²¿ÃÅ)"
rs2.Open sqlstr, Cnn, 1, 1
2¡¢sqlstr = "select ÏîÄ¿Áбí from passel where ¿ªÊ¼ÈÕÆÚ between #" & DTPicker1.value & "# and #" & DTPicker2.value & ......