Question

VB连接SQL 数据库名，IP ，密码都用text1.txt,text2.txt,text2.txt,代替

str = "Provider=SQLOLEDB.1;User ID=sa;password=text1.txt;Initial Catalog=text2.txt;Data Source=text3.txt"
如果这样赋值会出错，如何改才正确

Answer 1

不明白想问什么

追问

例如：str = "Provider=SQLOLEDB.1;User ID=sa;password=text1.txt;Initial Catalog=text2.txt;Data Source=text3.txt"
如果这样赋值会出错，如何改才正确

追答

str = "Provider=SQLOLEDB.1;User ID=sa;password=" &TextBox1.Text & ";Initial Catalog=" & TextBox2.Text & ";Data Source=" & TextBox3.Text

Answer 2

text1.txt???应该是TextBox1.Text吧，改成如下（注意对象属性和字符串的连接）：
str = "Provider=SQLOLEDB.1;User ID=sa;password=" &TextBox1.Text & ";Initial Catalog=" & TextBox2.Text & ";Data Source=" & TextBox3.Text

Answer 3

写法有问题，正确写法：Initial Catalog='" & text2.txt & "'