Re: PHP and MSSQL problem
| From: | Peter Misun | Date: | Fri, 09 May 2003 12:01:11 +0000 |
| Subject: | Re: PHP and MSSQL problem | ||
| References: | 1 2 3 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-19829@lists.php.net to get a copy of this message | ||
under w2k with installed IIS 5.0 and installed PHP 4.1.3 and MS SQL 7:
create odbc "data source" for your database (Administrative tools->ODBC -> under
system DSN->add->driver SQL server-> ...)
in php script using:
$connection_id=odbc_connect($server,$user,$password);
(where $server is "data source" name, you've created)
and then
$result = odbc_exec($connection_id,$sql_query);
5o
"A. Mikkelsen" wrote:
> How did u get it to work.
>
> //Anders
> "Peter Misun" <misun@microstep-mis.sk> wrote in message
> news:3EBB8FA1.EEC25066@microstep-mis.sk...
> >
> > we use php with IIS
> > and odbc functions works fine :-)
> >
> > but we would like to know how to connect to MSSQL from some linux
> enviroment
> >
> > 5o
> >
> >
> > "A. Mikkelsen" wrote:
> >
> > > Hi
> > >
> > > Does anybody have a working solution for getting php to use a MSSQL DB
> ??
> > >
> > > I have tryed a few things but can't get i to work.
> > >
> > > _____________________________
> > > Anders Mikkelsen
> >
> > --
> >
> > Mgr. Peter Misun
> > MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia
> > tel: +421/ 2/ 602 00 127, 111, fax: +421/ 2/ 602 00 180
> >
> >
--
Mgr. Peter Misun
MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia
tel: +421/ 2/ 602 00 127, 111, fax: +421/ 2/ 602 00 180