check domain availability:
www.
Support
Contact Us

About Us
Order
Linux Plan
Windows Plan
Resellers
Members
Support
Contact Us

Windows 2000.
For Windows 2000 Unlimited Plan clients, a rough guide to some of the key features are available below that may help answer your questions.

DATABASES
  MS Access

Using Microsoft Access
All our Win2000 based servers have full support for Microsoft Access databases.

You can connect to your database:
  - via ODBC
or
  - via file DSN
  * global.asa file example using ODBC
  * global.asa file example using database path

You can also use DSN-less connections.
DSN-less connections are faster than System DSN connections because DSN-less avoids doing a registry lookup. Furthermore you can receive additional performance benefits by directly using the OLEDB layer.

Here is an example:
Dim Conn, dbPath
dbPath = "D:\webspace\hostname\username\yourdomain.com\www\youraccessfile.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath

Or you can use server map path:
Set MyConn = Server.CreateObject("ADODB.Connection")
conString = "DBQ=" & Server.MapPath("YourDatabase.mdb")
Myconn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & conString

You can find the physical path to your virtual website using the following code, view code.




<< back

 




view details


view details


view details

homesite mape-mail
Wed, 25 May 2005
Launch date for new HostSupreme Client manager set for 15th June!
...

Mon, 23 May 2005
Host Unlimited Domains for just £9.99 per month! Order the Linux Professional Plan and get it
...

Fri, 20 May 2005
New High Spec Linux Network Plans finalised!
...


[c]2002 - 2004 Hostsupreme Ltd, All rights reserved