>Sergey & Cetin,
>
>Thanks for your quick reply to my posting. It looks like UDL files are what I am looking for.
>
>I am surprised that there is not a control panel item for creating UDL files. Seems to me that the method suggested by MS is kind of cludgy: "right click in Windows Explorer...Select New...Text file. Then rename it to
.UDL, and then double click on that file." I'm supposed to instruct my customers to do that??
>
>That leads to a follow-up question: How to organize UDL files. With ODBC, Microosft had a strategy to store those data source links in a common place in the registry. Do you know if MS has any strategy for organizing UDL files? Like a standard Data Sources folder? OR registry entry?
>
>Thanks again for your help.
>
>Jim
Jim,
It's a plain ASCII files that you could create programmatically. ie: One udl content:[oledb]
Provider=VFPOLEDB;Data Source=C:\Program Files\Microsoft Visual FoxPro 9\Samples\Data\testdata.dbc;
Before I vaguely remember there was a place where right click showed "New Datalink file" but where? (probably it was Program Files\Common Files\System\Ole Db or Datalink. Now there is "My DataSources" under 'My Documents'. Might be a good place.)
Cetin