[PHP-DB] MSSQL DB Connect

2001-12-21 Thread Jerry

Hi

I have PHP on windows 2000 web server
I would like to remote to a MS SQL database on another web server.
I tried something like:

?php
$h = server adr;
$u = user;
$p = passw;
$b = db;
$connexion = mssql_connect($h, $u, $p);
mssql_select_db($b);
$sql = select * from test;
$result = mssql_query($sql_temp);
mssql_close($connexion);
?

But it didn't work. Please help me.

Jerry



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




Re: [PHP-DB] MSSQL DB Connect

2001-12-21 Thread Frank M. Kromann

Hi Jerry,

You need to have the Client Tools for MS SQL Server installed on your PHP4 box. These 
tools is found on the CD, or you can just copy ntwdblib.dll fom one system to another.

The default communication protocol will be netbios, if you want to change that to 
tcp/ip you need to install the tools. One of the toiols is called Client Network 
Utility. You can use this to specify aliases for your host names s[ your system knows 
the protocol to use.

- Frank

P.S You also need to enable the mssql extension !

 I have PHP on windows 2000 web server
 I would like to remote to a MS SQL database on another web server.
 I tried something like:
 
 ?php
 $h = server adr;
 $u = user;
 $p = passw;
 $b = db;
 $connexion = mssql_connect($h, $u, $p);
 mssql_select_db($b);
 $sql = select * from test;
 $result = mssql_query($sql_temp);
 mssql_close($connexion);
 ?
 
 But it didn't work. Please help me.
 
 Jerry
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 
 




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]