connection string from a text file

[ICW]

Hi I have created a small data access app.
I want to pull the connection string for the SQL database from a text file. But I am getting it a bit wrong can anyone help at all

Dim connStr As String = ""
Dim SqlConnection1 As SqlConnection = New SqlConnection
Dim sr As New StreamReader("C:\Program Files\MDM\ScanViewSetUp\ConnectionString.txt")
connStr = sr.ReadLine()
SqlConnection1 = connStr

 

[ashishnaicker]

have you tried the udl file...

Dim conn As New System.Data.OleDb.OleDbConnection("File Name=C:\conn.udl")

 

[vis781]

ICW, here's a really good site for learning about reading and writing a .txt file hope you find it useful........

http://www.builderau.com.au/program/windows/0,39024644,20267367,00.htm