Search our database

Viewing 661 to 670 of 688 items

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

How to disable public display errors with .htaccess?

To prevent public display of PHP errors under a Linux hosting plan, you will need to upload a .htaccess file, with the following instruction below. # disable display of startup errors php_flag display_startup_errors off   # disable display of all other errors php_flag display_errors off   # disable html markup of errors php_flag html_errors off […]

MSSQL (Microsoft SQLServer) ConnectionString in ASP/ASP.net:

SQL ODBC connection strings:Standard Security "Driver=; Server=Your_Server_Name; Database=Your_Database_Name; Uid=Your_Username; Pwd=Your_Password;""Driver=; Server=Your_Server_Name; Database=Your_Database_Name; Uid=Your_Username; Pwd=Your_Password;" SQL OLE DB connection strings: "Provider=SQLOLEDB; Data Source=127.0.0.1; Initial Catalog=Your_Database_Name; UserId=Your_Username; Password=Your_Password;""Provider=SQLOLEDB; Data Source=127.0.0.1; Initial Catalog=Your_Database_Name; UserId=Your_Username; Password=Your_Password;" SQL SqlConnection .NET strings: "Server=127.0.0.1; Database=Your_Database_Name; UserID=Your_Username; Password=Your_Password; Trusted_Connection=False""Server=127.0.0.1; Database=Your_Database_Name; UserID=Your_Username; Password=Your_Password; Trusted_Connection=False" SQL SqlConnection for SQL 2008: "Provider=SQLNCLI10; Server=127.0.0.1; Database=database_name; UId=user_id; Pwd=password;""Provider=SQLNCLI10; […]

How to connect to MSSQL Server with MSSQL Management Studio?

Connecting to the SQL server via SQL Management Studio is possible. For example, your domain name is www.domain.com , All you need to do is:Login to Plesk https://www.domain.com:8443Login with your domain name, and the passwordGo to Database, Create a new database & Database user and passwordPlease take note on the username & password which you […]