Dave's Technophorical Times

A blog about Microsoft's Technologies!
SharePoint :: MVC :: ASP.NET :: IIS :: SQL Server :: Visual Studio :: MS Access

From here: https://blogs.technet.microsoft.com/enterprisemobility/2009/07/01/using-multiple-monitors-in-remote-desktop-session/   

If your RDP's "Use all my monitors for the remote session" is disabled you can get around it as follows.

1. Create an RDP file with your specific connection.
2. Right click on the .rdp file and select Open with Notepad.
3. Add the following 2 lines to the bottom.

span monitors:i:1
use multimon:i:1

4. Save and then use!

Have a great day!



From here: http://superuser.com/questions/803943/how-to-disable-javascript-debugging-in-ie11

The options in VS for exceptions to determine if the debugger should break on an exception. Though VS will always break on an unhandled exception and a language break (debugger). The options do not stop the script debugger from being attached when you launch IE from VS.

The options in VS to enable or disable JIT debugging change just the just-in-time debug feature. Enabling JIT debug simply means that if a running application not launched by VS hits a break condition the user should be prompted if they want to attach VS to debug the application. This also don't change if script debugging is enabled when you launch IE from VS.

The options in Internet Explorer to disable script debugging only changes if IE should run with debugging enabled always. In IE11 with VS2013 this feature is never needed but is there to support older versions of VS.

The easiest way to get the behavior you want is to do:
1. Right click on a aspx/html file there is a ‘Browse with…’ item. This will bring up a dialog to configure your browser.

2. Click the Add button. Add something like:
    Path: c:\Program Files (x86)\Internet Explorer\iexplore.exe
    Friendly name: Internet Explorer (no debug)

3. Set that as your default

This basically launches IE outsie Visual Studio so that those annoying Javascript errors stop happening. You will still be able to debug your code though.



Jan
04

ASCII Codes for SSRS

by Dave Stuart | Tags:
Special Chars Upper Case Lower Case Extended ASCII
9 \t (Tab) 65 A 97 a 128 €
10 \n (NL) 66 B 98 b 129  
13 \r (CR) 67 C 99 c 130 ‚
32 Space 68 D 100 d 131 ƒ ƒ
33 ! 69 E 101 e 132 „
34 " 70 F 102 f 133 …
35 # 71 G 103 g 134 †
36 $ 72 H 104 h 135 ‡
37 % 73 I 105 i 136 ˆ ˆ
38 & 74 J 106 j 137 ‰
39 ' 75 K 107 k 138 Š Š
40 ( 76 L 108 l 139 ‹
41 ) 77 M 109 m 140 Œ Œ
42 * 78 N 110 n 141  
43 + 79 O 111 o 142 Ž Ž
44 , 80 P 112 p 143  
45 - 81 Q 113 q 144  
46 . 82 R 114 r 145 ‘
47 / 83 S 115 s 146 ’
48 0 84 T 116 t 147 “
49 1 85 U 117 u 148 ”
50 2 86 V 118 v 149 •
51 3 87 W 119 w 150 –
52 4 88 X 120 x 151 —
53 5 89 Y 121 y 152 ˜ ˜
54 6 90 Z 122 z 153 ™
55 7 154 š š
56 8 155 ›
57 9 156 œ œ
58 : 157  
59 ; 158 ž ž
60 < 159 Ÿ &#159;
61 = 160   &#160;
62 > 161 ¡ &#161;
63 ? 162 ¢ &#162;
64 @ 163 £ &#163;
91 [ 164 ¤ &#164;
92 \ 165 ¥ &#165;
93 ] 166 ¦ &#166;
94 ^ 167 § &#167;
95 _ 168 ¨ &#168;
96 ` 169 © &#169;
123 { 170 ª &#170;
124 | 171 « &#171;
125 } 172 ¬ &#172;
126 ~ 173 ­ &#173;
174 ® &#174;
175 ¯ &#175;
176 ° &#176;
177 ± &#177;
178 ² &#178;
179 ³ &#179;
180 ´ &#180;
181 µ &#181;
182 &#182;
183 · &#183;
184 ¸ &#184;
185 ¹ &#185;
186 º &#186;
187 » &#187;
188 ¼ &#188;
189 ½ &#189;
190 ¾ &#190;
191 ¿ &#191;
192 À &#192;
193 Á &#193;
194 Â &#194;
195 Ã &#195;
196 Ä &#196;
197 Å &#197;
198 Æ &#198;
199 Ç &#199;
200 È &#200;
201 É &#201;
202 Ê &#202;
203 Ë &#203;
204 Ì &#204;
205 Í &#205;
206 Î &#206;
207 Ï &#207;
208 Ð &#208;
209 Ñ &#209;
210 Ò &#210;
211 Ó &#211;
212 Ô &#212;
213 Õ &#213;
214 Ö &#214;
215 × &#215;
216 Ø &#216;
217 Ù &#217;
218 Ú &#218;
219 Û &#219;
220 Ü &#220;
221 Ý &#221;
222 Þ &#222;
223 ß &#223;
224 à &#224;
225 á &#225;
226 â &#226;
227 ã &#227;
228 ä &#228;
229 å &#229;
230 æ &#230;
231 ç &#231;
232 è &#232;
233 é &#233;
234 ê &#234;
235 ë &#235;
236 ì &#236;
237 í &#237;
238 î &#238;
239 ï &#239;
240 ð &#240;
241 ñ &#241;
242 ò &#242;
243 ó &#243;
244 ô &#244;
245 õ &#245;
246 ö &#246;
247 ÷ &#247;
248 ø &#248;
249 ù &#249;
250 ú &#250;
251 û &#251;
252 ü &#252;
253 ý &#253;


<style type="text/css">
    tr:nth-child(odd) { background-color: #ecf1f2;  padding: 4px;}
    tr:nth-child(even) { background-color: #fff;  padding: 4px;}
    table { border-collapse: collapse; border-spacing: 0; }
</style>



BEST HTML Colours Site! http://htmlcolorcodes.com/



From: https://msdn.microsoft.com/en-us/library/dd207045.aspx

  1. On the design surface, click the row or column handle of the tablix data region to select it. The Grouping pane displays the row and column groups.

  2. On the right side of the Grouping pane, click the down arrow, and then click Advanced Mode. The Row Groups pane displays the hierarchical static and dynamic members for the row groups hierarchy and the Column groups pane shows a similar display for the column groups hierarchy.

  3. Click the static member that corresponds to the static member (row or column) that you want to remain visible while scrolling. The Properties pane displays the Tablix Member properties.

    If you don’t see the Properties pane, click the View tab at the top of the Report Builder window and then click Properties.

  4. In the Properties pane, set RepeatOnNewPage to True.

  5. Set KeepWithGroup to After.

  6. Repeat this for as many adjacent members as you want to repeat.

  7. Preview the report.



Recently I had to link to 4 SQL Azure tables that are in a Access Web App and found a way to always connect even though MS Access does not save the UserName/Password in the connection string.

The SQL Azure connection string is as follows, however note that when you view the connection string in desgin mode you will not see the UID/PWD part.

ODBC;Driver={SQL Server Native Client 11.0}; Server=[Server Name].database.windows.net; Database=[Database Name];
Uid=[Database Name]_ExternalWriter; Pwd=[Password]; Encrypt=Yes

So in order to get around this issue, create a Passthrough Query to one of the Linked SQL Azure tables and save the Uid/Pwd with the connection string. Make it some thing like SELECT TOP 1 * From Access.[Table Name]. Save the query as something like qptSQLAzureStartUp. Then Add this to the StartUp form's OnOpen Event: Dim lngCount As Long and the next line as lngCount=DCount("*", "qptSQLAzureStartUp"). Then you'll find that your Linked SQL Azure tables will open.



Check this link too. This works for MVC 5 too: http://stackoverflow.com/questions/12433736/asp-net-mvc-4-allow-dashes-hypens-in-urls

Dashed urls are much more SEO friendly and easier to read. (More on my blog post)

NuGet Package: https://www.nuget.org/packages/LowercaseDashedRoute/

To install it, simply open the NuGet window in the Visual Studio by right clicking the Project and selecting NuGet Package Manager, and on the "Online" tab type "Lowercase Dashed Route", and it should pop up.

Alternatively, you can run this code in the Package Manager Console:

Install-Package LowercaseDashedRoute

After that you should open App_Start/RouteConfig.cs and comment out existing route.MapRoute(...) call and add this instead:

routes.Add(new LowercaseDashedRoute("{controller}/{action}/{id}",
  new RouteValueDictionary(
    new { controller = "Home", action = "Index", id = UrlParameter.Optional }),
    new DashedRouteHandler()
  )
);

That's it. All the urls are lowercase, dashed, and converted implicitly without you doing anything more.

Open Source Project Url: https://github.com/AtaS/lowercase-dashed-route



Nov
06

IIS FTP Passive Mode

by Dave Stuart | Tags:

I ran into an issue today with my FTP PowerShell script not working. It was configured to use port 21 as it has for years. The FTP site is at my son's house and he just got a new modem when he changed his provide to Telus. I found out that Telus block port 21 so I changed it to port 22, however then ran into a PASV (passive mode) issue where it would not upload files. After several hours I figured out that I needed to set the internal router to allow ports 49152-65534 in and then also had to do the same in IIS under the FTP site as well as set the Exteranl IP Address of Firewall to the IP address of the modem/router.

I found help here if the like still works: http://stackoverflow.com/questions/21032577/how-use-passive-mode-in-ftpwebrequest-fix-pasv-error-in-net-3-5-define-port/21051211#21051211



Visual Studio 2010

If you don’t want the Output Window to show up every time you do a build, you can easily keep it from happening by going to Tools -> Options -> Projects and Solutions -> General and deselect the “Show Output window when build starts” option:



The Blogger

Dave Stuart I'm a Developer with a passion for coding. I enjoy the challengers that come with the job! SharePoint is one of my expert areas along with .NET Web Development with MVC and good old MS Access VBA coding. I Blog so that I can remember how I did that way back when; PLUS all this stuff is searchable! I constantly study and run my own business, Dafran Inc. I have passed 22 Microsoft Exams since 1998 when I first jumped on the treadmill of knowledge. I hope that you enjoy this Blog as much as I enjoy updating it. All the very best from Calgary, Alberta, Canada. contact me at linkedin @ dafran.ca

Calendar

<<  March 2017  >>
MoTuWeThFrSaSu
272812345
6789101112
13141516171819
20212223242526
272829303112
3456789

View posts in large calendar

Sign in