It looks like you didn't build php with odbc support.
Try putting in a call to
phpinfo ();
and see if it says that odbc support is compiled in.
(Another) Chip
On Fri, 9 Aug 2002 [EMAIL PROTECTED] wrote:
> I am attempting for the first time, to connect from freebsd/mysql/php box
> to a NT box running MAS200. I am able
> to connect from another NT workstation with Access and download data, so I
> am trying from FreeBSD now.
> When I run the code below I get error:
>
> Fatal error: Call to undefined function: odbc_connect() in
> /usr/local/apache/htdocs/odbctest.php on line 7
>
> What am I doing wrong? There's not much info on this topic in the mysql
> manual.
>
> <html>
> <head>
> <title>Untitled</title>
> </head>
> <body bgcolor="white">
> <?
> $connect = odbc_connect("localhost", "----", "-----");
> if (!$connect)
> {
> Error_handler( "Error in odbc_connect" , $connect );
> }
> $result = odbc_exec($connect, "SELECT ProductLineDescription FROM
> IMA_ProductLine, ItemNumber,
> ItemDescription FROM IM1_InventoryMasterFile where DefaultWhse = 004");
> if (!$result) {
> Error_handler( "Error in odbc_exec( no cursor returned ) " ,
> $connect );
> }
> echo "<table border=1><tr><th>Brand</th><th>Part
> Number</th><th>Description</th></tr>\n";
>
> // fetch the succesive result rows
> while( odbc_fetch_row( $result ) ) {
> $brand= odbc_result( $result, 1 ); // get the field
> "ProductLineDescription"
> $number= odbc_result( $result, 2 ); // get the field "ItemNumber"
> $description= odbc_result( $result, 3 ); // get the field
> "ItemDescription"
>
>
> echo "<tr><td>$brand</td><td>$number</td><td>$description</td></tr>
> \n";
> }
>
> echo "</table>";
> echo "</body></html>";
> ?>
>
> --
> Chip Wiegand
> Computer Services
> Simrad, Inc
> www.simradusa.com
> [EMAIL PROTECTED]
>
> "There is no reason anyone would want a computer in their home."
> --Ken Olson, president, chairman and founder of Digital Equipment
> Corporation, 1977
> (They why do I have 9? Somebody help me!)
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
