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
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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


  Return to Index