Articles

Accessing your MySQL database with Perl The Perl module, DBI.pm is a convenient way to connect to the database from within Perl scripts.... Creating ODBC Data Source (Windows plans) To install a new ODBC driver, creating a connection to an external database: 1. Go to Server... DSN-less connection to MS Access Database Sample of DSN-less connection string for MS Access database: You can create sample test aspx... Database Backup for SolidCP In order to back up your database please proceed with the following steps and review the... Database Path (ODBC Connections) The database path for ODBC is c:\inetpub\vhosts\domain.com\ or d:\inetpub\vhosts\domain.com\... Error when connecting with MS SQL Managment Studio to MS SQL Server 2008 If you receive Microsoft SQL Server, Error: 916, when you connect with Microsoft SQL Studio: The... How to connect to MS SQL remotely? The remote MS SQL is activated by default. You need to create database, and database user and... How to connect to MySQL remotely (Linux/cPanel) In order for you to connect to our MySQL service remotely please follow these steps: 1. You need... How to set a Database Connection string for your Application Before you can install any application, that is using a database, it is strongly recommended that... How to set a Database Connection string for your Application Before you can install any application, that is using a database, it is strongly recommended that... How to set up MySQL connection with Dreamweaver 1. Open Dreamweaver 2. Click File > New 3. Choose Dynamic Page in left frame and then... How to upgrade MySQL from version 5.5 to version 5.6 via WHM panel IMPORTANT NOTE: After you upgrade MySQL, there is no supported way to downgrade to the previous... How to upgrade MySQL version via SSH (5.0/5.1/5.5/5.6) IMPORTANT NOTE: After you upgrade MySQL, there is no supported way to downgrade to the previous... Import of MySQL 3.23 DB in MySQL 5 Please refer to the following information for exporting it properly (which can be done ONLY at... Import/Export a MySQL Database using phpMyAdmin Importing a MySQL Database: 1. Log into cPanel. 2. Open phpMyAdmin by clicking the phpMyAdmin... InnoDB support (MySQL) Our MySQL servers include InnoDB support for both our Linux and Windows plans Installation of MySQLi extension for Linux VPS/Cloud via cPanel WHM In order to enable to MySQLi extension in your WHM, please follow these steps: 1. Log into the... MS Access Does MochaHost support MS Access? We do offer MS Access with all of our Windows based shared... MS SQL - SAMPLE CONNECTION STRING (ASP) This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP:... MS SQL - SAMPLE CONNECTION STRING (ASP.NET) This is a sample connection string which you can use with MS SQL 2005 / 2008 under ASP.NET:... MS SQL 2005 / 2008 Features MS SQL 2005 / 2008 with: No limits on number of databases or database size (except for SoHo)... MS SQL BACKUP (Plesk 9) With Parallels Plesk Panel, you can back up and subsequently restore the databases, database user... MS SQL Remote Management We allow remote management/connections for our MS SQL database (Business and Mocha plans only)... MS SQL Reporting Services We do include support for MS SQL Reporting Services. For more information please check the... MS SQL Restore (Plesk 9) If the database already exists and you only need to restore its contents: 1. Go to Domains... MS SQL collation NOTE: MS SQL collation is case insensitive Maximum number of databases per hosting account All of our hosting plans, exept SoHo come with unlimited databases per account/ By default SoHo... MySQL Remote Access We do allow remote MySQL access for our Business and Mocha plans (Both Linux and Windows) MySQL Workbench remote connection If you wish to access your MySQL Database on your server remotely, you will need an application... MySQL default port The default database port for all of our MySQL plans is 3306 Oracle XE support We support Oracle XE for all of our VPS/Cloud - Linux or Windows servers. Please, contact our... Remote MySQL - ""SHOW DATABASES"" permission The access to our Linux Shared & Reseller servers - MySQL database is restricted and does not... Restore higher version database backup on lower version MS SQL server Script the database Objects and restore them on the server To script the database objects you... Restoring MS SQL Database from a backup If the database already exists If the database already exists and you only need to restore its... Restoring database backup of sql server on a lower version of sql server Restoring higher version database backup When you try to restore higher version database backup... SQL converter ALTER DATABASE Compatibility Level If there are issues with your database and it does not work... Sample web.config for Crystal Reports 2008 Sample web.config for Crystal Reports 2008: <?xml version="1.0"?><!--... Shared MySQL Connection Limits MochaHost limits a maximum of 5 simultaneous MySQL connections per account on the shared hosting... We have support for MySQL 5.x We have support for MySQL 5.x What is my database hostname? Please note that in most cases, both Linux and Windows based shared hosting plans are using... Where to deploy your MS access files? You can place your MS access files in the App_Data folder which is not a public folder. Or you... max_user_connections (Shared Accounts) In order to prevent resource starvation, and performance degradation issues of the server where...
« Back