RE: [PHP-DEV] Call to undefined function: odbc_connect()

If you're using the shared module, make sure that you have the odbc module uncommented in the module list in your php.ini file. If not, make sure you've compiled PHP with --with-odbc in the configure statement. But this question belongs on the php-general list. Joseph > -----Original Message----- > From: Dan Kalowsky [mailto:dank@deadmime.org] > Sent: Wednesday, August 07, 2002 3:23 PM > To: Keith Roberts > Cc: php-dev@lists.php.net > Subject: Re: [PHP-DEV] Call to undefined function: odbc_connect() > > > A) Not enough info to even begin to help debug this > B) Wrong list, you want the php-general list not php-dev list. > > On Wed, 7 Aug 2002, Keith Roberts wrote: > > > I am getting this error when trying to connect to a MS Access > database. I > > do think that it is the connection that is failing, it is the function: > > > > Fatal error: Call to undefined function: odbc_connect() in > > /home/sites/home/web/phptest.htm on line 37 > > > > What am I doing wrong or what have I missed. Here is a snippet > of the code > > that I am using: > > > > function Output_Entries() { > > /* > > Make the connection to the database. The syntax is > > odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' ); > > $cnx will hold the > > pconnect is used to establish a persistent database > > connection to the Database until the procedure is completed. > > */ > > > > $cnx = odbc_connect( 'SLSocket' , '', '' ); > > if (!$cnx) { > > Error_handler( "Error in odbc_connect" , $cnx ); > > } > > > > // send a simple odbc query . returns an odbc cursor > > $cur= odbc_exec( $cnx, "select > > Index,ItemNumber,ItemDescription,ProductLine from People" ); > > if (!$cur) { > > Error_handler( "Error in odbc_exec( no cursor returned > ) " , $cnx ); > > } > > echo "<table border=1><tr><th>Index</th><th>First > > Name</th>". > > "<th>Last Name</th><th>Phone > > Number</th></tr>\n"; > > $nbrow=0; //Local variable to count number of rows > > > > // fetch the succesive result rows > > while( odbc_fetch_row( $cur ) ) { > > $nbrow++; > > $Index= odbc_result( $cur, 1 ); // get the field "Index" > > $ItemNumber= odbc_result( $cur, 2 ); // get the field > "ItemNumber" > > $ItemDescription= odbc_result( $cur, 3 ); // get the field > > "ItemDescription" > > $ProductLine= odbc_result( $cur, 4 ); // get the field > "ProductLine" > > > > echo > > "<tr><td>$Index</td><td>$ItemNumber</td>". > > > > "<td>$ItemDescription</td><td>$ProductLine</td></tr>\n"; > > } > > > > echo "<tr><td colspan=2>$nbrow entries > > </td></tr></table>"; > > > > // close the connection. important if persistent connection are "On" > > odbc_close( $cnx); > > } > > > > function Error_Handler( $msg, $cnx ) { > > echo "$msg \n"; > > odbc_close( $cnx); > > exit(); > > } > > > > > > -- > > -- > > Keith Roberts > > IT Manager > > Laptops For Less > > 2995 White Star > > Anaheim, CA 92806 > > (714) 224 - 3980 > > http://www.laptopsforless.com > > > > > > > > > > >---------------------------------------------------------------< > Dan Kalowsky "A little less conversation, > http://www.deadmime.org/~dank a little more action." > dank-nos@mpa-deadmime.org - "A Little Less Conversation", > kalowsky@php.net Elvis Presley > > > -- > PHP Development Mailing List <http://www.php.net/> > To unsubscribe, visit: http://www.php.net/unsub.php