prasan_3105 wrote: MS SQLSERVER 2012 SP3 collation Latin1_General_CI_AS
OK, you got a OracleLinux 6, Apache, PHP server with Limesurvey installed and a dedicated MS SQL Server.
If it isn't a specific LimeSurvey bug, I see two areas to investigate.
1.) MSSQL driver for php linux. I'm not using Oracle Linux 6 (it's a derivative of RHEL6).
There are different drivers to connect to SQLServer.
Warning. Don't just use these lines. You may need to adapt them to your environment.
Code:
sudo pecl install sqlsrv pdo_sqlsrv
sudo echo "extension= pdo_sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
sudo echo "extension= sqlsrv.so" >> `php --ini | grep "Loaded Configuration" | sed -e "s|.*:\s*||"`
2.) I would create a new database and install another LimeSurvey LS 3, to see if different issues or no issues occurs. Will speed up things for you. If you got no issue, you can narrow the issue to database/tables and LimeSurvey config.
I still recommend to open a bugticket.
Since I don't use this environment, it is an educated guess.