title: Connect Doctrine to a MS SQL Database
body: <p>Just before i get started, I have been trying to figure this out and have clicked nearly every google link there is and I have read nearly all the other questions on this. But I'm stuck because the bundles that are being suggested for this are out of date.</p>
  
  <p>I am creating a website. Tt is a symfony2 application that is being hosted on Microsoft azure. What I want to do is be able to use doctrine of course to fetch and create users to and from the database.</p>
  
  <p>Now from what I've been reading, to connect to this type of database, I have to use the driver called "PDO_dblib".</p>
  
  <p>I have installed this bundle as it seems to be the only one thats still active, don't quote me on that. </p>
  
  <p><a href="https://github.com/realestateconz/MssqlBundle" rel="nofollow noreferrer">https://github.com/realestateconz/MssqlBundle</a></p>
  
  <p>Now, I installed this in my vendor folder, is this the correct place to store it? Like so:</p>
  
  <pre><code>Project/
      app/
      src/
      vendor/
         realestate/
  </code></pre>
  
  <p>Of course i added the bundle to the AppKernel like so:</p>
  
  <pre><code> new Realestate\MssqlBundle\RealestateMssqlBundle();
  </code></pre>
  
  <p>and last but not least here is what i have in my config file:</p>
  
  <pre><code> doctrine:
       dbal:
         default_connection:     default
         connections:
             default:
                 driver_class:   Realestate\MssqlBundle\Driver\PDODblib\Driver
                 host:           %database_host%
                 dbname:         %database_prefix%%database_name%
                 user:           %database_user%
                 password:       %database_password%
  </code></pre>
  
  <p>so what im thinking im doing here is telling doctrine to use this driver? dont see what else it could be.</p>
  
  <p>I have also declared my parameters.yml for the connection settings.</p>
  
  <p>PS: I am doing my Dev on Linux Mint!</p>
  
  <p>before i tried the steps of this bundle i also ran throught this websites steps: <a href="https://dunglas.fr/2014/01/connection-to-a-ms-sql-server-from-symfony-doctrine-on-mac-or-linux/" rel="nofollow noreferrer">https://dunglas.fr/2014/01/connection-to-a-ms-sql-server-from-symfony-doctrine-on-mac-or-linux/</a></p>
  
  <p>But again it was throwing errors, I'll post the errors I get down below!
  So for the record I have installed freetds and php5-sybase.</p>
  
  <p>The errors that I am getting are such:</p>
  
  <pre><code> [Symfony\Component\Debug\Exception\ContextErrorException]                                                               
   Warning: class_implements(): Class Realestate\MssqlBundle\Driver\PDODlib\Driver does not exist and could not be loaded
  </code></pre>
  
  <p>and also this when i try to do a:
      php app/console doctrine:database:create</p>
  
  <p>(I do have my entity set up)</p>
  
  <p>but i get the following error from the command of create: </p>
  
  <pre><code> [Symfony\Component\DependencyInjection\Exception\ParameterNotFoundException]                                                 
   You have requested a non-existent parameter "database_prefix". Did you   mean one of these: "database_port", "database_user"?
  </code></pre>
  
  <p>I have been trying to get this working for the past few days and any help would be fantastic! Any more information needed feel free to ask of course!</p>