[PHP-DB] MS SQL 6.5 connection

2001-08-07 Thread Sommai Fongnamthip 

Hi,
I've been setting PHP 4.0.6 with apache 1.3.20 in Linux Red Hat 6.2 to 
connect MS SQL 6.5 via TDS4.2 (freetds-0.51).  Why I can't connect to MS 
SQL 6.5? here my code in php
?

$conn = SQLSERVER;   // host or connection name in /usr/local/freetds/interf$
$myuser = sa;
$mypass = ;

$dbc=mssql_connect($conn, $myuser, $mypass) or die (Unable to connect MS 
SQL);

?

here is freetds config
SQLSERVER
 query tcp tds4.2 203.144.255.71 1443
 master tcp tds4.2 203.144.255.71 1443

Regards,
Sommai Fongnamthip


-- 
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] MS SQL 6.5 connection

2001-08-07 Thread Mark Roedel 

 -Original Message-
 From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, August 07, 2001 4:00 AM
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] MS SQL 6.5 connection
 
 
 I've been setting PHP 4.0.6 with apache 1.3.20 in Linux 
 Red Hat 6.2 to connect MS SQL 6.5 via TDS4.2 (freetds-0.51). 

Have you tried editing the PWD file in your FreeTDS directory and
running 'make check' to verify that everything's behaving normally
there?

Is your SYBASE environment variable set correctly, so that PHP can find
your interfaces file?  (Check the output of a phpinfo() call to verify
that...)

 here my code in php

 ?
 
 $conn = SQLSERVER;   // host or connection name in 
 /usr/local/freetds/interf$
 $myuser = sa;
 $mypass = ;
 
 $dbc=mssql_connect($conn, $myuser, $mypass) or die (Unable 
 to connect MS SQL);

Does mssql_get_last_message() say anything interesting when this line
fails?  


---
Mark Roedel ([EMAIL PROTECTED]) | There cannot be a crisis next week.
Systems Programmer / WebMaster |  My schedule is already full.
 LeTourneau University |   -- Henry Kissinger 

--
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]