本来用ADO连ACCESS数据库的时候,一切正常!然后我试着去连一个SQL SERVER数据库文件时,提示“不存在或访问被拒绝!”源程序如下:m_pMyDb->Provider="sqloledb";
sprintf(szConn,"Server=%s;DATABASE=%s;UID=%s;PWD=%s;",SUDA,GameHigh,suda1,""));
m_pMyDb->Open(szConn,"","",adModeUnknown);我的SQL服务器为D58\SUDA,存在E:\wwz\Microsoft SQL Server\MSSQL$SUDA\Data中的数据库名为GameHigh,windows登陆名为suda1,没有密码。不知道是不是我把连接参数搞错了!
sprintf(szConn,"Server=%s;DATABASE=%s;UID=%s;PWD=%s;",SUDA,GameHigh,suda1,""));
m_pMyDb->Open(szConn,"","",adModeUnknown);我的SQL服务器为D58\SUDA,存在E:\wwz\Microsoft SQL Server\MSSQL$SUDA\Data中的数据库名为GameHigh,windows登陆名为suda1,没有密码。不知道是不是我把连接参数搞错了!
"Driver={SQL Server}; Server=127.0.0.1; UID=sa; PWD=sa; Database=data"
这2歌应该都可以的
ODBC SQL SERVER DRIVER 不存在
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");
我试了一下 laker_tmj(laker的方法,提示一样的信息。
我安装SQL的时候用的WINDOWS身份验证。WINDOWS登陆名为suda1没有密码。“Persist Security Info=False”这个东西是在哪设的 ?
這樣試試Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=suda1;Initial Catalog=master;Data Source=MyServerName
--> 设置身份验证为 ‘SQL Server和Windows’用sa登录
Provider=sqloledb;User Id=sa;password=sa密码;data source=D58\SUDA;initial catalog=GameHigh
#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);
_ConnectionPtr cPtr;
cPtr.CreateInstance(__uuidof(Connection)); cPtr->Open(_T("Provider=SQLOLEDB;Data Source=.;Initial Catalog=pubs"),_T("sa"),_T(""),0);
char strsql[50];
CComVariant vRows;
sprintf(strsql,"select * from authors where au_lname='%ls'",bstrname);
cPtr->Execute(strsql,&vRows,adCmdText);
我的sa密码为sa.
语句如下:
m_pMyDb->Provider="sqloledb"
sprintf(szConn,"data source=D58\SUDA;initial catalog=GameHigh
;User Id=sa;password=sa" );
m_pMyDb->Open(szConn,"","",adModeUnknown);还是不可以!
m_pConnection.CreateInstance("ADODB.Connection");
m_pConnection->Open("Provider=SQLOLEDB; Data Source=127.0.0.1;Initial Catalog=GameHigh;User ID=sa;Password='' ","sa","",adConnectUnspecified);我用的是SQLSERVER的用户名(SA)和密码(空)祝福你成功!
strConnect = "Provider=SQLOLEDB.1;Data Source=dongjian; Initial Catalog=Classes; Integrated Security=SSPI;"
如果安装的时候用SQL用户登录,则可以用
strConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=GameHigh;Data Source=127.0.0.1"
strConnect = "Provider=SQLOLEDB.1;Data Source=127.0.0.1; Initial Catalog=GameHigh; Integrated Security=SSPI;"
我已经搞盯了,谢谢各位的帮忙!我添加了Trusted_Connection=yes.
之后就好了!
我再试试各位的方法!