Laravel Filament in SQL SERVER : Error [Missing parameter: record]

retinqdon — Sun, 15 May 2022 16:02:22 +0000

I installed Laravel Filament and followed some tutorials. Then I tried it using sql server. I already have my database table but when I create a filament resource and click the menu then I encounter this error :
So the first thing I do is to google for this error. But it seems that no one has encountered it yet. So I tried to solve it on my own. What I found out is that filament is looking for an id in the table with small i while I use capital I.
This is my table:

So I changed the Id in my table into id, like this :

and the error goes away.

Hope this helps.

Thanks guys.

Setting up Laravel with SQL Server AND Laragon on Windows

retinqdon — Sat, 14 May 2022 16:26:39 +0000

I just want to share how I connect my laravel project with sqlserver.

I assume that you already have Laragon and SQL Server in your local system.

Step 1. Download the PHP driver here

Go to the bottom of the page then download windows-8.1.zip (since I'm using PHP 8.1
Extract the zip file to a folder, then go to folder named x64, you will see the following dll
Then copy these dll to your php folder inside the laragon folder, mine is C:\laragon\bin\php\php-8.1.5-nts-Win32-vs16-x64\ext
Then Edit your php.ini, add the extension
Then restart your laragon server

Step 2. Make a new laravel app using laragon quick app menu

Then we need to update the .env file ```

DB_CONNECTION=sqlsrv
DB_HOST=127.0.0.1
DB_PORT=1433
DB_DATABASE=lara-sqlserver
DB_USERNAME= sa
DB_PASSWORD= 12345678

  * Next, create the database in sql management studio, mine is lara-sqlserver
  * Before running the migration, make sure to enable tcp-ip in sql configuration manager
   ![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/opikbte4ce6kxwgqvbl5.png)

  * then run the migration

 php artisan migrate

  * if everything works fine you should see this in your terminal
     ![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iyhnoaaphswfoqss9zml.png)

**Thanks guys!**

DEV Community: retinqdon

Laravel Filament in SQL SERVER : Error [Missing parameter: record]

Setting up Laravel with SQL Server AND Laragon on Windows