VC中如何编写在局域网访问数据库

Question

m_pConnection->Open("Provider=192.168.1.102 DATA Source=test;UID=;PWD=;","sa","",adModeUnknown);
我是这样写连接的.但是出先错误...提示未安装驱动

Answer 1

Provider后面的是驱动程序，不是服务器……

Answer 2

OLE DB Provider for SQL Server：
strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
        "Initial Catalog=MyDatabaseName;"
        "User Id=MyUsername;Password=MyPassword;");strConnect = _T("Provider=sqloledb;Network Library=DBMSSOCN;"
        "Data Source=130.120.110.001,1433;"
        "Initial Catalog=MyDatabaseName;User ID=MyUsername;"
        "Password=MyPassword;");strConnect = _T("Provider=sqloledb;Data Source=(local);"
        "Initial Catalog=myDatabaseName;"
        "User ID=myUsername;Password=myPassword;");strConnect = _T("Provider=sqloledb;Data Source=MyServerName\MyInstanceName;"
    "Initial Catalog=MyDatabaseName;User Id=MyUsername;Password=MyPassword;");ODBC Driver for SQL Server
strConnection = _T("Driver={SQL Server};Server=MyServerName;"
        "Trusted_Connection=no;"
        "Database=MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;");

Answer 3

局域网中哦.我用的是SQL 2000.系统是XP的.听说要下载补丁.

Answer 4

m_pConnection->Open("Provider=SQLOLEDB.1;Server=192.168.1.6;DATABASE=mysql;UID=sa;PWD=;","","",adModeUnknown);其中Server是SQL服务器的名称，DATABASE是库的名称

Answer 5

m_pConnection->Open("DATA Source=test;UID=;PWD=;","sa","",adModeUnknown);访问就没问题。
m_pConnection->Open("Provider=SQLOLEDB;Server=192.168.1.103;DATABASE=test;UID=sa;PWD=;","","",adModeUnknown); 一直出现错误。我也下了补丁咯请问我的那里错了。