AfxOleInit()(); _ConnectionPtr MyDb; MyDb.CreateInstance( __uuidof ( Connection ) ); MyDb->Open( " Provider = SQLOLEDB ; SERVER = server ; DATABASE = config ; UID = sa ; PWD = 612715 " , " " , " " , -1 );
(在StdAfx中以加#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename( "EOF" , "adoEOF" ) no_namespace rename( "BOF" , "adoBOF" )
)
(在StdAfx中以加#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename( "EOF" , "adoEOF" ) no_namespace rename( "BOF" , "adoBOF" )
)
Provider=SQLOLEDB.1;Password=a;Persist Security Info=True;User ID=sa;Initial Catalog=tanyizhiDB;Data Source=192.168.1.23上面的Password后面是密码,User ID是用户名,Catalog是默认打开的数据库,Data Source是数据库服务器的地址。。
第一个参数是连接字符串,第二,第三个是用户名和密码(连接字符串里面填了的话可以为空),第三个是游标方式。。
HRESULT hr;
hr = MyDb.CreateInstance( __uuidof ( Connection ) );
if( FAILED(hr) )
...判断看看这是我自己程序的连接试试看
m_pConnection->Open("Driver={SQL Server};Server=192.168.0.112;DATABASE=Database;UID=;PWD=","","",adModeUnknown);
sParamenter.Format("Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=%s;Jet OLEDB:DataBase Password=%s;Mode=Share Deny Read|Share Deny Write",m_strPath2,m_strOldPass);
hr = m_pConnection->Open(_bstr_t(sParamenter),"","",0);
改成sql2000试试
UID=username;PWD=password","","",adModeUnknown);或m_pConnection->Open("Driver={SQL Server};Server=127.0.0.1;DATABASE=Database",
"username","password",adModeUnknown);