<div>
Are you on a Windows web server? &nbsp;The 'SQLSRV' drivers only work on Windows. &nbsp;And yes, if you are on a Windows server, the 'sqlsrv' drivers need to be included in your 'php.ini' file and they have to exist in your 'ext' directory.
</div>


<div>
I am on a windows server.<br />
when I first tried the migration, I got the error PDO driver missing. I downloaded the driver, and put it in my .ini file.<br />
Then the migration worked.<br />
Now when I try to select to the database from Laravel website itself, the website it now telling me PDO driver missing.<br />
Is it possible that my laravel is pointing to a different .ini file and how would I figure that out?
</div>


<div>
Run 'phpinfo()' to see where PHP is finding it's 'php.ini'. &nbsp;In the 'sqlsrv' drivers, they must match the version of PHP that you are running and they must be the 'nts' versions to use with IIS.
</div>


<div>
Yes my driver matched my php version.<br />
I am trying to pinpoint why migration worked, but my site doesn't
</div>


<div>
Probably the 'migration' just moved files but doesn't check for prerequisites. &nbsp;For 'sqlsrv', if your MS SQL database server is on another machine, you also need to install the SQL Native Client for that version of SQL Server. &nbsp;SQL Native Client is not part of the 'sqlsrv' driver but it is required for it to operate.
</div>


<div>
my migration was able to create a table on the sql database. So it was able to connect.<br />
and i set up the php.ini file properly with the driver ( I think).<br />
So what else can I check?
</div>


<div>
What is your exact error message?
</div>


<div>
Look in your extensions directory for something like 'php_pdo_sqlsrv_56_nts_vc9<wbr />.dll'.
</div>


<div>
This is the closest one that I have.<br />
php_pdo_sqlsrv_56_ts.dll
</div>


<div>
That would be for Apache. &nbsp;If you are on IIS, you need the 'nts' version.
</div>


<div>
My local computer is apache, I am trying to connect to a windows server sql
</div>


<div>
<div class="content wysiwyg-content">
I am trying out laravel with MSSQL for the first time.<br />
I installed the neccessary 'SQLSRV' drivers.<br />
<br />
I was able to use migration to create a new table to my database.<br />
Then when i am trying to select , I am getting a laravel error, PDO missing driver.<br />
<br />
is there a different php.ini setting for my laravel site vs the artisan migration?
</div>
</div>


I am trying out laravel with MSSQL for the first time.
I installed the neccessary 'SQLSRV' drivers.

I was able to use migration to create a new table to my database.
Then when i am trying to select , I am getting a laravel error, PDO missing driver.

is there a different php.ini setting for my laravel site vs the artisan migration?

Laravel PDO missing driver on site but not with migration

Laravel is a free, open-source PHP web application framework for the development of web applications following the model–view–controller (MVC) architectural pattern. Some of the features of Laravel are a modular packaging system with a dedicated dependency manager, different ways for accessing relational databases, utilities that aid in application deployment and maintenance, and its orientation toward syntactic sugar. Laravel is regarded as one of the most popular PHP frameworks.

Laravel

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.