MSSQL issues with XAMPP 1.7.1? (Win7 Pro) [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MSSQL issues with XAMPP 1.7.1? (Win7 Pro) [SOLVED]

Postby sinerasis » 14. November 2011 19:27

Using:
XAMPP 1.7.1
Windows 7 Pro 64 bit

I'm having issues with a reference to MSSQL (I don't personally use MSSQL, but it's part of an app I do work on).

We've got an include file that sets up the connection, which causes a fatal error:
Call to undefined function sqlsrv_connect()

Doing a little searching it seems that the dll's aren't being loaded correctly by PHP. I've checked php.ini and haven't found anything obviously wrong. I've never edited default options set by XAMPP install to my knowledge.

I do not have mssql listed in the available PHP streams section of phpinfo().

lil help? Anyone know of some problem areas I should check out? I'm about to do a full re-install, but I have my doubts it'll fix anything as I'm pretty sure I've never messed with those settings anyway. FYI I need to use this older version of XAMPP because our live environment is stuck at PHP 5.2.9 because of some third party stuff... unfortunate I know.
sinerasis
 
Posts: 3
Joined: 14. November 2011 19:16
Operating System: MS Win 7 Pro

Re: MSSQL issues with XAMPP 1.7.1?

Postby JonB » 14. November 2011 19:31

it might be very useful to know WHAT dll's are not loading - (as I can't seem to channel Mr. Spock this AM) :)

BTW - DLL's have to be Apache compiler and PHP major version matched.

8)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: MSSQL issues with XAMPP 1.7.1?

Postby sinerasis » 14. November 2011 19:40

I'm not normally messing around with these kind of settings, so please excuse my green-ness...

This appears to be a similar problem:

http://social.msdn.microsoft.com/Forums/en/ssdsgetstarted/thread/5fa1215f-5104-40f3-ac5c-872c4812f416

I don't have sqlsvr in registered PHP streams.

I'm using the dll's that came packaged with XAMPP as far as I know, so they should be the correct version for PHP correct? From the PHP documentation, it would appear php_mssql.dll handles the MSSQL functions.
sinerasis
 
Posts: 3
Joined: 14. November 2011 19:16
Operating System: MS Win 7 Pro

Re: MSSQL issues with XAMPP 1.7.1?

Postby sinerasis » 14. November 2011 22:06

Apparently for my environment the bundled version does not work.

To fix my problem, I had to download another version from Microsoft. All is well now.

Here's the fix (for my scenario):
http://msdn.microsoft.com/en-us/library/cc793139(v=sql.90).aspx
sinerasis
 
Posts: 3
Joined: 14. November 2011 19:16
Operating System: MS Win 7 Pro

Re: MSSQL issues with XAMPP 1.7.1?

Postby Sharley » 14. November 2011 22:39

Thanks for the feedback. 8)

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 49 guests