title: classic asp connection
body: <p>How would you go about getting user input for a connection over different webpages. Would this be done with session variables or is there another way. I dont want to have to set up connections on every webpage, can someone point me in the right direction what to do some research into.</p>
  
  <p>Here is a bit of code from a site that does not have any connection strings at all on the web site.</p>
  
  <pre><code>obj_ADO.ClearParameters
  lng_RecSet1 = obj_ADO.GetFreeRecordset
  obj_ADO.Recordset "A_combo_Permissions_select", adCmdStoredProc, obj_Session.int_CommandTimeout, lng_RecSet1
  while obj_ADO.EOF(lng_RecSet1) = 0
  </code></pre>
  
  <p>and</p>
  
  <p>if str_Action = obj_Session.str_FileName or len(str_Action)=0 or str_Action = str_SwitchLangText then</p>
  
  <pre><code>obj_ADO.ClearParameters
  obj_ADO.AddParameter "SessionID", adChar, adParamInput, len(obj_Session.str_SessionID), obj_Session.str_SessionID
  obj_ADO.AddParameter "PermissionID", adInteger, adParamInput, 8, lng_PermissionID
  lng_RecSet = obj_ADO.GetFreeRecordset
  obj_ADO.Recordset "A_PagePermissions_select", adCmdStoredProc, obj_Session.int_CommandTimeout, lng_RecSet
  </code></pre>