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