Hello,

I am very much new with windows system.

I need to install Quick Classifieds 200. I download its free version from here: http://www.xcent.com/downloads/default.asp?file=43

By reading installation manual I found that by default QCConfig.asp configured for Jet database. I need to configure this for MS SQL databse.

But I didn't find how to do this.

Here is the code of QCConfig.asp
Code:
<!-- #include file="QCLangUSEng.asp" -->
<%
'*******************************************************************************
'* QuickClassifieds Copyright 2003 XCENT - www.xcent.com                       *
'* QuickClassifieds is a trademark of XCENT                                    *
'* This notice may not be removed from this source code file                   *
'*******************************************************************************

giTableWidth 	= 600

giAdRunLength   = 10
giItemsPerPage  = 2
gsMoneySymbol   = "$"

'set whether fields are displayed
gbShowStreet    = TRUE
gbShowCity      = TRUE
gbShowState     = TRUE
gbShowZipCode   = TRUE
gbShowCountry   = TRUE
gbShowPrice     = TRUE

'Set required fields to post ad (TRUE/ FALSE)
gbReqEmail  	= TRUE
gbReqStreet 	= FALSE
gbReqCity 	    = FALSE
gbReqState 	    = FALSE
gbReqCountry 	= TRUE
gbReqPrice	    = FALSE


'This sets the 2 alternating colors for table on the view ads page
gsColorONE      = "#E9E9E9"
gsColorTWO      = "#FFFFFF"

gsCellColor     = "#2B71B7"
gsLineColor    	= "#0000A0" 	'thin lines around table header and footer (For MSIE Only)
gsPageBGColor  	= "#FFFFFF"
gsHeadingColor 	= "#c0c0c0"
gsEmptyCellColor = "#FFFFFF" 'cell to the right of the tab

'set the fonts for various areas; be sure not to remove double/ triple quotes

gsFont              = "Tahoma,Arial,Sans-Serif"
gsPlainTextOpen 	= "<FONT FACE=""" & gsFont & """ SIZE=""2"">"
gsPlainTextClose 	= "</FONT>"
gsCategoryNameOpen 	=  "<FONT FACE=""" & gsFont & """ SIZE=""3""><B><DIV CLASS=""QCMainCat"">"
gsCategoryNameClose = "</DIV></B></FONT>"
gsPageHeadOpen 		= "<P align=""CENTER""><FONT FACE=""" & gsFont & """ SIZE=""3""><B>"
gsPageHeadClose 	= "</B></FONT></P>"
gsTableHeadOpen 	= "<FONT FACE=""" & gsFont & """ SIZE=""2""><B>"
gsTableHeadClose 	= "</B></FONT>"
gsTableLineOpen 	= "<FONT FACE=""" & gsFont & """ SIZE=""2"">"
gsTableLineClose 	= "</FONT>"
gsNavigationOpen 	= "<FONT FACE=""" & gsFont & """ SIZE=""2""><B>"
gsNavigationClose 	= "</B></FONT>"
gsAdDetailHeadOpen	= "<P align=""Right""><FONT FACE=""" & gsFont & """ SIZE=""3""><B>"
gsAdDetailHeadClose = "</B></FONT></CENTER></P>"
gsPageNavOpen  		= "<FONT FACE=""" & gsFont & """ SIZE=""2"">"
gsPageNavClose 		= "</FONT>"
'used for the main tab headings in each page 
gsTabTextOpen 	    = "<FONT FACE=""" & gsFont & """ SIZE=""2"" color=""#ffffff""><B>"
gsTabTextClose 	    = "</B></FONT>"

'various headings on the pages, such as on the view item page
gsSubHeadOpen  		= "<FONT FACE=""" & gsFont & """ SIZE=""3"" COLOR=""#A0A0A0""><B>"
gsSubHeadClose 		= "</B></FONT>"

'names of fields on view item page, for example
gsLabelOpen 		= "<FONT FACE=""" & gsFont & """ SIZE=""2""><B>"
gsLabelClose 		=  "</B></FONT>"

gsErrorTextOpen     = "<FONT COLOR=""#FF0000"">"
gsErrorTextClose    = "</FONT>"




gsEmbeddedCode      = "%CONTENT%"   
gsPageHeader        = Server.MapPath("QCTemplate.htm")


'if you move the database from the root directory, you will have to change this setting
gsConnect           = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../Data/QuickClassifieds.mdb")

'System Library Database Configuration Settings 
gsSQLDateDelimiter 	= Chr(35) 
'gsSQLDateDelimiter = Chr(39) 

'gsSQLWildCardChar 	= "*"
gsSQLWildCardChar	= "%"

'***giSQLDateAsSystem = True 'OBSOLETE! If this was TRUE, set giSQLDateFormat = 0, otherwise giSQLDateFormat = 1
giSQLDateFormat = 0 'Default As System
'giSQLDateFormat = 1 'SC-SQL
'giSQLDateFormat = 2 'SC-JET-MDY
'giSQLDateFormat = 3 'SC-JET-DMY
%>
Any help is very much appreciated.