Skip to Content.
Sympa Menu

freetds - Re: AIX+PHP+FREETDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Andr�" <allquadros AT ig.com.br>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: AIX+PHP+FREETDS
  • Date: Wed, 30 Oct 2002 07:41:57 -0500


Ok Nicholas,

I install the last snapshot version and now the test using dblib is Ok.
But my next problem is the access MSSQL Server using PHP. When try it I
receive the following error:


Warning: 0 is not a Sybase link index in /www/teste/mssql.php on line 7

Warning: 0 is not a Sybase link index in /www/teste/mssql.php on line 11

Warning: 0 is not a Sybase result index in /www/teste/mssql.php on line 13

I used the SqlServer functions of PHP, see the code.

<?php
//connect to database server
$db_conn = mssql_connect("99.99.99.99:1433","user","password");
// or die( "ERROR: Connection to SPHINX1 failed" );
//select database - only if we want to query another database than the
default one
mssql_select_db( "Northwind", $db_conn );

//or die( "ERROR: Selecting database failed" );
//query the database

$query_result = mssql_query( "SELECT ProductID FROM Products", $db_conn );
//or die( "ERROR: Query failed" );

$daten = mssql_fetch_array($query_result);
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?php echo $daten["ProductID"]; ?>
</body>
</html>

Do you have any idea ?
thanks,
André







Archive powered by MHonArc 2.6.24.

Top of Page