可不可以通过打开一个数据库文件来访问sql server内一个数据库？

[chengyuny]

我是数据库新手，请大家指点

[masterz]

#include "stdafx.h"
#import "H:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF", "EndOfFile")

int main(int argc, char* argv[])
{

/*
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim rs2 As ADODB.Recordset

Private Sub Command1_Click()

Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Set rs2 = New ADODB.Recordset

' Open a single Connection object to SQL Server
With cn
.Provider = "SQLOLEDB"
.ConnectionString = "Data Source=sql_server_name;User ID=sa;Password=;"
'The first connection to SQL Server is opened
.Open
.DefaultDatabase = "Pubs"
End With


*/

CoInitialize(NULL);
try
{
_ConnectionPtr pConn("ADODB.Connection");
_RecordsetPtr pRst("ADODB.Recordset");

pConn->Open("Provider=sqloledb;Data Source=Server1;"
"Initial Catalog=test1;User Id=sa;Password=sa;",
"", "", adConnectUnspecified);
// Note 1.
pRst->Open(
"userinfo",
_variant_t((IDispatch *) pConn, true),
adOpenStatic,
adLockReadOnly,
adCmdTable);
pRst->MoveLast();
// Note 2.
printf("Last name is '%s %s'\n",
(char*) ((_bstr_t) pRst->GetFields()->GetItem("username")->GetValue()),
(char*) ((_bstr_t) pRst->Fields->Item["otherinfo"]->Value));

pRst->Close();
pConn->Close();
}
catch (_com_error &e)
{
printf("Description = '%s'\n", (char*) e.Description());
}
::CoUninitialize();

return 0;
}

[harry202]

楼上的，这样打开的是odbc数据源呀。