m_pConnection->Open("Data Source=adotest;UID=sa;PWD=;","","",adModeUnknown);怎么加上DNS的IP？

[fdsgdf]

怎么指定DNS的IP，连到其它的机器的DNS上呢？

[fdsgdf]

www.connectstrings.com无法访问
flyelf(空谷清音)

添加Server为我的IP不能正常连接数据库，即使是指定本机的IP，去掉Server=后可以正常连接

[阿甘]

DNS？？？DSN 吧

[fdsgdf]

对，DSN

[flyelf]

m_pConnection->Open("Data Source=adotest;SERVER=xx;UID=sa;PWD=;","","",adModeUnknown);// xx为ip

[蒋晟]

www.connectstrings.com

[goldAlex]

是不是防火墙的问题?试试关掉?

[ablefirst]

先用管理工具->数据源odbc试一试，如果不行，sql server有问题

[sxslyy]

用:Provider=SQLOLEDB.1;Password=123;Persist Security Info=True;User ID=sa;Initial Catalog=tkmanage;Data Source= 192.168.0.16

InitialCatalog是数据库名
password是数据库密码.
user ID是用户名.
Data Sourece是IP

[fingerfox]

sxslyy(孤松傲雪) 的答案正确

[UDX协议]

CString CMainFrame::GetDns()
{
CString szDNSDomain;
CString szDomainName;
LONG nResult = S_OK;

// Find DNS domain with IP Helper API (function GetNetworkParams)
// CAUTION: this code should run on Windows 2000 and Windows Me only
PFIXED_INFO pNetInfo = (FIXED_INFO *)GlobalAlloc(GPTR, sizeof(FIXED_INFO));
ULONG nNetInfoSize = sizeof(FIXED_INFO);
DWORD nErrorCode = GetNetworkParams(pNetInfo, &nNetInfoSize);
if (nErrorCode == ERROR_BUFFER_OVERFLOW) {
// OK, buffer is too small but function returns the needed size
GlobalFree(pNetInfo);
pNetInfo = NULL;
pNetInfo = (FIXED_INFO *)GlobalAlloc(GPTR, nNetInfoSize);
nErrorCode = GetNetworkParams(pNetInfo, &nNetInfoSize);
}
if (nErrorCode == ERROR_SUCCESS) {

return CString(pNetInfo->DnsServerList.IpAddress.String);
}
return "";


}