YoHost Home
Sign Up
Linux Hosting
Windows Hosting
Windows Hosting Plans
Helm Control Panel Demo
Reseller Information
Windows FAQ
Frequently Asked Questions
Pre-Sales FAQ
Linux Hosting FAQ
Windows Hosting FAQ
Support

YoHost Windows Hosting FAQ: Databases

What version of MySQL and Microsoft SQL Server do you run?

  As of August 2007, we offer a choice of MySQL 5, SQL Server 2000, or SQL Server 2005.

How do I set up a MySQL or MS SQL database and ODBC DSN?

  In the Control Panel, click on Domains, then click on the appropriate domain.
Click on Advanced Settings, then Database Manager, then Add New.
Choose Microsoft SQL Server 2000, and type a name for your database. Click on Save.
Under Database Users, click on Add New to create a user for your database.
Choose a name and password for your Database User. Click on Save.

How can I set up an ODBC DSN for my database?

  First set up a database as described above, or upload an Access database to the db directory that was provided for your domain. Then use the control panel to add the DSN, under Domains→yourdomain.com→ODBC DSNs→Add New.

How can I set up a datasource for my ColdFusion application?

  First set up an ODBC DSN as described above. Then, use the CF Datasource Setup link on the left side of the control panel.

Can I use a connection string in ColdFusion to access my database?

  No, ColdFusion MX does not allow this. You will need to set up a ColdFusion datasource as described above. Then you can use a tag of the form <CFQuery DataSource="DSNName"< or <CFQuery DataSource="DSNName" UserName="DBUser" Password="Password">.

I have a database set up under one domain, but I want to access the database from another domain. Can you help?

  Yes, please contact Support with the details, and we will modify the permissions or CF sandbox as needed. Please provide a link to a URL that shows any permission error that you are encountering.

Can you provide any tools for managing MySQL databases?

  Yes, phpMyAdmin is available. You can use the link provided in the control panel, or contact Support for details.

Can I use Enterprise Manager or SSMS to administer my MS SQL databases?

  Yes, please contact Support for instructions.

Can you provide any other tools for managing MS SQL databases?

  Yes, we provide Web Data Administrator for SQL Server 2000 and MyLittleAdmin for SQL Server 2005. You can use the link provided in the control panel, or contact Support for details.

Can I set up an Access database from scratch on the server?

  Yes, you can use the control panel to create a blank database, under Domains→yourdomain.com→Database Manager→Add New.

Copyright © 2002-2017 YoHost.com
terms   privacy   contact