About Us
Order
Linux
Windows
Resellers
Members
check domain availability:
www.
Support
Contact Us
 
Home Site Map E-mail

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

Sat, 16 May 2009
HostSupreme under new Management. Web site relaunched with lots of added features for our clients!
....

Tue, 17 August 2004
HostSupreme voted UK's NUMBER ONE E-commerce Provider by HostDir.com!
....