Can someone please let me know where I can find information on how to set up my ASP pages and other technical information on how the authentication works with the Update Service? I understand how to set up the Service to authenticate a user, but I cannot find any information on what information will be passed to my asp page. Thanks in advance.
The following example is from our help docs under the topic: Process an authentication query
Does this give you what you need?
--------- The following ASP script example receives the values UserName and Password, checks them against an SQL database, and responds to the Update Service's query accordingly.
<% Dim adoRS 'ADODB.Recordset Dim objConn 'Connection Dim sql 'SQL Query
Set objConn = Server.CreateObject("ADODB.Connection")
sql = "select UserName, Password , StartDate, ExpiryDate from UserDatabase db where db.UserName='" & Request("UserName") & "' AND db.Password = '" & Request("Password") & "' AND GETDATE() between db.StartDate and db.ExpiryDate" ' Set up the connection objConn.Open "USERDB", "dbuserid", "dbpassword" Set objRS=objConn.Execute(sql)
If objRS.EOF Then Response.Write "FAILED" ' The following text is written to the Update Service user interface Response.Write "This can happen for any of the following reasons:" & vbCRLF Response.Write "- Incorrect username" & vbCRLF Response.Write "- Incorrect password" & vbCRLF Response.Write "- Your subscription expired" & vbCRLF Else Response.Write "OK" End If %>
