7 ms·
Connection Strings Reference
- abofh 5y agoUnpleasantly ad-laden. Good value in the site, but it literally blocked content trying to sell me stuff I wouldn't buy from a company I don't trust.
- FpUser 5y agoI guess Brave browser does the job. I see no ads
- bdcravens 5y agoNone here on Chrome+adblocker. I turned off the ad blocking just to see how bad it was - 1 on the home page, 2 on connection string pages. Pretty tame all things considered.
- darkcha0s 5y agoI disabled ad block to see what you were on about. There is one little slide up banner at the bottom that you can close. If you don't have an adblock (mine disabled that), how is this ad-laden to you?
- audiodude 5y agoThis looks like just a spammy SEO grab.
- bdcravens 5y agoI don't think so. It has a lot of useful information, and back in the day I used this site (or one similarly named) a ton.
- LeoPanthera 5y agoI thought this was going to be about the Hayes Command Set. AT&F0 ATDT5551212
- nivertech 5y agoWhat about connection URIs?
- pacifika 5y agoIs this the same site as from the classic ASP days? Wow flashback to 2005.
- BrentOzar 5y agoIt is! Flashbacks. And it still does a better job than most database vendor sites, gets straight to the point.
- gravypod 5y agoI wish there was a library for "every" that took a standardized connection string and mapped it to "every" DB/storage/queue/etc client. This is one of those things that should be a solved problem that we as an industry should just move past having to deal with. This would obviously be too much effort to actually do but it would save a lot of headache. "We can't X because we cant pass it's config to the software"
- laurent92 5y agoOr “we had to restart 7 times because I thought I knew the syntax, but it didn’t seem taken into account, so I changed it 6 more times and actually the second time was correct but needed a second parameter.”
- jolux 5y ago> I wish there was a library for "every" that took a standardized connection string and mapped it to "every" DB/storage/queue/etc client. This has been around for like 30 years, it's called ODBC. As long as you're using an ODBC driver the strings are the same (modulo the driver specification).
- zo1 5y agoIntuitively you would think so, but unfortunately not. The ODBC specification last time I looked into it doesn't dictate the key-values that is given to the database driver so it's up to each driver to pick it's own. E.g. HOSTNAME vs SERVER, or PASSWORD vs PWD are the two main differences I recall. I'm not super well-versed in it, so I'm sure someone else here can provide more detail as to why it's different or if there is history behind it being like this. But from a dev's perspective, ODBC connection strings are an absolute mess. Not to mention no one really knows what's what, hence this website. Fun fact, I tried to find the spec as part of responding here and I couldn't find it. Best I could find was this: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/driver-manager-s-role-in-the-connection-process?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/odbc/reference/develop-... But you go around finding actual details and next thing you know it's under the heading of "SQL Server XXXX" so you have no idea if it's the "spec" or just the MS SQL Server driver reference.
- sweisman 5y agoThis site has saved my bacon more than once.
- beermonster 5y agoPrefer the integrated security ones unless you’re also going to read a secure storage reference to protect the secrets.
- qwerty456127 5y agoIMHO the connection strings are exactly a thing that should have been standardized, in form of a URL preferably. I have invented my own URL forms and implemented code parsing them and providing connections quite a number of times in many languages.
- eatonphil 5y agoSurprised to see Excel in there and I'm unfamiliar with the .NET libraries mentioned. Are they for querying Excel as SQL?