title: Trying to Connect to SQL Server with DSN for Classic ASP Connection
body: <p>I currently have a connection page that connects to access db. I have been trying to figure how to get it to connect to SQL instead. The code is also written in VBScript. I tried different combinations but I have had no luck so far.</p>
  
  <p>connection page</p>
  
  <pre><code> &lt;%
     Dim objConn
     Session.Timeout=15
     Set objConn=Server.CreateObject("ADODB.Connection")
     objConn.ConnectionString="DSN=STAFFING"
     objConn.Open 
     %&gt; 
  </code></pre>
  
  <p>This is what I have tried so far.</p>
  
  <pre><code>   &lt;%
     Dim objConn
     Session.Timeout=15
     Set objConn=Server.CreateObject("ADODB.Connection")
     objConn.ConnectionString="DSN=servername;Initial Catalog=staffing;Integrated Security=True"
     objConn.Open 
     %&gt;
  </code></pre>