Search our database

Viewing 681 to 690 of 712 items

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:

<%@ page import = "java.sql.*"%>Obtaining a Connection     <% Connection conn=null; ResultSet result=null; Statement stmt=null; ResultSetMetaData rsmd=null; try { Class c=Class.forName("com.mysql.jdbc.Driver"); } catch(Exception e){ out.write("Error!!!!!!" + e); } try { conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mystudyr_vshare1", "mystudyr_test","passw0rd"); out.write("Connected!"); } catch(SQLException e) { System.out.println("Error!!!!!!" + e); } %><%@ page import = "java.sql.*"%>Obtaining a Connection <% Connection conn=null; ResultSet result=null; Statement […]

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 […]

MySQL remote connection for Windows Shared Hosting:

Remote access to MySQL database on Windows Shared Hosting is enabled by default, simply use SQLyog available at http://code.google.com/p/sqlyog/downloads/list:1. Install and run SQLyog2. Click on New…3. Enter the following info:Host Address: yourdomain.com Username: DatabaseUser Password: DatabaseUserPassword Port: 3306 Database: DatabaseName4. Click on connect

Example of PHP mysql_connect:

<!–?php $link = mysql_connect(’localhost’, ‘mysql_user’, ‘mysql_password’); if (!$link) { die(’Could not connect: ‘ . mysql_error()); } echo ‘Connected successfully’; mysql_close($link); ?–><!–?php $link = mysql_connect(‘localhost’, ‘mysql_user’, ‘mysql_password’); if (!$link) { die(‘Could not connect: ‘ . mysql_error()); } echo ‘Connected successfully’; mysql_close($link); ?–>

Changing max execution time with .htaccess:

To increase the max execution time in PHP, you need to upload an .htaccess file into your public_html folder and the content of the .htaccess file should look like: php_value max_execution_time 60php_value max_execution_time 60

How to enable session via .htaccess?

Create a .htaccess file with the following content and upload it to your public_html folder: php_value session.auto_start 1php_value session.auto_start 1