请大家帮帮忙，一个ADO连接的问题

Question

我在stdafx.h中添加了：#import "C:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "adoEOF")然后在AppDlg.cpp的InitInstance()中使用连接：
try
{

pConnection1->ConnectionString="Provider=SQLOLEDB.1
                            ;Persist Security Info=False;
                       User ID=sa;Initial Catalog=ADOtest;Data Source=CXL"
pConnection1->ConnectionTimeout=5;
pConnection1->Open("","","",adConnectUnspecified);
}
可是连语法编译都通不过，是不是我还少加了什么东西呢？根使用ADO连接数据库（sql server）一共有那些前期步骤？请告诉我，谢谢大家啊！

Answer 1

pConnection1->ConnectionString="Provider=SQLOLEDB.1"
                            ";Persist Security Info=False;"
                       "User ID=sa;Initial Catalog=ADOtest;Data Source=CXL";
pConnection1->ConnectionTimeout=5;
pConnection1->Open("","","",adConnectUnspecified);

Answer 2

// 初始化COM、OLE,创建ADO连接等操作
AfxOleInit(); m_pConnection.CreateInstance(__uuidof(Connection));
/******************连接数据库********************/
try
{
//连接 SQL SERVER 2000
/*CString strConnection = "Provider=SQLOLEDB.1;Data Source=" +m_servername+ 
";Initial Catalog=" +m_initDb+
";User ID=" +m_connectuser+ "; Password=" + m_connectpwd;
*/
//连接 IBM DB2 数据库
CString strConnection = "Provider=IBMDADB2.1;Password="+m_connectpwd+
";User ID="+m_connectuser+";Data Source="+m_servername+";Persist Security Info=TRUE";       
m_pConnection->ConnectionTimeout = 10;
m_pConnection->CursorLocation=adUseClient;
m_pConnection->Open((_bstr_t)strConnection,"","",adModeUnknown);
}
catch(_com_error e)///捕捉异常
{
CCommon common;
AfxMessageBox(common.DisplayAdoError(theApp.m_pConnection));
AfxMessageBox("数据库连接失败!");
firstrun=true;
AfxMessageBox("请检查与数据库服务器是否连接正常，或者程序启动后进入\n数据源设置界面重新设置数据库连接参数！");
//return FALSE;
}

Answer 3

m_pConnection->Open("driver={SQL Server};Server=127.0.0.1;DATABASE=vckbase;UID=sa;PWD=139","","",adModeUnknown);
其中Server是SQL服务器的名称，DATABASE是库的名称