Database Usage
Setting up an ODBC connection (NT/Win2000
Only)
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 (https://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. Click here to view connection
examples 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 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: 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.
How
do I get started?