求助,一个VB.NET编写的C/S结构的软件,如何实现局域网中多台电脑访问主机电脑的SQL2005数据库?
Module Module1
Public strBH As String = Nothing
Public strXM As String = Nothing
Public strMM As String = Nothing
Public strQX As String = Nothing
'Public ConnectionString As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=作业提交与批改系统;Data Source=烟波天客-PC\SQL2005"
End Module
上面是我连接数据库的代码,在本机上就可以执行,如果改成这样就不行了 Public ConnectionString As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=作业提交与批改系统;Data Source=192.168.1.102"
该怎么办?
我的这个软件最终是要打包成安装包,在局域网中多台电脑安装,且主机安装SQL2005数据库和软件,其他客户机只安装软件,不安装SQL数据库,该如何实现这一功能,请各位大神帮帮忙。