Geek Answers Handbook

How to connect opencart with mssql server

Is there any chance of connecting opencart to mssql? Has anyone tried it? If so, what is the procedure for doing this?

enter image description here

+2
source share
1 answer

This should not be a big problem, you only need to do:

  • create /system/database/mssql.php class - the class must have the same methods, properties and functionality, for example. mysql.php one
  • rewrite all model class method queries to match SQL syntax MS SQL / T-SQL
  • in both configuration files ( /config.php and /admin/config.php ) set the correct DB_DRIVER - mssql

I assume that you have an OpenCart database created already because of the /install/opencart.sql file.

I think nothing more needs to be done.

In any case, what is the reason for switching to MS SQL?

EDIT . In /system/database/ there is this mmsql.php file, which actually contains the mssql class, so this does not need to be done, it is simply renamed to mssql.php .

+1
source

More articles:


All Articles