Thanks, that fixed that part of it, now here's the newest error message:
Warning: SQL error: [iODBC][Driver Manager]Specified driver could not be
loaded, SQL
state IM003 in SQLConnect in /usr/local/apache/htdocs/odbctest.php on line
7
Fatal error: Call to undefined function: error_handler() in
/usr/local/apache/htdocs/odbctest.php
on line 10
I'm outa here, catch up with ya on monday,
--
Chip
salamander <[EMAIL PROTECTED]> wrote on 08/09/2002 04:10:00 PM:
> Chip,
> You are going to have to rebuild the dso with the options you specified
> before - try cutting and pasting the configure that shows up in your
> phpinfo() to make it easier.
> Also, you can get the necessary iODBC header files at www.iodbc.org, as
> well as find a HOWTO there for compiling PHP/iODBC on *nix systems.
> Cheers,
> Andrew
> On Friday, August 9, 2002, at 06:08 PM, [EMAIL PROTECTED] wrote:
> > Yeah, you're right, I see I need to add --with-iodbc. Now another
> > question
> > - when I recompile to add
> > this support, do I have to add all the other options that I originally
> > had
> > listed? Or can I add just this one
> > and everything else will be left the same? What about php.ini? Will it
> > be
> > changed?
> >
> > --
> > Chip W
> >
> > Chip Atkinson <[EMAIL PROTECTED]> wrote on 08/09/2002 02:51:10
PM:
> >
> >> 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
> >
> >
>
> --
> 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
