VC,ADO连接远程SQLServer,如何连接?给个串,谢谢
VC,ADO连接远程SQLServer,如何连接?给个串,谢谢 问题点数:20、回复次数:6Top
1 楼joinclear()回复于 2006-03-09 16:43:38 得分 2
连接字符串中的 Data Source 改为IP地址Top
2 楼knot(在路上)回复于 2006-03-11 15:42:34 得分 2
strConnection.Format(_T("driver={SQL Server};Server=%s;UID=%s;PWD=%s;DATABASE=%s"),dbSource,userName,passWord,dbName);Top
3 楼xiangrujian(还不结帖)回复于 2006-05-11 00:21:28 得分 2
UPTop
4 楼wg88888(温柔一刀)回复于 2006-05-11 07:47:10 得分 2
upTop
5 楼kkkgk(skyblue)回复于 2006-05-11 08:58:37 得分 2
_bstr_t strConnect="Provider=SQLOLEDB;driver=SQL Server;Server=192.168.1.18;Database=ChartRadarDB;uid=sa;pwd=;"
this->m_pConnection->Open(strConnect,"","",adModeUnknown);Top
6 楼userlon(wwlover)回复于 2006-05-11 17:23:54 得分 10
pubCon.ConnectionString = "Provider=SQLOLEDB.1;Password=" & Application("passwd") _
& ";Persist Security Info=True;User ID=" & Application("userid") _
& ";Initial Catalog=" & Application("dbase") & ";Data Source=" & Application("server")
Top




