title: ADO Connection String
body: <pre><code>&lt;%'On Error Resume Next     
  Set objConn = Nothing
  Dim strConnect 
  
  strConnect = "Provider=sqloledb;Library=DBMSSOCN;Data Source=xx.xx.xx.xx;1433" 
       "Initial Catalog=mydatabasename;"
       "User Id=userID;Password=password;"
  
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open strConnect
  </code></pre>
  
  <p>I'm coding in Dreamweaver for my website. But somehow it doesnt link to the database. 
  My database in Microsoft SQL server 2008 R2. I've tried all the strings as stated in <a href="http://www.connectionstrings.com/sql-server-2008" rel="nofollow">http://www.connectionstrings.com/sql-server-2008</a>. But doesnt seem to link. </p>
  
  <p>Anything wrong im doing here? Sorry about the bad alignment, im still getting used to stackoverflow's alignment methods</p>