ODBC Support Services > Web Hosting >NT Hosting

Database Features

ODBC for Microsoft Access

In order for a site to be able to use ASP in conjunction with a Microsoft Access database, extensions for the database must be installed on the web server so that they can interact properly. We setup an ODBC System DSN (data source name) which points to a Microsoft Access database file within your site.

The database file is placed in a data directory outside of the content directory for security purposes. You also have the ability to setup an unlimited amount of DSN-less connections to Microsoft Access database files.

   
Microsoft SQL Server 7.0
 

Microsoft SQL server is capable of supporting even the most demanding web applications.

Microsoft SQL Server is a robust enterprise-caliber relational database server that is designed for enterprise databases. It is similar to and competes with Oracle and Informix.

   
Just how important is the SQL server?

It transforms a static catalog site into a dynamic vendor site that allows integration of a customizable database with a clean online interface.

  • Dedicated, high performance MS SQL Servers.
  • Remote Visual InterDev access to MS SQL Server
  • Remote ISQL_w access to MS SQL Server
  • Online MS SQL Server database and transaction log backups

All customers that are utilizing Microsoft SQL server are given database owner privileges. This means that you will have full control of your database once it has been created, however you will need to contact our support staff to create your database(s).

Communications with these databases is usually accomplished through Active Server Pages (.ASP) or the Internet Database Connector (.IDC/.HTX). Queries are lightning fast because our servers are optimized to handle this type of workload.

Getting Started ...

Microsoft FrontPage 2000 has some very helpful database capabilities. If you are familiar with MS Access, you can start by using the built in wizards to create the ASP or IDC files for you.

It can save tables, queries, and forms as dynamic html files for use with your database. It will also automatically add Active X controls to the pages it creates which allow you to add, delete, or update records in your database.

These pages can then be customized to have the look and feel of your web site. There are other, more powerful, tools such as MS Visual InterDev 6.0 which are designed for advanced programmers. MS Visual InerDev 6.0 will give you the ability to write even more powerful database applications.

Sunday Support
 
  "I never expected to get help from Interpole on a Sunday, when my mailbox was being bombed. You exceeded my expectations" - Paresh Patel (Acenetworks)  
 
Shared Solutions
 
   
 

InterPole Internet Managed Hosting InterPole Internet Managed Hosting
Sales Contact
Interested in NT Hosting?
Request a Proposal.
 
©2003 Interpole, All rights reserved