Getting PHP on Windows to talk to MS SQL?

From: Date: Fri, 23 Jul 2004 07:15:11 +0000
Subject: Getting PHP on Windows to talk to MS SQL?
Groups: php.general 
Request: Send a blank email to php-general+get-191610@lists.php.net to get a copy of this message
I'm trying to get PHP (for Windows) to talk to MS SQL Server. This is proving to be non-trivial... I downloaded and installed the Windows binary package on my machine (the machine is running Microsfot Windows XP Professional), and jumped through the hoops to get it running under Apache 2.0. So far, so good. Now, the first thing I noted was that the mssql functions actually don't seem to exist in the binary... and apparently you have to compile them in to PHP, after having built FreeTDS. This seems a bit odd, as it's not at all clear to me that FreeTDS actually will build under Windows at all (it being a UNIX solution). I did try building it under cygwin, which ended with a flurry of error messages in bsqldb.c, so this assumption seems correct. All right, approach #2... maybe I can use COM objects to try to connect to an ODBC data source, something like an example I found on the php documentation for mssql: $db = new COM("ADODB.Connection"); $dsn = "DRIVER=SQL Server; SERVER=my.local.server;UID=user;PWD=passwd; DATABASE=dbname"; $db->Open($dsn); $rs = $db->Execute("SELECT * FROM project LIMIT 1"); while (!$rs->EOF) { echo $rs->Fields['project_id']->Value."<BR>"; $rs->MoveNext(); } This seems to at least kick up no errors up to a point... and that point is when I try to wind through that loop. Any ideas what the right best way to do this is? I'd prefer to use the mssql functions if I can... Thanks, Weston

« previous php.general (#191610) next »