how to: create an OLE DB Data Link (*.udl) file

[zyrag]

i was trying to work on the sample procedure on the msdn regarding master/detail setup. as i go along with it, i was ask to have the datasource of the ADO control hook up to the udl file. there seems to be no topic pointing to it in the msdn.
How do i create an OLE DB Datalink file, e.g. for the Northwind database?

thanks,

 

[TomKane]

If you have microsoft data link on your pc then you should be able to use the right mouse button to do a new data link and then you can create a data link file. If you have ado then you can create a connection using the adodc control in vb.

I hope this helps...

 

[LazyMe]

Otherwise, just right-click, choose new text file, rename the ".txt" extension to ".udl". Windows will automatically recognize this as the correct file (just double-click it).
Greetings,
Rick