Sounds familiar? Well, today I've got a magic connectionstring tool and wait, before you click away after interpreting tool as virus-infected, advertisement overdoses, only half functioning shareware... I should probably add that you don't have to install anything, because this is something hiding in your very pc!
Curious yet?
You should be!
I only recently discovered this when a colleague showed me this. I was stunned by the fact that I never knew this and when I thought about it, I never read about this online or heard anybody mention it... . So, without further ado, I bring to you: the built-into-Windows-connectionstring-tool!
How does it work:
- Right-click in a random folder or on your desktop and create a new "Text Document".
- Change the extension of the file to .udl, you'll notice that Windows will recognize the extension as a "Microsoft Data Link"-file and will add a custom icon.
- Double-click the file to open the how-to-build-a-connectionstring-magic-interface.
The interface has four tabs: Provider, Connection, Advanced and All. Below you can find an image of each of these tabs. The name of the tab gives away which settings can be found there, but I'll sum them up for you anyway.
Provider: here you should select the type of provider for your datalink.
Connection: here you can browser a database server for databases.
Provider: here you should select the type of provider for your datalink.
Connection: here you can browser a database server for databases.
All: all what's left can be found here, you can set properties for the type of data here.
Right when you think you are now stuck with an entirely useful file, you should open this file in a text editor to witness the magic:
Your very own ready-to-use connectionstring!
Note: I have noticed that sometimes (in .NET-applications) you have to leave out the Provider-part.
Note: I have noticed that sometimes (in .NET-applications) you have to leave out the Provider-part.
So from know on you can go around and connect strings all over, have fun!
Could be useful, right?
definitely useful!! keep going buddy
ReplyDeleteThank you :) I will!
Delete