VC连接SQL Server 2000的问题!谢谢指点一下。

[laiyongjun]

在连接SQL Server 2000时出现了一个问题，今天用了我半天都没解决的问题。

我用ADOConn.cpp来连接数据库的各个表，如下：

// 初始化—连接数据库
void ADOConn::OnInitADOConn()
{
// 初始化OLE/COM库环境
::CoInitialize(NULL);

try
{
// 创建Connection对象
m_pConnection.CreateInstance("ADODB.Connection");
// 设置连接字符串，必须是BSTR型或者_bstr_t类型
_bstr_t strConnect = "Provider=SQLOLEDB; Server=A007;Database=Assets; uid=sa; pwd=;";
m_pConnection->Open(strConnect,"","",adModeUnknown);
}
// 捕捉异常
catch(_com_error e)
{
// 显示错误信息
AfxMessageBox("OnInitADOConn "+e.Description());
}
}

可在初始化（执行m_pConnection->Open）时，总要出异常：
“用户'sa'登录失败，原因：未与信任SQL Server连接相关联。”

我找了半天也没找出大原因，我的#import "..\msado15.dll" 已经在ADOConn.h里面了，请指点一下。

[laiyongjun]

#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF") rename("BOF","adoBOF")

已经在ADOConn.h了，可就是要出：“用户'sa'登录失败，原因：未与信任SQL Server连接相关联。”这样的错。

[laiyongjun]

我费了大半天功夫，原来应该为SQL登陆，不应为Windows登陆。

[imacih]

MSDN上的例子

ADO 2.7 Samples

See Also
Connection Object | DefaultDatabase Property | Provider Property

© 1998-2001 Microsoft Corporation. All rights reserved.
Provider and DefaultDatabase Properties Example (VC++)
This example demonstrates the Provider property by opening three Connection objects using different providers. It also uses the DefaultDatabase property to set the default database for the Microsoft ODBC Provider.

// BeginProviderCpp
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
no_namespace rename("EOF", "EndOfFile")

#include <ole2.h>
#include <stdio.h>
#include <conio.h>

// Function declarations
inline void TESTHR(HRESULT x) {if FAILED(x) _com_issue_error(x);};
void ProviderX(void);
void PrintProviderError(_ConnectionPtr pConnection);
void PrintComError(_com_error &e);

///////////////////////////////
// //
// Main Function //
// //
///////////////////////////////
void main()
{
if(FAILED(::CoInitialize(NULL)))
return;

ProviderX();

::CoUninitialize();
}

/////////////////////////////////
// //
// ProviderX Function //
// //
/////////////////////////////////

void ProviderX(void)
{
HRESULT hr = S_OK;

// Define ADO object pointers.
// Initialize pointers on define.
// These are in the ADODB:: namespace.
_ConnectionPtr pConnection1 = NULL;
_ConnectionPtr pConnection2 = NULL;
_ConnectionPtr pConnection3 = NULL;

try
{
// Open a Connection using the Microsoft ODBC provider.
TESTHR(pConnection1.CreateInstance(__uuidof(Connection)));
pConnection1->ConnectionString = "driver={SQL Server};"
"server=srv;uid=sa;pwd=;";
pConnection1->Open("","","",adConnectUnspecified);
pConnection1->DefaultDatabase = "pubs";

// Display the provider
printf("\n\nConnection1 provider: %s \n\n",
(LPCSTR)pConnection1->Provider);

// Open a connection using the OLE DB Provider for Microsoft Jet.
TESTHR(pConnection2.CreateInstance(__uuidof(Connection)));
pConnection2->Provider = "Microsoft.Jet.OLEDB.3.51";

char *sConn = "c:\\Program Files\\Microsoft Office\\Office\\"
"Samples\\Northwind.mdb";

pConnection2->Open(sConn,"admin","",NULL);

// Display the provider
printf("Connection2 provider: %s \n\n",(LPCSTR)pConnection2->
Provider);

// Open a Connection using the Microsoft SQL Server provider.
TESTHR(pConnection3.CreateInstance(__uuidof(Connection)));
pConnection3->Provider = "sqloledb";
pConnection3->Open("Data Source=MyServer;Initial Catalog=pubs;",
"sa","",NULL);

// Display the provider.
printf("Connection3 provider: %s\n\n",(LPCSTR)pConnection3->
Provider);

pConnection1->Close();
pConnection2->Close();
pConnection3->Close();
}

catch (_com_error &e)
{
// Notify the user of errors if any.
PrintProviderError(pConnection1);
if(pConnection2) PrintProviderError(pConnection2);
if(pConnection3) PrintProviderError(pConnection3);
PrintComError(e);
}
}

///////////////////////////////////////////////////////////
// //
// PrintProviderError Function //
// //
///////////////////////////////////////////////////////////
void PrintProviderError(_ConnectionPtr pConnection)
{
// Print Provider Errors from Connection object.
// pErr is a record object in the Connection's Error collection.
ErrorPtr pErr = NULL;

if( (pConnection->Errors->Count) > 0)
{
long nCount = pConnection->Errors->Count;

// Collection ranges from 0 to nCount -1.
for(long i = 0;i < nCount;i++)
{
pErr = pConnection->Errors->GetItem(i);
printf("Error number: %x\t%s\n", pErr->Number,
(LPCSTR) pErr->Description);
}
}
}

///////////////////////////////////////////////////////////
// //
// PrintComError Function //
// //
///////////////////////////////////////////////////////////
void PrintComError(_com_error &e)
{
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());

// Print COM errors.
printf("Error\n");
printf("\tCode = %08lx\n", e.Error());
printf("\tCode meaning = %s\n", e.ErrorMessage());
printf("\tSource = %s\n", (LPCSTR) bstrSource);
printf("\tDescription = %s\n", (LPCSTR) bstrDescription);
}
// EndProviderCpp

See Also
Connection Object | DefaultDatabase Property | Provider Property

© 1998-2001 Microsoft Corporation. All rights reserved.

[oyljerry]

直接用m_pConnection来建立数据库的连接

[gooyan]

1.stdafx.h中加入
#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")
2。app文件的InitInstance中加入
if(S_OK!=OleInitialize(NULL))
{
AfxMessageBox("初始化COM组件库错误");
}


下面就是数据库操作
_ConnectionPtr pConn;
_RecordsetPtr pRs;
CString strSQL;
pConn.CreateInstance(__uuidof(Connection));
pConn->CursorLocation=adUseClient;
strSQL="Provider=SQLOLEDB;Server=Gooyan;DataBase=SkillsBox;UID=sa;PWD=aaaaaaaa";
pConn->Open(_bstr_t(strSQL),"","",-1);

pRs.CreateInstance(__uuidof(Recordset));
pRs->CursorLocation=adUseClient;
pRs->PutActiveConnection(pConn.GetInterfacePtr());

pRs1.CreateInstance(__uuidof(Recordset));
pRs1->CursorLocation=adUseClient;
pRs1->PutActiveConnection(pConn.GetInterfacePtr());

strSQL="select * from catalog order by cataid";
pRs->Open(_bstr_t(strSQL),vtMissing,adOpenDynamic,adLockBatchOptimistic,adCmdText);

[moneyandwoman]

Windows登陆就是你登陆系统的名字密码,一般要用混合验证模式

[Kudeet]

Windows登陆就是你登陆系统的名字密码,一般要用混合验证模式

[DragonBill]

用m_pConnection来建立数据库的连接

[zhangwenjin]

"Provider=SQLOLEDB; Server=A007;Database=Assets; uid=sa; pwd=;";
一般要在sql server中建立一个登陆用户，采用混合验证模式访问数据库。