RSS Feed
Knowledgebase : Databases
To create a new database you will need to login to your control panel. We support several control panels so the instructions and button names vary accordingly. LINUX WEB HOSTING PLANS: * Login to your Account. * Click on the "Control Panel" button....
  WE SUPPORT TWO MAJOR DATABASE TYPES. WHILE OTHER DATABASE TYPES MAY FUNCTION ON OUR SYSTEMS THESE ARE THE TWO WE RECOMMEND AND SUPPORT: * Microsoft SQLServer (Windows Only): For robust applications with 1000's of transactions. * MySQL (Windows and...
THIS CODE SETS UP A DSN-LESS ODBC CONNECTION TO A MS ACCESS DATABASE IN PHP 5 ON YOUR SERVER PLATFORM. if (!isset($con)) { $dbfilename = "D:/HostingSpaces/yourspacename/yourwebsite.com/wwwroot/DBfilename.mdb"; $dbuser = ""; $dbpassword = ""; $con = ...
This topic refers to connecting your website application/software to a database you've already created. Please refer to the Create Database [https://www.ephost.com/support/Knowledgebase/Article/View/13/3/creating-a-new-database] or Manage Database (SQL [h...
MANAGING A MICROSOFT ACCESS DATABASE: MS Access db are a stand-alone database file. It can be moved via FTP. Simply download the database using FTP to your local computer. You will need to have MS Access (generally it's part of MS Office) installed on ...
MANAGING A MS SQL DATABASE: A MS SQL database physically resides on a separate server. You will not be able to download it by FTP. Instead you will edit the database live in real-time. To do this, you will need to connect to the database using a databa...
MANAGING A MYSQL DATABASE: A MySQL database physically resides on a separate server. You will not be able to download it by FTP. Instead you will edit the database live in real-time. To do this, you will need to connect to the database using a database...
MANAGING MS SQL DATABASE LOCALLY: THESE INSTRUCTIONS ARE FOR MS SQL 2000 USING ENTERPRISE MANAGER AND DTS (DATABASE TRANSFORMATION SERVICES). THE PROCEDURE IS NEARLY THE SAME FOR MS SQL 2005 DBS USING MS SQL SERVER MANAGEMENT STUDIO AND SSIS (SQL SERVER ...
4 POSSIBLE REASONS YOU ARE UNABLE TO CONNECT TO YOUR MS SQL DATABASE: * You are attempting to use the internal IP address when connecting remotely. Use the address that begins: 64.87.xxx.xxx. * You have not created a database yet or are trying to con...
IMPORTANT IP ADDRESSES TO MAKE NOTE OF: The following is a list of important IP addresses may need when using our service. For security reasons, we employ a NAT firewall configuration which means that a particular globally routable external IP (64.87.x.x...
HOW TO DISABLE "PREVENT SAVING CHANGES" OPTION: If you are currently using MS SQL Server 2008 Management Studio, you may receive the following error when attempting to make changes to a database table. _"Saving changes in not permitted. The changes you...
RESETTING DATABASE AND USER PASSWORDS: The password for a MS SQL or MYSQL database can be reset from the Control Panel on a Windows hosting Plan. A MS Access Database doesn't not have a username or password to login. MySQL database on a Linux Plan can be...
MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS (SSMSE) is a FREE, easy-to-use graphical management tool for managing SQL Server Express Edition and SQL Server Express Edition with Advanced Services. [Download SQL Server Management Studio (SSMS) [https...
CREATE A ODBC DSN: A Data Source Name (DSN) is used to provide a connection to a database through a ODBC driver on Windows hosting plans. The connection is an easy way to reference all of the information needed to connect to a database in your web applic...
Copyright © 2015 EPhost, Inc. All rights reserved.