making a connection to a DB

[Anon]

Hi everybody,
I'm used to scripting in ASP on a windows enivironment and now I'm trying to learn PHP. I've installed it successfully on windows 2000 professional...

Now, I can't find a way to connect to my SQLserver!!! i know this connection:

---

$db=mysql_connect("hostname","user","pass");
mysql_select_db("databasename",$db);

$result=mysql_query("select * from table",$db);

however, I don't have SQLserver on my PC but on a server...if I use only my server name, my code tries to find it on my PC C://...etc.

In ASP I use this connection string:

strConnect = "SERVER='servername';DRIVER={SQL Server};DATABASE='dbname';UID='user';pwd='password';"

Is there something similar in PHP??

WHAT I HAVE TO DO TO MAKE THIS CONNECTION WORK!!!!! please help!!

[Anon]

Use the IP adres of the server as hostname.

good luck,
Joris

[Anon]

Nop,
I'm sorry but it doesn't work...the parser is still trying to find the DB into C://...etc...

however, I found out how to do it by a DSN connection and it works great...

---

<?php
$connect = odbc_connect("DSNname", "user", "pwd", SQL_CUR_USE_ODBC );
$query = "select * from TBname";
$result = odbc_exec($connect, $query);
while(odbc_fetch_row($result))
{
$name = odbc_result($result, 2);
echo "$name<br>";
}
odbc_close($connect);

?>

Thank for your help, though :-)

[Anon]

You're using calls for MySQL. You want to use mssql_connect instead of mysql_connect, etc.

Hank

[Anon]

I tried to do as you said, however, I got this error msg :

Fatal error: Call to undefined function: mssql_connect() in c:\inetpub\wwwroot\prove_PHP\connect.inc on line 4

here's my code:

$link_id = mssql_connect("serverName??", "sa", "drowssap");

N.B. I've found a PHP editor called PHPEd..do you think it's a good one?