I was given an application that currently uses ASP and SQl script. With in the .asp script, the .sql files are mentioned. Here is an example of some of the codes : varCheck = "T" if varUserid <> "" then Call CheckForErrors(objConn) Set oRS=Server.CreateObject("ADODB.recordset")
sqltext = "Select CustID, ContactLastName from Custprofile where ClientID = '" & varClientID & "' and " sqltext = sqltext & " UserID = '" & varUserID & "'" oRS.open sqltext, objConn Call CheckForErrors(objConn) oRS.MoveFirst strLastName = oRS("ContactLastName")
strCustID = oRS("CustID") If strLastName <> "" and ((varPrcType = "U" and varCustID <> strCustID) or varPrcType = "A") then strProcess = "F" else strProcess = "T" end if oRS.Close My problem is I am trying to get everything set up correctly so that the code
can function properly, but I am not sure and have searched for many days on how to set up IIS and a database for these files. I am very new to this, so any help would be useful. thank you in advance.
jhayes3213
2 Posts
Using Classic ASP with a SQL server 2008
Apr 19, 2012 07:39 PM|LINK
steve schofi...
5682 Posts
MVP
Moderator
Re: Using Classic ASP with a SQL server 2008
Apr 23, 2012 08:57 AM|LINK
You are creating a recordset object to connect to sql server. Here is a good starter article posted by MS
http://msdn.microsoft.com/en-us/library/ms807027.aspx
Steve Schofield
Windows Server MVP - IIS
http://iislogs.com/steveschofield
http://www.IISLogs.com
Log archival solution
Install, Configure, Forget