title: How to connect from symfony to SQL Azure database?
body: <p>I'm having problems connecting Symfony 1.4 with a SQL Azure database.</p>
  
  <p>How to configure databases.yml?</p>
  
  <p>I tried:</p>
  
  <pre><code>#databases.yml
  all:
    doctrine:
      class: sfDoctrineDatabase
        #option1
        dsn: sqlsrv:server=tcp:c0yb8ju4aa.database.windows.net,1433;Database=neurodb
  
        #option2
        dsn: odbc:DRIVER={SQL Server};Server=c0yb8ju4aa.database.windows.net;Database=neurodb
  
        #option3
        dsn: odbc:Driver={SQL Server Native Client 10.0};Server=tcp:c0yb8ju4aa.database.windows.net,1433;Database=neurodb;Uid=neurodb@c0yb8ju4aa;Pwd=mypass;Encrypt=yes;Connection Timeout=30;
  
        username: neurodb@c0yb8ju4aa
        password: mypass
  </code></pre>
  
  <p>Option1 says: </p>
  
  <pre><code>Unknown driver sqlsrv
  </code></pre>
  
  <p>Option2 and Option3 says: </p>
  
  <pre><code>Couldn't locate driver named odbc
  </code></pre>
  
  <p>Symfony web app is located in an "Azure Website"</p>
  
  <p>Which is the correct way to connect my web app to the database?</p>