[PHP-DB] Pear::DB tableInfo problem

[Avi Schwartz]

Hi,

I am running under Linux and using freetds to connect to a DB on MS 
SQL-Server.  In general it works very well, except when I try to use the 
tableInfo() function to retrieve information from a result set as in:

print_r($result-tableInfo());

The page aborts at this call.  Using the Zend debugger I traced it down into 
the mssql.php file and I found that it breaks on the following line:

$res[$i]['name']  = @mssql_field_name($id, $i);

The error I see in the debuger is:

Call to undefined function:  mssql_field_name()

What may the problem be?  Is my installation broken?  Am I missing some file 
or library?

Thanks,
Avi
-- 
Avi Schwartz   Universe-watching, like golf and aging,
[EMAIL PROTECTED] promotes humility - William R. Everdell

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] onnecting to MSSQL database from Linux?

[Avi Schwartz]

I have PHP4 and freetds installed and I am trying to connect to a mssql 
server.  The problem I am having is that the mssql_connect() call generates 
the following error:

Fatal error: Call to undefined function: mssql_connect()

Is there something I need to require?

Thanks,
Avi
-- 
Avi Schwartz   Universe-watching, like golf and aging,
[EMAIL PROTECTED] promotes humility - William R. Everdell

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: onnecting to MSSQL database from Linux?

[Avi Schwartz]

I did build it with --with-sybase, but then I forgot to install the new 
version.  Face turning red...  Sorry for the false alarm.  It now works 
like a charm.

Avi

Adam Williams wrote:

 He's using microsoft sql server, not mysql.
 
 try --with-mssql
 
 On Wed, 18 Sep 2002, Jason Morehouse wrote:
 
 It means you haven't compiled mysql support into php.  Recompile it using
 --with-mysql
 On Tue, 17 Sep 2002 15:30:29 +, Avi Schwartz wrote:

  I have PHP4 and freetds installed and I am trying to connect to a mssql
  server.  The problem I am having is that the mssql_connect() call
  generates the following error:
 
  Fatal error: Call to undefined function: mssql_connect()
-- 
Avi Schwartz   Universe-watching, like golf and aging,
[EMAIL PROTECTED] promotes humility - William R. Everdell

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php