title: How to write connection string to connect from classic ASP page to SQL 2008 R2?
body: <p>I connect from classic ASP page to SQL SERVER 2008 R2 with following connection string</p>
  
  <p><code>"Data Source=(local);Initial Catalog=my_db;Persist Security Info=True;User ID=my_user;Password=my_pass;"</code></p>
  
  <p>but I get error </p>
  
  <p><code>Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified</code></p>
  
  <p>I verified that <code>my_db</code> exists!, so what is wrong in my connection string?</p>