How to connect using a udl?

[hwalisz]

I need to connect to my database using a udl. I don't want to use the contents of the udl in my code - I just want to refer to the file.

Something like:

Private OledbConnectionString As String = "DataSourceName=C:\SidDev\CodeSource\VBnet\farms\Farms.udl"

Is this possible? If so, is the syntax correct? I realize it's not recommended, but it's the way I've been told to approach it.

By the way, totally new at all this; including object oriented programming.

 

[jmcilhinney]

Google's cool. I just searched for "udl file" (without quotes) and look what was returned on the first page of results. The code is C# but it makes it pretty obvious how to use a UDL file.

http://support.microsoft.com/kb/308426

 

[hwalisz]

That's perfect - thank you!