Hosting Support
Database Usage

Making a database updateable

If you need the database to be editable/updateable via ASP or PHP pages you must change the permissions on it. Visit the control panel to change the permissions. If you put the database in a directory then change permissions on that directory any files you upload to that directory will inherit updateable permissions. If you have it in your root directory, only the file will be given updateable permissions, which means if you reupload the database file you will have to perform the permission change again.

Create a DSN on the server

If you require a DSN you can create one through the control panel to Access Database. If you require one for a Foxpro or Dbase database please contact support.

Connection string examples

Click here to visit the connection example page where we have listed the connection string examples for DSN and DSN-less connections for all common database types..

Create a DSN on your computer for SQL Server

Creating a DSN on your computer for SQL server helps you to do some common tasks, in particularly testing your pages locally before uploading them and also creating an SQL Database from an Access Database (click here for details).

On Windows 95, 98 or ME then you need to go to the control panel on your computer and click on 'ODBC Data Sources (32 bit)'.

On Windows NT/2000 you need to go to 'Start', 'Program Files', 'Administrative Tools' and 'Data Sources'.

Click on 'Add'

 

Click on 'SQL Server' and click 'Finish'.

Fill out the details using any name for the database and the server location as the IP address: 216.58.174.132 Now click 'Next'.

Ensure you choose SQL Server authentication, and fill out your username and password then click 'Next'.

Ensure that the 'Change the default database to' is set to your database (your database name is your username). Then click 'Next'.

You can now choose which language to support and any local logging options. Once you have done this click 'Finish'.

You will now have a summary page displayed.

Click on 'Test Data Source'. If your login is correct and everything is set correctly it should say 'Tests completed successfully!'. Click 'OK' and then click 'OK' again on the summary page.

Your connection should now be displayed in the list of connections. Any ASP pages you run using a local webserver or personal web server should now be able to use this DSN, you should also be able to use it to upgrade any Access 2000 databases.

 

Hosting Support Menu

Getting started

Domain transfer

Is my domain active?

Control panel

Email setup

Outlook Express

Netscape

Web Based Email

PHP

FTP

Telnet

Custom errors

Perl/CGI scripts

Server Side Includes

Database use

Securing your data

Account Information

Site statistics

SQL Server 7

Subdomains

Domain Pointers

Search Engines

How do I ...