Welcome to MobyThreads.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in
All support for the MobyThreads Threaded phpBB MOD can now be found on welsolutions at this forum

ASP CODE IS STOPPING IIS SERVICE DEAD

 
   Web Hosting and Web Master Forums (Home) -> IIS RSS
Next:  no administerable services found  
Author Message
stewert

External


Since: Sep 04, 2003
Posts: 1



(Msg. 1) Posted: Thu Sep 04, 2003 4:21 pm
Post subject: ASP CODE IS STOPPING IIS SERVICE DEAD
Archived from groups: microsoft>public>inetserver>iis (more info?)

Im running some pretty straight forward code.

Mainly database access (SQL7) doing inserts and sometimes when the script
runs it halts the IIS service dead in its tracks. Before the page can even
finish loading.

the error seems to be caused when i introduced this section of code into the
page.

sub SaveIDC( rec2Save )

'# Local variable declarations
Dim myLocalArr
Dim szIDCID
Dim szIndividualID
Dim rsQJIndInfo

'# Perform the value extractions from the CSV record.
myLocalArr = breakString( rec2save, "SR" )

'# get the individual id from the QJIndInfo table based on the QJ User ID.
set rsQJIndInfo = server.CreateObject("ADODB.Recordset")
rsQJIndInfo.Open "select * from QJIndInfo where QJUserID = '" &
myLocalArr(12) & "'", conn, 1, 3

if rsQJIndInfo.RecordCount > 0 then
szIndividualID = rsQJIndInfo("Individual_ID")
else
szIndividualID = myLocalArr(12)
end if

szIDCID = replace(myLocalArr(64), " ", "" ) & "_" & myLocalArr(12) & "-" &
myLocalArr(13) & "_" & formatdatetime(now(),2)& formatdatetime(now(),3)

'# Insert the ID card
Response.Write " <li>Inserting ID Card " & myLocalArr(12) & "...<br>"
Conn.execute "insert into IDC (IDC_ID, CardNumber, Type, DateIssued,
IssuingNLC, ExpiryDate, CreationEditDate, IsQwizz ) values ('" & szIDCID &
"','" & replace(myLocalArr(64), " ", "" ) & "','PIDC','" & REPLACE(
myLocalArr(65), "-", "/" ) & "','0000','','" & formatdatetime(now(),2) &
"',-1 )"

'# Create the Ind_tic_idc record with null ticket ref
Conn.execute "insert into Ind_Tic_IDC ( Individual_ID, Ticket_ID, IDC_ID )
values ('" & szIndividualID & "','NULL','" & szIDCID & "')"

'# Create the Ind_tic_idc record with ticket ref
Conn.execute "insert into Ind_Tic_IDC ( Individual_ID, Ticket_ID, IDC_ID )
values ('" & szIndividualID & "','" & szGlobalTic_ID & "','" & szIDCID &
"')"

'Update Audit Trail
conn.execute "insert into AuditTrail
(User_ID,NLC_ID,Operation,CreationEditDate) values ('QJ_USER','Q" &
myLocalArr(13) & "','Create IDCARD " & szIDCID & "','" & formatdatetime(
now(), 2 ) & " " & formatdatetime( now(), 3 ) & "')"

end sub

As you can see, pretty straight forward.
It seems to stop the service about 50% of the time its run.
Can anyone shed any light.

Thanks
Stewert

 >> Stay informed about: ASP CODE IS STOPPING IIS SERVICE DEAD 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Permission Denied using MS code - I used the following code from MSDN. Set objMail = CreateObject("CDONTS.Newmail") objMail.From = "rob@here.com" objMail.To = "jdr@there.com" objMail.Subject = "Bad News" objMail.Body = "I owe you 50" obj...

Error code 59 ( W3SVC failed ) - I cannot connect to my server using Internet explorer. The server I am trying to connect to has the error codes 59 and 36? I am trying to configure print services on the server and need to browse to them through IE .. If you know of a fix for this....

SMTP Return Code Definitions - Where is the list of SMTP return code defintions that I can use to understand the SMTP logfile entries in c:\winnt\system32\logfiles ? -- Thank you, Dan Sikorsky MSCS, BSCE, BAB

Looking for solution to IISSYNC error code 53 - Please help if you can :> Scenario: Two identical Compaq Proliant DL380 G3 servers running Win2K Adv. server. Network Load Balancing is configured for public (Intranet) network and private network is configured for cluster state awareness (10.1.1...

Web service num er mapping - I am required by my company to zip the IIS logs stored on e:\logs\w3svc[n]\exyymmdd.log on a regular basis. Writing a script to do this is trivial. However, the part I am finding non trivial is how do I map from the w3svc[n] to web addresses. VBscript is...
   Web Hosting and Web Master Forums (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]