--- On Tue, 12/9/08, Fortuno, Adam <Adam.Fortuno@xxxxxxxxxxxxx> wrote: > From: Fortuno, Adam <Adam.Fortuno@xxxxxxxxxxxxx> > Subject: RE: Re: MS SQL error...I've come a long way to get this far > To: fredsilsbee@xxxxxxxxx > 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:fredsilsbee@xxxxxxxxx] > Sent: Tuesday, December 09, 2008 1:39 PM > To: Fortuno, Adam > Cc: php-db@xxxxxxxxxxxxx > Subject: RE: Re: MS SQL error...I've come a > long way to get > this far > > --- On Tue, 12/9/08, Fortuno, Adam > <Adam.Fortuno@xxxxxxxxxxxxx> wrote: > > > From: Fortuno, Adam <Adam.Fortuno@xxxxxxxxxxxxx> > > Subject: RE: Re: MS SQL error...I've come > a long way to get > this far > > To: fredsilsbee@xxxxxxxxx > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
