--- 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: php-db@lists.php.net
> 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 = '[EMAIL PROTECTED]';
> >
> > $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
