I’m running Windows 7 x64 and am having trouble using the PHP library supplied by Microsoft for SQL Server. Whenever I try to connect to the SQL database I get a message that indicates I need the ODBC driver installed. I have Visual Studio 2008 & 2010 RC installed, so I guessed, rightly, that the driver simply isn’t configured. After configuring the driver as a data source I’m still getting the same message. I suspect that either the driver is not configured correctly, or that the PHP Library for SQL Server is not 64 bit compatible.
This would not be the first time I’ve encountered database libraries not compatible with x64, SQL CE and SQL Lite had to be installed in XP Mode Virtual PC before they would work.
Anyone with any insight on how to get the library working? I love ASP.NET but want to branch out a little and don’t want to have another database server on my machine.