How to Custom Date Formatting in VBScript – ASP Classic

No Comments »

FormatDateTime ASP Classic provides FormatDateTime function which allows you to format a valid date or time expression. For date, it allows you to select two formats: vbLongDate, and vbShortDate. The syntax is as follows: FormatDateTime(date,format) Parameter Description date Required. Any valid date expression (like Date() or Now()) format Optional. A value that specifies the date/time… Read more »

Fix “MSVCR110.dll is missing from your computer”

2 Comments »

You receive the error message while trying to execute a program: "The program can’t start because MSVCR110.dll is missing from your computer. Try reinstalling the program to fix this problem. Solution This error message appears when you want to run a program which requires the Microsoft Visual C++ Redistributable 2012, but you haven’t installed it… Read more »

How to Import Large SQL file Using MySQL command line

Comments Off

Import Large SQL file Using MySQL command line When you want to restore database from a SQL backup file to your MySQL server on web server, you can simply restore it using phpMyAdmin which is fast and easy. However, if the backup file is a large SQL dump file, let’s say 50 MB, you can’t… Read more »

[Solved] Error Setting Write Mode Page on UltraISO

1 Comment »

Fix Error Setting Write Mode Page on UltraISO UltraISO is an ISO CD/DVD image file creating, editing, converting tool and a bootable CD/DVD maker. It can directly edit the CD/DVD image file and extract files and folders from it, as well as directly make ISO files from your CD/DVD-ROM or hard disk. If you’re trying… Read more »

Change Authentication Mode on SQL Server 2012 Express

Comments Off

By default configuration, SQL Server allows only Windows authentication mode. However, if you have some legacy or custom application that needs to access SQL Server using ‘sa’ account, you have to change authentication mode on SQL Server to mixed mode (SQL Server and Windows authentication mode). This post shows you how to change authentication mode… Read more »

Install Sample Database Adventure Works on SQL Server 2012 Express

Comments Off

There are many benefits of sample databases, for example, it can be use for learning or studying database-related subjects, or use to test your script/query, etc. In those previous versions of SQL Server, Northwind and Pubs are popular sample databases, however, they aren’t maintain any more (they don’t update). Therefore, it is better and recommend… Read more »