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-


THANKS!!!! I'll try it

I downloaded the adventure works .msi file and successfully installed it but found no new tables in my SQL SERVER 2005.

This is from Microsoft:
<?php
/* Specify the server and connection string attributes. */
$serverName = "(local)";
$connectionInfo = array( "Database"=>"AdventureWorks");

/* Connect using Windows Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false )
{
     echo "Unable to connect.</br>";
     die( print_r( sqlsrv_errors(), true));
}

/* Query SQL Server for the login of the user accessing the
database. */
$tsql = "SELECT CONVERT(varchar(32), SUSER_SNAME())";
$stmt = sqlsrv_query( $conn, $tsql);
if( $stmt === false )
{
     echo "Error in executing query.</br>";
     die( print_r( sqlsrv_errors(), true));
}

/* Retrieve and display the results of the query. */
$row = sqlsrv_fetch_array($stmt);
echo "User login: ".$row[0]."</br>";

/* Free statement and connection resources. */
sqlsrv_free_stmt( $stmt);
sqlsrv_close( $conn);
?>