RE: [PHP] Help SQLServer connection: What's "server_name"??

2004-08-12 Thread Jay Blanchard
[snip]
Hi all, that's my first question here, I'm not subscribed.

I'm tring to connect a local DB (Apache+sqlserver2K), but when I execute
this
simple example:



I get: Warning: MS SQL: Unable to connect to server: 

I tried many words in there (): "localhost", "LOCAL", PCs name, name
that
appears in Enterprisa Manager I don't know what word is asking me
for
it's a stupid question, I know, but
[/snip]

Do you know the IP address? You could try 127.0.0.1 if it is the server
you are working on. If it is a remote server you can get the IP from
your network admin

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] Help SQLServer connection: What's "server_name"??

2004-08-13 Thread Fernando Verdu Castillo
> [snip]
> Hi all, that's my first question here, I'm not subscribed.
> 
> I'm tring to connect a local DB (Apache+sqlserver2K), but when I execute
> this
> simple example:
> 
>  $conectID = mssql_connect(,"SA","");
> mssql_select_db("Northwind");
> $result=mssql_query("select * from products",$numero );
> while ($row=mssql_fetch_array($result)) {
>$counter++; $c1=$row["ProductName"];
>$c2=$row["UnitPrice"];
>echo ("$counter c1: $c1 c2: $c2\n");
> }
> mssql_close($conectID);
> ?>
> 
> I get: Warning: MS SQL: Unable to connect to server: 
> 
> I tried many words in there (): "localhost", "LOCAL", PCs name, name
> that
> appears in Enterprisa Manager I don't know what word is asking me
> for
> it's a stupid question, I know, but
> [/snip]
> 
> Do you know the IP address? You could try 127.0.0.1 if it is the server
> you are working on. If it is a remote server you can get the IP from
> your network admin

Thanks for your answer. I tried (Apache and DB are in the same computer) this
but I get the same error... I have SQLserver2K (personal) installed and it
works fine... What's the matter? I'm thinking on reinstall it, but I'm afraid
that will be a waste of time :(

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php