VB.NET远程连接SQL 2000
做了一个 C/S 模式的小系统。 本机是VB.NET 做的应用程序,要求连接远程数据库SQL SERVER 2000
要求是本机不安装SQL server ,远程服务器安装 sql server ,如何写连接字符串?
远程服务器的sqlserver需要配置吗 ?
我的连接字符串是用配置文件做的 本地数据库连接成功
连接远程数据库 如何修改这个配置文件 ?????
'读取配置文件的API函数声明
Public Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" _
(ByVal lpApplicationName As String, ByVal lpKeyName As String, ByVal lpDefault As String, _
ByVal lpReturnedString As String, ByVal nSize As Integer, ByVal lpFileName As String) As Int32
'定义配置文件里面的变量并赋值
Public DataSource As String = GetINI("system", "DataSource", "", Application.StartupPath & "\system.ini")
Public InitialCatalog As String = GetINI("system", "InitialCatalog", "", Application.StartupPath & "\system.ini")
Public PersistSecurity As Boolean = True
Public UserID As String = GetINI("system", "UserID", "", Application.StartupPath & "\system.ini")
Public Password As String = GetINI("system", "Password", "", Application.StartupPath & "\system.ini")
Public SQLStr As String = String.Format("Data Source={0};Initial Catalog={1};Persist Security Info={2};User ID={3};Password={4}", _
DataSource, InitialCatalog, PersistSecurity, UserID, Password)
--------------------------------------------------------------------------------------------------------
配置文件
[system]
DataSource="192.168.0.10"
InitialCatalog="test"
PersistSecurity=ture
UserID="sa"
password=""