UDL File Connection 1

[dolfo35]

Hi,

Can someone please tell me what I am missing here:

Dim conn2 As New SqlConnection
conn2.ConnectionString = "File Name=c:\tempdb.udl;"

conn2.Open()

Every place I've read about using a UDL file to connect to SQL Server has said to use "File Name=path\filename.udl". However , I keep getting an error that says "Keyword not supported: 'file name'.

Your help is greatly appreciated.
Rudy

 

[jebenson]

Using a .udl file for a connection string works with OleDbConnection, not SqlConnection. Try this:

Dim conn2 As New OleDbConnection
conn2.ConnectionString = "File Name=c:\tempdb.udl;"

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson