odbc connect problem
| From: | chip dot wiegand at simrad dot com | Date: | Fri, 09 Aug 2002 21:50:05 +0000 |
| Subject: | odbc connect problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21080@lists.php.net to get a copy of this message | ||
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
chip.wiegand@simrad.com
"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!)