Creating a connection string is always a complicated task - providing credentials, rights & all. But few years ago one of my colleagues told me a quick way to create a connection string & I guess it is the easiest way.
The steps are
1. Create a new file by right clicking on desktop; from context menu select New then select Text File (you can select any file).
2. Rename the extension of this file to "UDL"; in this case it would be from "txt" to "udl".
3. Neglect the rename message and save the file. You can see a new icon.
4. Open this file by double clicking on the icon; you can see the Providers, connection tab. So specify your server, Provider and database name and click "Ok".
5. Now Open this file in text box and you can see the connection string for the database you have selected.
No comments:
Post a Comment