Hello!
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
following:
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=10.0.0.2"
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 10.0.0.2
PLEASE HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!