AfxOleInit();
m_pConnection.CreateInstance(__uuidof(Connection));
try
{
m_pConnection->Open("Provider=SQLOLEDB;Server=jronald;Database=TelBook;uid=sa;pwd=","","",adConnectUnspecified);
}
catch(_com_error e)
{
CString s;
s.Format("%s\n%s","数据库连接失败",e.ErrorMessage());
AfxMessageBox(s);
}
m_pConnection.CreateInstance(__uuidof(Connection));
try
{
m_pConnection->Open("Provider=SQLOLEDB;Server=jronald;Database=TelBook;uid=sa;pwd=","","",adConnectUnspecified);
}
catch(_com_error e)
{
CString s;
s.Format("%s\n%s","数据库连接失败",e.ErrorMessage());
AfxMessageBox(s);
}
加一句
::CoInitialize(NULL);
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");
用户'sa'登陆失败。原因,未与信任SQL Server连接相关联。安装SQL时,我选的是windows身份验证模式,没有设用户名和密码的
net use \\192.168.3.32 zagl32 /user:administrator上面的192.168.3.32是服务器IP,zagl32是密码,administrator是用户名。。
你试试看配置一下ODBC,我估计sa你都配置不成功
SQL Server联机帮助
注意连接字符串的格式,提供正确的连接字符串是成功连接到数据库服务器的第一步,有关连接字符串的详细信息参见微软MSDN Library光盘。
本例连接字符串中的server_name,database_name,user_name和password在编程时都应该替换成实际的内容。
_ConnectionPtr pMyConnect=NULL;
HRESULT hr=pMyConnect.CreateInstance(__uuidof(Connection)));
if(FAILED(hr))return;_bstr_t strConnect="Provider=SQLOLEDB; Server=server_name;"
"Database=database_name; uid=user_name; pwd=password;";
//connecting to the database server now:
try{pMyConnect->Open(strConnect,"","",NULL);}
catch (_com_error &e)
{
::MessageBox(NULL,e.Description(),"警告",MB_OK | MB_ICONWARNING);
}是这么写的
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;"); For Trusted Connection security: (Microsoft Windows NT integrated security):strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
"Initial Catalog=MyDatabaseName;"
"Integrated Security=SSPI;");
你是用windows验证方式,所以要用第二种连接字符串。。
For Standard Security:oConn.Open "Driver={SQL Server};" & _
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword;"