php-windows Digest 30 Mar 2009 13:38:48 -0000 Issue 3592
Topics (messages 29226 through 29229):
Re: PHP connecting to MSSQL
29226 by: Alf Stockton
29227 by: Sascha Meyer
29228 by: Alf Stockton
29229 by: Sascha Meyer
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
John Mertic wrote:
Which version of mssql are you connecting to?
My version number is 8.00.194 RTM Developer Edition
--
Regards,
Alf Stockton www.stockton.co.za
You have many friends and very few living enemies.
--- End Message ---
--- Begin Message ---
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.
One setting I remember to have changed in my environment was the following
php.ini entry:
[CODE]
mssql.secure_connection=off
[/CODE]
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?
If all fails, try using PDO with PDO_MSSQL
(http://us.php.net/manual/de/ref.pdo-dblib.php).
Good luck and please give us an update of your progress!
Regards,
Sascha
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss
für nur 17,95 Euro/mtl.!* http://dsl.gmx.de/?ac=OM.AD.PD003K11308T4569a
--- End Message ---
--- Begin Message ---
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.
--- End Message ---
--- Begin 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 <a...@stockton.co.za>
> An: Sascha Meyer <harlequ...@gmx.de>
> CC: jmer...@gmail.com, php-wind...@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
--- End Message ---
