FAQ (Database)

	What are the differences between the databases you support?
	[SQLServer] How do I install the SQL Server CD?
	[MySQL] How do I access my database?
	[Access] How do I register my Access database?
	[MySQL] Is there a GUI tool for managing my database?

1. Select Local Install... and press the Next button.
2. Click the Next button on the Welcome window.
3. Read the software agreement and then click Yes to continue.
4. In the Name field enter your name.
5. In the Company field enter ChamberGates and then click the Next button.
6. In the CD-Key boxes enter the code that appears on the sleeve of your CD and then click the Ok button.
7. Click Ok again to go to the next window.
8. Select the Custom option and then click the Next button.
9. Uncheck the Server Components check box (you are not licensed for this feature).
10. Check the Management Tools check box and then select all of the sub-components in the right pane.
11. Check the Client Connectivity check box.
12. Check the Books Online check box if you would like for the SQL Server documentation to be installed.
13. Uncheck the Development Tools check box and then click the Next button.
14. Click the Next button on the Start Copying Files window.
15. Click the Finish button to complete the process, if the setup program asks you to reboot then go ahead and do that.

1. Open the Client Network Utility from the Microsoft SQL Server folder.
2. Click on the General tab and then click on the Add button.
3. In the Server Alias field enter chambergates.
4. In the Network libraries frame choose TCP/IP.
5. In the Computer name field enter sqlserver.chambergates.com.
6. Click Apply and then click Ok.
7. Open Enterprise Manager
8. Right click on the SQL Server Group and choose New SQL Server Registration.
9. In the Server field click on ... button.
10. Choose the chambergates entry.
11. Under Connection choose Use SQL Server authentication.
12. For Login Name and Password use your FTP account information.
13. Click Ok.

Alternatively, you can place your database files in your /Priv directory, this directory will allow your visitors to write to it, but it can not be accessed through a browser.

The next step is to determine if you want to use a DSN or DSN-less connection. If you choose to use a DSN, then please contact technical support and provide us with the name you would like to use and where the database file resides. It is a little harder to program a DSN-less connection but you also do not have to wait for technical support to create the DSN for you. Although we do support development issues you can find some more information about DSN-Less connections at Paco's Drivers.

If you are using a DSN-Less connection and you did not place the database within the \Priv folder then you may need to contact technical support to set the file permissions for you. Please note that we can not change your file permissions in the root web folder.

1. Choose Run... from the Start menu.
2. If you are using Windows 95, Windows 98, or Windows Me then type COMMAND. If you are using Windows NT, Windows 2000, or Windows XP then type CMD.
3. Click the Ok button, you should see a console window appear with a DOS prompt.
4. Next you will need to change to the directory where you installed MySQL (e.g. C:\MySQL) by typing CD \MySQL and pressing the Enter key.
6. Now type CD BIN and press the Enter key.
7. Now type mysql -h server_name -u user_name -p where server_name is the server name provided when we setup your MySQL database and user_name is your FTP user name.
8. Press the enter key and when prompted for your password enter your FTP password.
9. You should now see a mysql> prompt, enter Show Databases; and press the enter key.
10. A list of databases that you can access should appear, in most cases this will only be one. Now type Use database_name.
11. Press the Enter key and you will now be able to issue MySQL commands directly.
12. When you are done you can disconnect by typing Exit and pressing the Enter key.
13. To close the console window, type Exit and press the Enter key.

1. After downloading the ZIP file, extract all of the files to a temporary directory and then execute the setup.exe program.
2. Click the Next button on the Welcome to the MySQL Control Center window.
3. Read the license agreement and if you agree to the terms select the I accept the license agreement option. If you do not agree, then you will have to find another tool. Click the Next button to continue.
4. Click the Next button on the Readme Information screen.
5. Click the Next button on the Destination Folder screen, unless you want to change the directory where this application will be installed to.
6. If you do not use any of the languages listed in the translations, you can choose not to install them by clicking on the down arrow next to the word Translations and then selecting the Entire feature will be unavailable.
7. Click the Next button to continue.
8. Click the Next button on the Ready to Install the Application window.
9. Once the files have been copied click the Finish button on the completion window.

1. Start the program by selecting the MySQL Control Center item in the MySQL Control Center menu in the Start menu.
2. When the application starts you should see the Console Manager window. Choose New from the File menu.
3. In the Name box enter ChamberGates.
4. In the Host Name box enter the server name we gave you in your MySQL setup letter.
5. In the User Name box enter your FTP user name.
6. In the Password box enter your FTP password.
7. Click the Add button to create this database entry.
8. Now you should see a ChamberGates entry in the left side of the Console Manager window. Right-click on ChamberGates and choose Connect.
9. Expand the Databases folder and you should see all of the MySQL databases that we have setup for you.
10. To enter queries and get results you can click on SQL button or press CTRL+Q.