I have seen few time connection string files are saved as .udl file and then it is include in the pages where required.

just wondering is there any advantage of doing this?
What's a difference between saving as .asp file and .udl ????

hi,

.UDL is an easy way to create a connectionstring.
You can try out this by
-> just create a new text file by rightcliking the mouse(if you donot have a new udl in popmenu).
-> rename to a.udl
-> just double click it

See the diference

So changing a connection string is so easy.
another thing you need not search or touch the code to change a connection.

Prashant

thnks Prashant,
But I got a new probs.When I was editing the conection string I open the udl in text mode and there after I am not able to open it in its usual format.
I have tried updating MDAC but couldn't get through.

Any reason why.

Thnks

hi,

If you are in hide known extensions mode.
You must have saved the file x.udl.txt.

You need'nt open in a text editor to edit double click and edit
OR
Right click and view file properties, you can edit.

Prashant




Prashant