--- On Mon, 12/8/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: 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:fredsilsbee@xxxxxxxxx] > Sent: Monday, December 08, 2008 5:53 PM > To: Fortuno, Adam > Subject: RE: Re: MS SQL error...I've come a > long way to get > this far > > > > > --- On Mon, 12/8/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, php-db@xxxxxxxxxxxxx > > 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:fredsilsbee@xxxxxxxxx] > > Sent: Monday, December 08, 2008 3:30 PM > > To: php-db@xxxxxxxxxxxxx > > Subject: 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 > > <fredsilsbee@xxxxxxxxx> wrote: > > > > > From: Fred Silsbee <fredsilsbee@xxxxxxxxx> > > > Subject: MS SQL error...I've come a long way > to > > get this far > > > To: php-db@xxxxxxxxxxxxx > > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
