| Database Usage
Setting up an ODBC connection
If you wish to use a database you may need to connect to
it using an ODBC connection. To do this you need to create
a DSN (essentially a database connection). To create this
DSN visit the control panel at (http://control.nshosts.com).
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
http://control.nshosts.com 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
We actually recommend a DSN-less connection, however if you
do 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 us.
Connection string examples
Click
here to visit the connection example page where there
are connection string examples listed 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.
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/2003 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: 207.174.232.169. 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.
|
