Hi Alf,
Alf wrote:
> I have not reinstalled MSDE but have done the svrnetcn you suggest where I
> found 1433 listed as the TCP port but when I try netstat -an I get:-
> C:\Documents and Settings\Alf Stockton>svrnetcn
>
> C:\Documents and Settings\Alf Stockton>netstat -an
have you restarted the se
Sascha Meyer wrote:
Hi Alf,
I just installed MSDE on my PC and I could connect locally with a
trusted connection, using shared memory Net-Library. When connecting
using hostname and port, the connection failed, because the server was
not listening on port 1433.
this will resolve your proble
Hi Alf,
I just installed MSDE on my PC and I could connect locally with a
trusted connection, using shared memory Net-Library. When connecting
using hostname and port, the connection failed, because the server was
not listening on port 1433.
this will resolve your problem: if you install MSD
Sascha Meyer wrote:
Hi Alf,
your local SQL Server is probably listening on another port ... perhaps you
could try the following in a DOS prompt:
netstat
and
netstat -n
The first should give you all open local ports with descriptions to the port if
a default port was used. The second will
uot;
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" ; "Sascha Meyer"
;
Subject: Re: [PHP-WIN] PHP connecting to MSSQL
Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in the
connection string..that also can be the proble
uot;
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" ; "Sascha Meyer"
;
Subject: Re: [PHP-WIN] PHP connecting to MSSQL
Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in the
connection string..that also can be the proble
t;Alf Stockton"
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" ; "Sascha Meyer"
;
Subject: Re: [PHP-WIN] PHP connecting to MSSQL
Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in the
connection string..that also
t;Alf Stockton"
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" ; "Sascha Meyer"
;
Subject: Re: [PHP-WIN] PHP connecting to MSSQL
Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in the
connection string..that also
..
---
--
From: "Alf Stockton"
Sent: Monday, March 30, 2009 3:16 PM
To: "Baboucarr Sanneh" ; "Sascha Meyer"
;
Subject: Re: [PHP-WIN] PHP connecting to MSSQL
Baboucarr Sanneh wrote:
okay
Hi Alf,
your local SQL Server is probably listening on another port ... perhaps you
could try the following in a DOS prompt:
netstat
and
netstat -n
The first should give you all open local ports with descriptions to the port if
a default port was used. The second will give you all open port
Baboucarr Sanneh wrote:
okay try including the port number for the mssql server (I.e 1433) in
the connection string..that also can be the problem somethimes
and Sasha Meyer said:
> just a guess, are you using any kind of firewall (application or port
based) > on your computer? Could you try a
:15:41 +0200
> Von: Alf Stockton
> An: Sascha Meyer
> CC: jmer...@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.ph
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 w
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 y
John Mertic wrote:
Which version of mssql are you connecting to?
My version number is 8.00.194 RTM Developer Edition
--
Regards,
Alf Stocktonwww.stockton.co.za
You have many friends and very few living enemies.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, vi
Which version of mssql are you connecting to?
John
Sent from my iPod
On Mar 29, 2009, at 7:31 AM, Alf Stockton wrote:
I vave also tried using
echo "Error in DBConnect() = " . mssql_get_last_message();
& now all I get is "Error in DBConnect() = "
--
Regards,
Alf Stocktonwww.stockton.c
I vave also tried using
echo "Error in DBConnect() = " . mssql_get_last_message();
& now all I get is "Error in DBConnect() = "
--
Regards,
Alf Stocktonwww.stockton.co.za
Q: What's the difference between a duck and an elephant?
A: You can't get down off an elephant.
--
PHP
I have a problem not being able to connect to a MSSQL database on my laptop
from a php application I wrote, however I can access the same database from
Enterprise Manager no problem. The connect code looks like:-
$link = mssql_connect($servername, $dbusername, $dbpassword) or die("Unable to
co
18 matches
Mail list logo
