Re: PHP and SQL Server
| From: | Ben | Date: | Wed, 13 Aug 2003 08:36:44 +0000 |
| Subject: | Re: PHP and SQL Server | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-159408@lists.php.net to get a copy of this message | ||
Todd
I use the ODBC drivers to connect a w2k server running PHP to a w2k server running MSSql. It is used
mainly for real time reports on sales etc.
I have had trouble in the past connecting. Downloading & installing MDAC from MS on the php
server helped.
Not much data is transferred, so never really run into performance problems.
$db = "odbbcname";
$cx=odbc_connect($db,'sa','password');
$sql = "select * from table";
$cur=odbc_exec($cx,$sql);
while(odbc_fetch_row($cur)){
$rep=odbc_result($cur,1);
}
"Todd Cary" <todd@aristesoftware.com> wrote in message news:3F3967CF.80704@aristesoftware.com...
I have a client that insists that I use SQL Server as the DB (vs. MySQL or Interbase). I have not
used PHP's ODBC interface and I am wondering if anyone on this list has had experience with
ODBC and SQL Server.