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

--- On Mon, 12/8/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: Monday, December 8, 2008, 10:56 PM
> Fred,
> 
> Hmm, that makes me think the extension didn't load.
> When you fire up a
> page with <?php php_info(); ?> do you see the
> module's information?
> 
> If it makes you feel any better, I'm working thru
> integration with
> Oracle, and I'm not fairing too much better.
> 
> A-
> 
> -----Original Message-----
> From: Fred Silsbee [mailto:[email protected]] 
> Sent: Monday, December 08, 2008 5:53 PM
> To: Fortuno, Adam
> Subject: RE: [PHP-DB] Re: MS SQL error...I've come a
> long way to get
> this far
> 
> 
> 
> 
> --- On Mon, 12/8/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], [email protected]
> > Date: Monday, December 8, 2008, 9:26 PM
> > Fred,
> > 
> > If you're using integrated security (e.g., a
> domain
> > account such as
> > "domain\bob"), you won't supply a
> > password. However, the "sa" account is
> > a SQL login (v.s. a domain login). In that case, it
> would
> > make sense
> > that you supply a password. See the following page for
> some
> > code to
> > connect using integrated security:
> > 
> >
> http://msdn.microsoft.com/en-us/library/cc296205(SQL.90).aspx
> > 
> > See the following page for some code to connect using
> a SQL
> > login:
> > 
> >
> http://msdn.microsoft.com/en-us/library/cc296182(SQL.90).aspx
> > 
> > If you're curious if this is even an
> > authentication/permissions issue,
> > try to login using a domain login. The login event
> will be
> > recorded in
> > the `Event Viewer`. If you're attempt isn't
> > recorded, you've got a
> > communication problem with the server instance. If it
> is
> > recorded,
> > you'll be able to tell what the problem is
> > authenticating.
> > 
> > Good luck, and let us know how it turns out.
> > 
> > A-
> > 
> > 
> > -----Original Message-----
> > From: Fred Silsbee [mailto:[email protected]] 
> > Sent: Monday, December 08, 2008 3:30 PM
> > To: [email protected]
> > Subject: [PHP-DB] Re: MS SQL error...I've come a
> long
> > way to get this
> > far
> > 
> > I was just thinking about something I've never
> > understood completely!
> > 
> > mssql_connect($server, 'sa', 'PW');
> > presumes the server doesn't have all
> > the permissions in spite of the fact that it has the
> > password.
> > 
> > The password I gave is the XP Prof login PW.
> > 
> > Maybe some other PW. 
> > 
> > 
> > --- On Mon, 12/8/08, Fred Silsbee
> > <[email protected]> wrote:
> > 
> > > From: Fred Silsbee <[email protected]>
> > > Subject: MS SQL error...I've come a long way
> to
> > get this far
> > > To: [email protected]
> > > Date: Monday, December 8, 2008, 7:13 PM
> > > many changes to php.ini to get this far..whew!
> > > 
> > > PHP 5.2.7 just got jerked out from underneathe me
> (I
> > > have't replaced it since this is a simple
> script)
> > > 
> > > phpinfo works!
> > > 
> > > <?php
> > > // Server in the this format:
> > > <computer>\<instance name> or 
> > > // <server>,<port> when using a non
> > default
> > > port number
> > > $server = 'LANDON\SQLEXPRESS';
> > > 
> > > $link = mssql_connect($server, 'sa',
> > 'PW');
> > >   <<<<< line 6
> > > 
> > > if(!$link)
> > > {
> > >     die('Something went wrong while
> connecting to
> > > MSSQL');
> > > }
> > > ?>
> > > 
> > > 
> > > Warning: mssql_connect()
> [function.mssql-connect]:
> > Unable
> > > to connect to server: LANDON\SQLEXPRESS in
> > > C:\Inetpub\wwwroot\trymssql.php on
> line 6
> > > Something went wrong while connecting to MSSQL
> > 
> > 
> >       
> > 
> > 
> > -- 
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 
> thanks!
> 
> using the integrated server login code (first link you
> included, I get:
> 
> Fatal error: Call to undefined function sqlsrv_connect() in
> C:\Inetpub\wwwroot\trymssql_1.php on line 7
> 
> still banging away


integration with Oracle...Linux or Windows?

I've got the Linux Oracle 11g1/PHP 5.2.6/ and MySQL connection down...I can email working code.

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

$link = mssql_connect($server, 'sa', 'K^a_t^e_a_u_x_3141');

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


I get



Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: LANDON\SQLEXPRESS in C:\Inetpub\wwwroot\trymssql.php on line 6
Something went wrong while connecting to MSSQL