title: VBScript and SQL Server 2008 Questions
body: <p>So I don't know much about SQL or VBScript, much less putting the two together.</p>
  
  <p>I'm trying to connect to a SQL Server running SQL 2008.  All I want to do is connect and I can't seem to do it.  I keep getting various errors, including:</p>
  
  <ul>
  <li>"Data source name not found and no default driver specified"</li>
  <li>"Login failed for user 'user'"</li>
  <li>"Invalid character"</li>
  </ul>
  
  <p>I already know about <a href="http://www.connectionstrings.com" rel="nofollow noreferrer">http://www.connectionstrings.com</a> but I don't know what a number of things mean.  What is a Data Source?  What is an Initial Catalog?</p>
  
  <p>Here is what I have so far.</p>
  
  <pre><code>Dim result
  Set cn = CreateObject("ADODB.Connection")
  cn.ConnectionString = "Provider=SQLOLEDB.1;Server=MyIP;Database=SQLDatabase;User ID=user;Password=pass"
  cn.Open
  strQry = "select * from Users"
  set result = cn.execute(strQry)
  </code></pre>
  
  <p>Can someone help me make heads and tails of this?</p>
  
  <p>Edit 1: This is what I am seeing in the Server Configuration Manager; </p>
  
  <p><img src="https://i.stack.imgur.com/FHEq4.png" alt="enter image description here"></p>
  
  <p>Edit 2:  I apologize for not making this clear.  I am not connecting to the local machine.  I am connecting to a machine on my network.</p>