Question

用ADO连接ACCESS数据库

在头文件 StdAfx.h 中加入：
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
然后我新建了ado.cpp和ado.h文件
ado.h

#pragma once

class CAdo
{

public:
CString recordset[15][3];
BOOL getSelectSet(CString sql,int,int);
CAdo(void);
~CAdo(void);
_ConnectionPtr m_connPtr;
_RecordsetPtr m_recPtr;
BOOL isExsit(_bstr_t sql);
_ConnectionPtr openConnect();

BOOL ExecuteSQL(CString sql);
char sql_server[50];
char sql_uid[50];
char sql_pwd[50];
CString cstrconn;
_bstr_t strconn;

};

ado.cpp

#include "StdAfx.h"
#include "Ado.h"
#define ROWNUM 10
#define CLONUM 3
struct strrecordset
{
int rowsnum;
int clsonum;
CString recordset[ROWNUM][CLONUM];

};

CAdo::CAdo(void)
{
}

CAdo::~CAdo(void)
{
}

int main()
{
try
{

_ConnectionPtr m_pConnection;
CoInitialize(NULL);
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open("Provider=Microsoft.ACE.OLEDB.4.0;Data Source=db1.mdb;Persist Security Info=False;","","",adModeUnknown);
}
catch(_com_error e)
{
AfxMessageBox("连接数据失败，请检查数据库路径是否正确！");
}
}

可是不能连接数据库啊，怎么改，我完全是新手

Answer 1

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%''第一种字符串连接数据库方法
set conn=Server.CreateObject("ADODB.Connection")
on error resume next
conn.open "DRIVER=Driver do Microsoft Access (*.mdb);UID=;PWD=;DBQ="&Server.MapPath("../dat/a.mdb")
If Err.Number<>0 Then
response.write "数据库连接错误！"
response.end
End If
%>

<%''''''''第二种字符串连接数据库方法来自BBSXP'''''''''''''''
'''On Error Resume Next
'''Set Conn=Server.CreateObject("ADODB.Connection")
'''Conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("../dat/a.mdb")
'''If Err Then
'''err.Clear
'''Set Conn = Nothing
'''Response.Write ""&IsSqlVer&"数据库连接出错，请检查连接字串。"
'''Response.End
'''End If
%>

Answer 2

bool dbOperate::connectDatabase(string strPathName)
{
try
{
m_pConnection.CreateInstance(__uuidof(Connection));
CString strsql = _T("");
strsql.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=%s",strPathName.c_str());
m_pConnection->Open(_bstr_t(strsql),"","",adModeUnknown);
return true;
}
catch(_com_error e)
{
AfxMessageBox("数据库连接失败");
return false;
}
}
我封装过后的连接函数 没有问题的