Create DSNs Instantly

Create DSNs Instantly:

Unlike other hosting companies which ask that you contact them for setting up database DSN (Data Source Name), we allow you an option to do this by yourself in no time. Under Hosting Control Panel for web hosting you will find an option to setup DSN instantly and related guidance.

Database:

You can upload your database to any folder however we recommend folder 'fpdb'. Once database is uploaded, you would need to access it via. your script pages either via. 1) DSN or 2) OLE DB. To setup a DSN please proceed to your hosting control panel and set your DNS under 'ODBC' option.

To use OLE DB please refer to your .asp programming resources. You would need to setup an OLE DB connection string.

To use odbc please set it up in your control panel, normally you need to put only two things, DSN Name, AND DBQ

DSN Name: here you will put the name you want for this DSN

DBQ: here you will put the location of your database, use the following path example, /yourdomain.com/fpdb/dbname.mdb

example of code that goes on your site

Dim objconn

Set objConn = Server.CreateObject("ADODB.Connection")

objConn.Open "DSN=dsnname"

Once your DSN or OLE DB connection is set, test your database out. If connection is ok, you can begin to use your database. Also, there is a way to use Front Page 2000 to connect to your database. Please refer to FrontPage resource for more information.

To update your database, simply update data to your existing database on your home/office machine and upload/replace the database file (.mdb) thats sitting on the server. If you need to upload data via. HTML forms, then you need to setup appropriate forms and scripts. There are third party commercial applications available that can also be used to construct your database driven site such as Macromedia's Dreamweaver UltraDev.

Created: 2003-09-15
Modified: 2005-01-15