Hello everyone,
I’m trying to let Dolibarr work with a MSSQL server but I’m stuck.
Did anyone make it work already ? In the map:
dolibarr-3.1.0\htdocs\lib\databases I’ve found the file mssql.lib.php but I didn’t manage to let i work.
Can anyone help me with this issue ?
Thanks !!!
The support was started but was never tested. So it certainly not works i’m afraid.
Sorry, but for the moment a “working support” with mssql is not planned but if someone can help for this works, it is welcome.
Just curious, why do you want Dolibarr running off an MSSQL Server in stead of Mysql?
I do have some experience with running a PHP application off an MSSQL database, but will need some more Dolibarr experience to be able to help you out even a little bit.
Can someone Please guide me which file to edit in order to activate this MSSQL 2019, because I just want to know how is Dolibarr running on MSSQL 2019, only for Testing Purposes.
Thank you Mr. Eldy
Support of MSSQL is not working. There is no way to enable it. It will probably be abandoned. It becomes very difficult to find people using this old database nowday (even if name is MSSQL 2019) and native driver has been abandoned in PHP itself.
First of All it has been two years, this Dolibarr with MySQL the problem about MYSQL , it is very slow, Unlike that Microsoft SQL so fast.
Dolibarr that is Install used Apache2.4.41, mySQL
I tested this on PHP e-Commerce, opensource the same config with dolibarr and it was working because of the driver, they used the following driver:
It says release 29th January 2021
Thank you.
hi dear I have a same project and I want to use MSSQL 2019 with Dolibar can I share with the different steps of installation please
Thanks
hello Sir, does it works?
it will never work, PHP and MSSQL is a hard process.
But on you previous post you saw it worked,right
Yeah but not stable, I mean you need to use the old SQL 2012 then too many conflict
Any php platform, it is so hard to use the MS SQL but with java platform they are so compatible.
Well, it is obvious that Dolibarr is php platform so let it run with mariaDB or MySQL, running on MS SQL you need to change the whole stucture of programming of Dolibarr. It is not that simple as what you and me thought. But I tried too many times Java Flatform with ms sql they are running smoothly. I tried it on e-commerce. Yeah but I am already used to run Dolibarr with mariaDB it is okay. Because for all the ERP Open Source I implemented still the best is dolibarr, yes there are some glitches but it is so manageable.
To have Dolibarr compatible with anyother sql platform, there is only one file to change (the db driver), like it was done to support postgresql. However because mssql is not an open source software, it is not possible to validate and keep testing environment for it, also the number of users was very low so there driver for mssql was abandonned a very long time ago (too few people were using mssql compared to other available database and no developer was interesting in maintaining it)
