|
|
Posted by J.O. Aho on 02/25/07 12:18
Todd Michels wrote:
> Hi All,
>
> I am trying to collect info from a MSSQL DB and I am not even able to
> get passed the connection. I don't get any errors I just get a blank
> page when I go to the site.
>
> PHP is working, see attached phpinfo(). Any help is appreciated.
>
> Windows XP SP2, IIS 5.1, PHP 5.2.1, MSSQL Server Express Edition
>
>
>
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
>
> <?php
> $con=mssql_connect("serverName\sqlexpress","username","password");
>
> if ($con)
> $conStatus="It connnected";
> else
> $conStatus "didn't work";
>
> mssql_close($con);
> ?>
>
> <title>Test PHP MSSQL</title>
>
> </head>
>
> <body>
>
> <?php echo $conStatus; ?>
>
> </body>
>
> </html>
I suggest you look a little bit at the user comments at
http://www.php.net/manual/en/function.mssql-connect.php
it seems like there are differences depending on the version of mssql.
You could try to use
$con=mssql_connect("localhost,1433","username","password");
--
//Aho
Navigation:
[Reply to this message]
|