Re: 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