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, 8:20 PM
> Fred,
> 
> Have you checked the permissions on the extensions to make
> sure that the
> process running your site has access? Since you're able
> to call the
> function, I don't think this is the problem, but
> I'm running out of
> ideas. Also, are you seeing anything in SQL Server's
> error log or the
> event log, which might be helpful?  You have SQL Server
> Native Client
> installed? I assume you've quadruple-checked the
> credentials?
> 
> A-
> 
> -----Original Message-----
> From: Fred Silsbee [mailto:[email protected]] 
> Sent: Tuesday, December 09, 2008 1:39 PM
> To: Fortuno, Adam
> Cc: [email protected]
> Subject: 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


permissions sound viable...problem is that the only way I see permissions can be set is on directories

Problem put on MSDN forum if you are interested:

http://forums.microsoft.com/forums/ShowPost.aspx?PostID=4227666&SiteID=1