p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

asp_databases thread: Access instead of SQL Server for case study?

Message #1 by "Behrooz Saeed" <bs@l...> on Tue, 11 Jul 2000 13:26:20

I have put a hell of a lot of time trying to produce the sample case study

in the "Beginning E-Commerce" book, and I don't want to give up now.

The SQL Server database uses Table ID's, why doesn't it just

use the Table Name! Is there any way of editing the ASP code in the sample

case study to enable the use of a Microsoft Access "Departments" table?

Example - Const Select_Departments = "Departments"

("Departments" being the name of the Access table)

And also by changing the Connection script to something like the 


Dim m_visit

Function Visit

	If IsEmpty(m_visit) Then

		Set m_visit = Server.CreateObject("Rosslab.Visit")

		m_visit.Configure g_sitename, g_domainname, "driver=Access

Server;" & "DATABASE=Rosslab;" & "Server="

	End If

	Set Visit = m_visit

End Function

Where "Access" is the name of the driver, "Rosslab" is the name of the

database, and the host server's address is

PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  Return to Index