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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
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.
