title: Trying to display data from an SQL database using vbscript
body: <p>I am trying to set up a connection to my SQL server inside of a VBScript.</p>
  
  <p>Whenever I have a connection to my SQL server there is an error on the webpage that says "There was a problem processing the URL" and to contact the administrator.</p>
  
  <p>I know my connection string is correct because it works on all the others pages.</p>
  
  <p>Here is the code I am using so far to set up the SQL connection</p>
  
  <pre><code>Const SQL_Connection_String = "Provider=sqloledb;SERVER=SQLPROD;DATABASE=MyDataBase;UID=MyUsername;PWD=MyPassword;"
      Set SQLConnection = CreateObject("ADODB.Connection")
      SQLConnection.provider = "ADODB.Connection"
      Set SQLConnectionRecordSet = CreateObject("ADODB.Recordset")
  </code></pre>
  
  <p>From what I know this should be a valid way of setting up the connection in a VBscript. I have not really found any good documentation on configuring these connections.</p>
  
  <p>What I would like to know is: am I setting up the connection correctly, and Is there some strategy I could use to troubleshoot this? Meaning I'd like to be able to have a print statement that returns true or false if the connection was successful. I would also like to somehow print the contents of my reader to see if it has read from the database and if it read what I wanted it to read.</p>
  
  <p>Thanks for any help. I'm using VBscript and ASP.net for the first time so I don't know any of the subtlties.</p>