Search our database

Viewing 721 to 730 of 756 items

MySQL ConnectionString in ASP and ASP.Net:

Dim MyConString As String = _ "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & Server _ & ";DATABASE=" & DataBase & ";UID=" & User _ & ";PASSWORD=" & Password & ";OPTION=3;"Dim MyConString As String = _ "DRIVER={MySQL ODBC 5.1 Driver};SERVER=" & Server _ & ";DATABASE=" & DataBase & ";UID=" & User _ & ";PASSWORD=" & Password & ";OPTION=3;" […]

Backup MSSQL database with MSSQLDump:

1) Download MSSQLDump from http://www.parallels.com.cn/downloads/Prima/Tools/MsSqlDump.zip2) Place the MSSQLDump file into C:\X3) Go to command prompt and change the directory to C:\X4) Run the command MSSQLDump -S localhost -U database_username -P database_password -D database_name -O database_backup.sql -createtable -insertdataMSSQLDump -S localhost -U database_username -P database_password -D database_name -O database_backup.sql -createtable -insertdata

ASP.net viewstate error:

If you get the following error message:Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.It is due to some bugs in .Net framework, simply add in the following line in […]

How to do a page redirection in ASP?

To create a page redirection in ASP, consider:You would like to redirect http://www.ipserverone.com to http://www.ipserverone.com/eshop1) Create a file named index.asp 2) Place the following command in the index.asp &lt;% Response.Redirect("http://www.ipserverone.com/eshop") %&gt;&lt;% Response.Redirect("http://www.ipserverone.com/eshop") %&gt;

Disable mod_security with .htaccess:

To disable the mod_security, you need to upload an .htaccess file to your public_html folder. The .htaccess file should contain:   SecRuleEngine Off SecRuleEngine Off

How to generate MSSQL Server backup?

You can use 3rd party tool like:Microsoft SQL Server Database Publishing Wizard 1.1http://www.microsoft.com/downloads/details.aspx?FamilyId=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=enOr the following is a newer way to backup:http://sqlbackupandftp.com/http://sqlscriptgenerator.com/

Example for JSP MySQL connection

 JavaServer Pages (JSP) is a Java standard technology that enables you to write dynamic, data-driven pages for your Java web applications.  Below is the example of  MySQL database access using JSP. <br />&lt;%@ page import = "java.sql.*"%&gt;Obtaining a Connection     &lt;% Connection conn=null; ResultSet result=null; Statement stmt=null; ResultSetMetaData rsmd=null; try { Class c=Class.forName("com.mysql.jdbc.Driver"); } […]

Convert folder to application in Plesk:

1. Login to Plesk control panel 2. Click on Virtual Directories 3. Click on Create Virtual Directories 4. Put in the preferred subdirectory name and setting then click on the ok buttonThe created virtual directory will be converted to an application in IIS.

Microsoft SQL server error 916:

If you receive following error while using Microsoft SQL Server Management Studio 2008:The server principal “username” is not able to access the database “dbname” under the current security context. (Microsoft SQL Server, Error: 916)Solution:In Object Explorer, click databasesDisplay “Object Explorer Details” (F7) or “View –> Object Explorer Details”Right click the column headers and deselect “collation”Refresh […]