无法建立数据库的连接,服务器名从文本里读出

来源：百度知道 编辑：UC知道 时间：2024/06/20 02:59:15
Public sr As StreamReader = New StreamReader("ServerName.txt")
Public txt As String = RTrim(sr.ReadLine())
Public my_connec As New OleDb.OleDbConnection("Provider=SQLOLEDB;User ID=sa;Password=;database=gas_meter;
server='"&txt&"'")
这样是怎么读也读不出来,建立不了数据库的连接,这是为什么,但我换了下就可以了
Public sr As StreamReader = New StreamReader("ServerName.txt")
Public txt As String = RTrim(sr.ReadLine())
Public constr As String = "User ID=sa;Password=;database=gas_meter;server='" & txt & "'"
为什么多个OleDb.OleDbConnection就不可以,有没有办法解决
Dim strConnetion As String ="User ID=sa;Password=;database=gas_meter;server='" & txt & "'"
Dim strODConnection As New OleDb.OleDbConnection(strConnettion)
strODConnection.Open();

试过了，不行,我在想是不是哪里格式不对

Dim strConnetion As String ="User ID=sa;Password=;database=gas_meter;server='" & txt & "'"
Dim strODConnection As New OleDb.OleDbConnection(strConnettion)
strODConnection.Open();

抵制VB,抵制OLEDB!
再见

database换data source

你不如这样,设置一下断点,看到那一行到底发生了什么事情.