tag:blogger.com,1999:blog-11049085.comments2023-10-19T22:31:11.386+03:00Alex PinskerAlex Pinskerhttp://www.blogger.com/profile/01712994496088023843noreply@blogger.comBlogger199125tag:blogger.com,1999:blog-11049085.post-75968679301600439712023-10-19T05:10:32.809+03:002023-10-19T05:10:32.809+03:00thanks. Still worked in 2023.thanks. Still worked in 2023.Hidahttps://www.blogger.com/profile/12368561267247731545noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-82338521526993187262023-08-31T18:12:35.834+03:002023-08-31T18:12:35.834+03:00thanks from 2023thanks from 2023Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-8839872323798022522023-02-01T09:28:39.658+02:002023-02-01T09:28:39.658+02:00Given that in both KeyValues and Values you have t...Given that in both KeyValues and Values you have the value available, would be good to include the retrieval of the value on the key iteration.Leohttps://www.blogger.com/profile/07927180543470653304noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-53669486574499313272023-02-01T09:28:32.932+02:002023-02-01T09:28:32.932+02:00Given that in both KeyValues and Values you have t...Given that in both KeyValues and Values you have the value available, would be good to include the retrieval of the value on the key iteration.Leohttps://www.blogger.com/profile/07927180543470653304noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-46242470296500760722023-02-01T09:28:28.788+02:002023-02-01T09:28:28.788+02:00Given that in both KeyValues and Values you have t...Given that in both KeyValues and Values you have the value available, would be good to include the retrieval of the value on the key iteration.Leohttps://www.blogger.com/profile/07927180543470653304noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-59789461674390253862023-02-01T09:28:19.279+02:002023-02-01T09:28:19.279+02:00Given that in both KeyValues and Values you have t...Given that in both KeyValues and Values you have the value available, would be good to include the retrieval of the value on the key iteration.Leohttps://www.blogger.com/profile/07927180543470653304noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-86042242071170087662022-05-19T17:42:49.336+03:002022-05-19T17:42:49.336+03:00Thank you this was most helpfulThank you this was most helpfulSeth Wegnerhttps://www.blogger.com/profile/16018895575400212575noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-57156690172038830502022-05-19T17:42:14.409+03:002022-05-19T17:42:14.409+03:00Thank you, this was most helpfulThank you, this was most helpfulSeth Wegnerhttps://www.blogger.com/profile/16018895575400212575noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-78900379677487932962020-04-17T17:38:30.372+03:002020-04-17T17:38:30.372+03:00Maybe overkill... (.NET Flavor) - but I do get th...Maybe overkill... (.NET Flavor) - but I do get the tokens back with named captures so I can work with specific keys or values. That being said, parsing ConnectionStrings with the DbConnectionStringBuilder class is way easier. Do note that for that class, if a token repeats, apparently only the last one is kept - so User ID =x ; User ID =y will store User Id=y (at least, this is the case for Oracle)<br /><br /><br />[ ]*(?(?(?![ ])(?:[A-Za-z0-9\x20\x5f-[\x3b\x3d]]*)*(?(?![ ])=(?(?![ ])[^=;]*(?(?![ ]);(?<![ ]))(?<![ ]))<br /><br />for<br /><br />Data Source = <Host>:<Port> / <SID>; Persist Security Info = True; Statement Cache Size = 200; User ID=<SomebodyReal>; Password = <TheirRealPassword>;proxy user id = <AppUser>;proxy password =<AppUserPwd>;<br /><br />Gives back:<br /> <br />Data Source = <Host>:<Port> / <SID>;<br />Persist Security Info = True;<br />Statement Cache Size = 200;<br />User ID=<SomebodyReal>;<br />Password = <TheirPassword>;<br />proxy user id = <AppUser>;<br />proxy password = <AppUserPwd>;Allenhttps://www.blogger.com/profile/08514303019861748168noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-19367774779627098602019-12-27T23:15:16.953+02:002019-12-27T23:15:16.953+02:00No me funcionóNo me funcionóDiegohttps://www.blogger.com/profile/14011347849477613489noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-26258000064528825402019-09-17T00:24:05.410+03:002019-09-17T00:24:05.410+03:00With the deprecation of SQL Native Client how woul...With the deprecation of SQL Native Client how would we do this now?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-58204196105692968392018-06-12T12:45:38.975+03:002018-06-12T12:45:38.975+03:00/****** Object: LinkedServer [DB_ALIASNAME] Sc.../****** Object: LinkedServer [DB_ALIASNAME] Script Date: 12-06-2018 11:03:38 ******/<br />EXEC master.dbo.sp_addlinkedserver @server = N'DB_ALIASNAME', @srvproduct=N'sql_server', @provider=N'SQLNCLI11', @datasrc=N'DB_ACTUALNAME'<br /> /* For security reasons the linked server remote logins password is changed with ######## */<br />EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'DB_ALIASNAME',@useself=N'False',@locallogin=NULL,@rmtuser=N'USERNAME',@rmtpassword='########'Anonymoushttps://www.blogger.com/profile/17141996114881078806noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-81969030494200067362017-08-04T11:48:26.780+03:002017-08-04T11:48:26.780+03:00Thanks a lot!Thanks a lot!Peternoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-68532088537153078722017-04-12T12:43:27.788+03:002017-04-12T12:43:27.788+03:00The ode is broken and cannot be trusted. It return...The ode is broken and cannot be trusted. It returns 4 for bool and 1 for char. Neither of those are correct, if you inspect in-memory representations in a debugger. A better way to measure it would be to create an array of it and measure the distance between pointers to elements.Ghttps://www.blogger.com/profile/04678396523967046572noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-63853925972362817562017-01-30T21:08:45.531+02:002017-01-30T21:08:45.531+02:00Can't seem to get it to work?Can't seem to get it to work?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-82120801582758417592016-09-12T13:59:31.367+03:002016-09-12T13:59:31.367+03:00For connecting to SQL2008R2 ,
This Provider &quo...<br />For connecting to SQL2008R2 , <br />This Provider "SQL Server Native Client 11.0" wouldnt work. <br /><br />I had to use the Provider "SQL Server Native Client 10.0"<br /><br /><br />Thanks Works Great now. <br /> <br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-33146390583532865122016-03-31T15:55:12.925+03:002016-03-31T15:55:12.925+03:00You are welcome mate. I've semi-abandoned this...You are welcome mate. I've semi-abandoned this blog, but it's a great pleasure to still hear Thank You years after..Alex Pinskerhttps://www.blogger.com/profile/01712994496088023843noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-65643621111685310762016-03-31T14:57:14.604+03:002016-03-31T14:57:14.604+03:00This fixed my same issue in .Net 4.5
11 years late...This fixed my same issue in .Net 4.5<br />11 years later after your original post, thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-19605831232446139022016-03-05T16:27:17.379+02:002016-03-05T16:27:17.379+02:00Thanks a ton Alex!! I want to know what's the ...Thanks a ton Alex!! I want to know what's the magic behind sql_server! Also, I want to know if this method will make any difference in performance? Aman S. Anejahttps://www.blogger.com/profile/10930714154941802437noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-55883957579053525522016-01-08T17:56:45.853+02:002016-01-08T17:56:45.853+02:00This still works for Sql Server 2012, thanks a bun...This still works for Sql Server 2012, thanks a bunch!MikeTnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-66938959746912317552015-10-27T11:22:16.022+02:002015-10-27T11:22:16.022+02:00Thank you so much. It saved me. I wanted to run a ...Thank you so much. It saved me. I wanted to run a distributed transaction and needed to explicitly address the remote server name placing special charactors like "." and "," . Thanks a lot. :-)<br />Babakhttps://www.blogger.com/profile/05374817936079186665noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-46117658280795306652015-10-13T11:14:37.950+03:002015-10-13T11:14:37.950+03:00WORKS!!!WORKS!!!YanivBDhttps://www.blogger.com/profile/10032752748058164416noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-34602840891499650452015-10-13T11:14:25.087+03:002015-10-13T11:14:25.087+03:00WORKS!!!UR THE BESTTTTTTTWORKS!!!UR THE BESTTTTTTTYanivBDhttps://www.blogger.com/profile/10032752748058164416noreply@blogger.comtag:blogger.com,1999:blog-11049085.post-58070688271542187892015-03-12T21:50:53.871+02:002015-03-12T21:50:53.871+02:00Thanks very much, very useful for prod moves!!!!!!...Thanks very much, very useful for prod moves!!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11049085.post-86558012671917053862015-02-26T22:18:47.369+02:002015-02-26T22:18:47.369+02:00That works great! Thanks a lot.That works great! Thanks a lot.Anonymousnoreply@blogger.com