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.