cristianobaez
Posts: 1
|
| Posted: 05/14/2005, 4:36 AM |
|
Hi
I have SQL Server in a server and Linux + apache in other server and a last version of ccs.
My connection say this:
Warning: mssql_pconnect(): Unable to connect to server: 192.168.0.8 in /srv/www/htdocs/xoops/html/project/db_mssql.php on line 57
DBDatabase error: Link-ID == false, mssql_pconnect failed
MSSQL Error: 0 ()
Session halted.
I have a connection with manual php script and it is ok , but with ccs i have error.
see:
Manual script: It's ok !!!!
<?
$s = mssql_connect('192.168.0.8:1433','intranet','xxx');
$b = mssql_select_db('logix',$s);
//if ($b) {
//echo ("Conectado");
//}
$result = mssql_query('SELECT cod_cliente, nom_cliente FROM clientes',$s);
while ($row = mssql_fetch_array($result)) {
// echo ($row['cod_cliente']." - ".$row['nom_cliente'."\n"]);
echo ($row['nom_cliente']." - ".$row['cod_cliente']."<br>");
}
?>
Connection generate by CCS with error:
class DB_MSSQL {
var $DBHost = "192.168.0.8:1433";
var $DBDatabase = "logix";
var $DBUser = "intranet";
var $DBPassword = "xxx";
var $Persistent = false;
|
 |
 |
peterr
Posts: 5971
|
| Posted: 05/14/2005, 11:24 AM |
|
Try using mssql_pconnect in your program like CCS does (instead of mssql_connect). Does that work?
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
