RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far

--- On Tue, 12/9/08, Fortuno, Adam <[email protected]> wrote:

> From: Fortuno, Adam <[email protected]>
> Subject: RE: [PHP-DB] Re: MS SQL error...I've come a long way to get this far
> To: [email protected]
> Date: Tuesday, December 9, 2008, 5:14 PM
> Sorry! I've been swamped today, and I needed to install
> the PHP module
> for SQL Server before I could respond.
> 
> Fred> integration with Oracle...Linux or Windows?
> Fred> I've got the Linux Oracle 11g1/PHP 5.2.6/ and
> MySQL 
> Fred> connection down...I can email working code.
> 
> Windows. I'm running PHP (in ISAPI mode) on IIS
> integrating with a 9i
> instance on a RedHat box.
> 
> Fred> When I run :
> Fred> <?php
> Fred> // Server in the this format:
> <computer>\<instance name> or 
> Fred> // <server>,<port> when using a non
> default port number
> Fred> $server = 'LANDON\SQLEXPRESS';
> Fred>
> Fred> $link = mssql_connect($server, 'sa',
> 'K^a_t^e_a_u_x_3141');
> Fred>
> Fred> if(!$link)
> Fred> {
> Fred>     die('Something went wrong while connecting
> to MSSQL');
> Fred> }
> Fred>?>
> Fred>
> Fred> I get
> Fred>
> Fred> Warning: mssql_connect() [function.mssql-connect]:
> Unable to
> connect 
> Fred> to server: LANDON\SQLEXPRESS in
> C:\Inetpub\wwwroot\trymssql.php on
> 
> Fred> line 6 Something went wrong while connecting to
> MSSQL
> 
> I installed the PHP module for SQL Server 2005 this
> morning, and I
> updated my php.ini file then restarted IIS. I dumped the
> following into
> a page, and I ran it.
> 
> $server = 'Babylon';
> $uid = 'UserName';
> $pwd = 'FooB@r';
> 
> $connectionInfo = array("UID" => $uid,
> "PWD" => $pwd);
> $link = sqlsrv_connect($server, $connectionInfo);
> 
> if(!$link)
> {
> 	die('Something went wrong while connecting to
> MSSQL');
> }
> 
> It worked without a problem. I downloaded whatever B.S.
> module Microsoft
> had on their site, and here is what I added to my ini:
> 
> My php.ini file includes:
> 
> [SQL_Server_2005]
> extension=php_sqlsrv_ts.dll
> 
> I'm trying a different function than you did. Give my
> script a try.
> 
> A-


I've truly gotten lots of help from this "forum/list"

I tried the following and got:Something went wrong while connecting to MSSQL


<?php
// Server in the this format: <computer>\<instance name> or 
// <server>,<port> when using a non default port number
$server = 'LANDON\SQLEXPRESS';

//$server = '(local)\sqlexpress';
// $server = 'Babylon';
$uid = 'sa';
$pwd = 'xyxyxyxyx';

$connectionInfo = array("UID" => $uid, "PWD" => $pwd);
$link = sqlsrv_connect($server, $connectionInfo);

if(!$link)
{
    die('Something went wrong while connecting to MSSQL');
}

?>


I only have the 2nd statement of your:

[SQL_Server_2005]
extension=php_sqlsrv_ts.dll

I'll try anything at this point!  thanks again!

I have added to my path both directories where I downloaded PHP files