Check out the LimeSurvey source code on GitHub!

Using MSSQL with limesurvey

More
5 years 8 months ago #62070 by wabrit
Having successfully used limesurvey 1.91 with xampp and mysql, I need to be able to switch to using MSSQL 2008 R2 on a Windows 7 machine.

I've downloaded the Microsoft SQL Server php drivers from here and have run phpinfo to confirm xampp is running PHP 5.3.5 compiled with VC++ 6.

I've copied the php_pdo_sqlsrv_53_ts_vc6.dll and php_sqlsrv_53_ts_vc6.dll driver files into ${XAMPP_HOME}/php/ext and have set
$databasetype = mssqlnative

in ${XAMPP_HOME}\htdocs\limesurvey\config.php

However when I navigate to http://localhost/limesurvey/admin/install I'm getting the error message:
mssqlnative extension not installed

As I'm a newbie to php I suspect I've done something wrong or omitted something, but I'd be very grateful if anyone could offer some helpful advice.

Please Log in to join the conversation.

More
5 years 8 months ago #62077 by wabrit
I knew it would be something basic :)

Just in case anyone has the same problem, what I needed to do to get it working was:

  • Ensure just php_sqlsrv_53_ts_vc6.dll is copied into ${XAMPP_HOME}\php\ext
  • Add the line extension=php_sqlsrv_53_ts_vc6.dll to ${XAMPP_HOME}\php\php.ini
  • Restart the server

Please Log in to join the conversation.

More
4 years 10 months ago #78982 by kirs10
Hi,
I'm having this problem too and have tried installing the php drivers that you link to (though mine didn't include "php_sqlsrv_53_ts_vc6.dll"). I followed the instructions for the php drivers, which are just like yours...to add "extension=..." to the php.ini file. It said to restart the server. I used the xampp control panel to stop and start the server but it wouldn't start back up. I followed some directions on the web to install vc++ (not sure which version)...and I think I did that right, but the server wouldn't start back up. I restarted the computer and still no go.

I ended up commenting those new dll extensions that I added to the php.ini file and then the apache server started right away. No matter what combination of those extensions uncommented, it wouldn't start. (if you want to know what my dlls are, let me know.)

Any ideas? I'm certainly new to all of this, but with enough detail, I hope to follow any recommendations!

Thanks!

Please Log in to join the conversation.

More
4 years 10 months ago - 4 years 10 months ago #79014 by Mazi
Please note that this is no Limesurvey related problem. You might get more help at the XAMPP forums...

It's possible that you are using the wrong driver, e.g. there might be different drivers for 32 bit and 64 bit operating systems.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"
Last Edit: 4 years 10 months ago by Mazi.

Please Log in to join the conversation.

More
4 years 10 months ago #79030 by kirs10
Thanks a lot! I'll check there next.

I see files with '86' or '64' in their filenames. Which would I download for a 32 bit OS? I always pick the 86 one, but don't know why. Can you shed any light on that?

Thanks!

Please Log in to join the conversation.

More
4 years 10 months ago #79034 by Mazi
Usually 86 is the common 32 bit architecture while 64 refers to 64 bit systems.
I don't know which driver you need to choose, so better ask this question at an MS SQL forum.


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form