Re: PHP connecting to MSSQL
| From: | Sascha Meyer | Date: | Mon, 30 Mar 2009 13:38:42 +0000 |
| Subject: | Re: PHP connecting to MSSQL | ||
| References: | 1 2 3 4 5 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-29229@lists.php.net to get a copy of this message | ||
Hi Alf,
just a guess, are you using any kind of firewall (application or port based) on your computer? Could
you try a "telnet localhost 1433" to check if this works?
Regarding php.ini changes: have you restarted the web server's services after changing?
Another source for an alternative way to access MSSQL (with FreeTDS):
http://docs.moodle.org/en/Installing_MSSQL_for_PHP
Regards, Sascha
P.S. I guess you probably checked all of the above, but I just think about all possible causes for
this problem.
-------- Original-Nachricht --------
> Datum: Mon, 30 Mar 2009 14:15:41 +0200
> Von: Alf Stockton <alf@stockton.co.za>
> An: Sascha Meyer <harlequin2@gmx.de>
> CC: jmertic@gmail.com, php-windows@lists.php.net
> Betreff: Re: [PHP-WIN] PHP connecting to MSSQL
> Sascha Meyer wrote:
> > Hi Alf,
> >
> > have you checked the comments on the php.net page
> (http://us.php.net/mssql_connect)? These are really helpful when it comes to troubleshooting.
> >
> Yes I have. In fact that was where I got the original code.
> >
> > One setting I remember to have changed in my environment was the
> following php.ini entry:
> >
> > [CODE]
> > mssql.secure_connection=off
> > [/CODE]
> >
> I had previously altered this setting.
> >
> > Could you try to connect to another machine to see if your server is
> able to connect to any MSSQL Servers? If not, have you set your
> error_reporting to E_ALL and display_errors to 1? Have you checked that your mssql
> extension in php.ini has been enabled?
> >
> Yes I can successfully connect to my desktop but just cannot get to my
> laptop
> from my laptop.
> >
> > If all fails, try using PDO with PDO_MSSQL
> (http://us.php.net/manual/de/ref.pdo-dblib.php).
> >
> I will try this a bit later today
>
>
> --
> Regards,
> Alf Stockton www.stockton.co.za
>
> You will gain money by an illegal action.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger01