ASP Classic Show Their Error Message

Have you get a notifications when ever you experience an error on your script. Especially when you getthe error message: An error occurred on the server whe

Hi There!

Have you get a notifications when ever you experience an error on your script. Especially when you getthe error message:

An error occurred on the server when processing the URL. Please contact the system administrator

If you are developing ASP Classic in IIS 7.+ make sure that your ASP Classic show their error message and not the message above. This will help you in your development especially when an error occurs. This same situation happen to us when developing the said Scripting Language and IIS 7.+ default its error showing message to false. To modify this just follow this steps:

  1. Go to your IIS Manger.
  2. Select the ASP Icon.
  3. Under the Compilation Table open the Debugging Properties
  4. Make the Send Errors to Browser to TRUE
 
 

Android USB Reverse Tethering

Do you want to use your computers internet to your android but you don’t have a wifi router? Then this Android USB Reverse Reverse Tethering is best for you. Just download this ReverseTethering_2.30.

Hi There!

This is Thomie and giving you another tip so you a tip. Do you want to use your computers internet to your android but you don’t have a wifi router? Then this Android USB Reverse Reverse Tethering is best for you.

Just a quick tip this needs your Android Phone the following :

  1. It is Rooted
  2. USB Debugging is Enabled
  3. You have connected your phone via USB to your computer.
  4. You have Installed all prerequisite drivers of your android phone.
  5. And lastly you opened the said file you have download.

Credit to http://forum.xda-developers.com/showthread.php?t=1371345 for this  amazing software.

Increase Netbook Screen Resolution

Do you want to increase netbook screen resolution? The you can follow this simple steps but its only working on windows 7/Vista.

Do you want to increase netbook screen resolution? The you can follow this simple steps but its only working on windows 7/Vista.

  1. Press WINDOW KEY + R this will open a Run Prompt
  2. On that Run Prompt type regedit
  3. Go find the registry for Display1_DownScalingSupported
  4. After find that change its value from 0 to 1
  5. FIN!

Just a note that the searching may take a little time. And remember that Increased resolution is just a software based emulation so expect that your screen will look somewhat funny after changing to a higher out of scope resolution.

Thanks,

Creating a file to Download dynamically in an https / SSL connection

Here is a tip when you are programming something that you want your file’s path to be hidden. It’s specially when its under a secure connection or https or SSL connection.

Hi there, 

Here is a tip when you are programming something that you want your file’s path to be hidden. It’s specially when its under a secure connection or https or SSL connection.

  1. Remember the mime type ea. image/jpg
  2. Remember the file name ea. image.jpg
  3. Remember not to put expiration and no-cache on your header
  4. Remember to open it on another tab or window as much as possible
  5. When you are debugging you can remove the headers so the file won’t be downloaded

Hope this tips can help you specially #3 because your download will fail on lower version of IE.

Thanks,

MS SQL Search by Column of Database

MS SQL Search by Column of Database

USE DBNAME
GO

SELECT

t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name

FROM sys.tables AS t

INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID

WHERE c.name LIKE ‘%COLUMN_NAME_HERE%’

ORDER BY schema_name, table_name;

A potentially dangerous Request.Form value was detected from the client

Have you ever experience the following error in ASP .NET? A potentially dangerous Request.Form value was detected from the client..

Have you ever experience the following error in ASP .NET?

A potentially dangerous Request.Form value was detected from the client 

Then you are one like me. Then you should now that one of the values of your elements (<inputs> or <button> or <textarea>) has html elements on it. Example is bellow:

<input type=’text’ name=’content’ value='<script language=”javascript”>alert(“Hello World!”);</script>’/>

Then you should also know that this error is persisting because the values given above might be an XSS attack. If you are sure that you want to accept this type of values on your dabatase you may explicitly remove this validation by adding this tag to your page’s masterpage or 1st line of tag.

validateRequest=”false”

If you are on ASP .NET MVC you can add this to your model, assuming that your model has the content variable.

[AllowHtml]
public string content = String.Empty;

Thanks hope it help you allot. Also if you are not familiar with XSS attacks, I will try to make an article for that so you can create your own script that is hack-able, be able to prevent it, and know what are it’s crons.

God Bless!

jStorage:An alternative for Cookies

jStorage is a cross-browser key-value store database to store data locally in the browser – jStorage supports all major browsers, both in desktop (yes – even Internet Explorer 6) and in mobile.

Have you ever wondered if there is an alternative for Cookies? 

You should, because there are limitation and downsides in using Cookies on your website that massively use this feature.

  1. Cookies has limited size on most browsers
  2. Cookies is transfer to server every page load
  3. If you overload the size of the Cookies it will also eat up the space of session and might remove it

Introducing jStorage, a jQuery way of saving your data to the local client and I quote

jStorage is a cross-browser key-value store database to store data locally in the browser – jStorage supports all major browsers, both in desktop (yes – even Internet Explorer 6) and in mobile.

Yes it even support IE 6!

So how to use it in an easy way?

  1. Include the following references to your project
    1. <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.8.0/jquery.min.js"></script>
      <script src="https://raw.github.com/andris9/jStorage/master/jstorage.js"></script>
  2. Use $.jStorage.set(key, value) to save a value 
  3. Use $.jStorage.get(key, “default value”) to get a value

And thats it you are now using jStorage. 

Reference : http://www.jstorage.info/

WCF in Different Domain or Server

One of the main error that you may experience is The request for security token could not be satisfied because authentication failed.

Hi There,

Its bean a while since I have updated my blog so I will be posting one of the things that I have experience on my work. That is WCF in Different Domain or Server. One of the main error that you may experience is the same as bellow:

Server Error in ‘/’ Application.


The request for security token could not be satisfied because authentication failed.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ServiceModel.FaultException: The request for security token could not be satisfied because authentication failed.

Source Error:

Line 87:         
Line 88:         public bool IsExisting(string domain, string username) {
Line 89: return base.Channel.IsExisting(domain, username); Line 90:         }
Line 91:         


Source File: D:\Projects\MobileWeb\MobileWeb\Service References\SykesAD\Reference.cs Line: 89

Stack Trace:

[FaultException: The request for security token could not be satisfied because authentication failed.]
   System.ServiceModel.Security.SecurityUtils.ThrowIfNegotiationFault(Message message, EndpointAddress target) +8904771
   System.ServiceModel.Security.SspiNegotiationTokenProvider.GetNextOutgoingMessageBody(Message incomingMessage, SspiNegotiationTokenProviderState sspiState) +203

[SecurityNegotiationException: The caller was not authenticated by the service.]
   System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +4729651
   System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +1725

 

This message or exeception happens in production (published files has been uploaded to IIS) and not when you are currently developing it on your Visual Studio. So what is the solution? Here is the simple solution that made me a little crazy upon gazing unto it.

//Let say here is your Instantiation of your WCF
ClassADClient ad = new ClassADClient();
//Then the solution is to add a credential that the system will use on using the said WCF
//Such as like this
ad.ClientCredentials.Windows.ClientCredential = new NetworkCredential(“domain\\username”, “password”);

That’s it thats the solution and you can now use the said service without the said error.

Hope I help you! 

 

Thanks,
Thomie Jose San Agustin, MCP 

Don’t Ever use Inline Database in MSSQL SP and Query

I have been modifying a source code from my work and it has been a little difficult to test the system in multiple instances of database.

Hi there!

I have been modifying a source code from my work and it has been a little difficult to test the system in multiple instances of database. This is due the previous developers of the said source code used Inline Query Codes and Connection Strings. In addition to that this Inline Queries and even their Stored Procedure use Inline Database, an example is [Database1].[dbo].[tbl_tableName] which should not be in practice if it is using the same database on the whole coding system.

This kind of practice limits the system to use different database name. For an instance you have a web server that serves both Development and Production Environment. You have a project that needs to have Dev and Prod on the said server. If this practice is used you are limited to one Environment at a time nevertheless you modify each script to change that inline database name. So its better to use [dbo].[tbl_tableName]  than [Database1].[dbo].[tbl_tableName] 

Thanks,

Thomie

Lord Nawa Makausap kita sa aking Pagtulog

Lord Nawa Makausap kita sa aking Pagtulog

Lord Nawa Makausap kita sa aking Pagtulog. Para lahat ng gusto kong sabihin masabi ko po sayo. Tapos marinig ko agad mula sayo po ang mga kasagutan. Hindi po tulad ng pagdadasal na sa ibang paraan nyo po sinasabi ang inyong kasagutan.

Replace String with Regular Expression

You can use this code to Replace String with Regular Expression

You can use this code to Replace String with Regular Expression 

string x = “<div width=’100px’></div>”;
x = Regex.Replace(x, “width='[a-zA-Z0-9]*'”, “width=’300px'”);
Console.WriteLine(x);
Console.Read();

Delete all MS SQL Stored Procedure

Here is a code that you can user to delete all ms sql stored procedure

Here is a code that you can user to delete all ms sql stored procedure

DECLARE @procedureName varchar(500)
DECLARE cur CURSOR
      FOR SELECT [name] FROM sys.objects WHERE type = 'p'
      OPEN cur

      FETCH NEXT FROM cur INTO @procedureName
      WHILE @@fetch_status = 0
      BEGIN
            EXEC('DROP PROCEDURE ' + @procedureName)
            FETCH NEXT FROM cur INTO @procedureName
      END
      CLOSE cur
      DEALLOCATE cur