RE: [PHP-WIN] ODBC Error....

The reason I say to do this is because it looks like an SQL problem to me, not a connection or PHP problem --------------------- John Asendorf - jasendorf@lcounty.com Web Applications Developer http://www.lcounty.com - CHECK OUT THE NEW LOOK! Licking County, Ohio, USA 740-349-3631 > -----Original Message----- > From: Asendorf, John [mailto:JAsendorf@lcounty.com] > Sent: Wednesday, September 06, 2000 10:29 AM > To: John Whitaker; php-windows@lists.php.net; Pablo Vera > Subject: RE: [PHP-WIN] ODBC Error.... > > > try some simpler SQL to test the connection: > > $sql = "SELECT * > FROM Mp3List"; > > --------------------- > John Asendorf - jasendorf@lcounty.com > Web Applications Developer > http://www.lcounty.com - CHECK OUT THE NEW LOOK! > Licking County, Ohio, USA > 740-349-3631 > > > > -----Original Message----- > > From: John Whitaker [mailto:jwhitake@agad.purdue.edu] > > Sent: Wednesday, September 06, 2000 10:33 AM > > To: php-windows@lists.php.net; Pablo Vera > > Subject: Re: [PHP-WIN] ODBC Error.... > > > > > > Here is the code giving me the problems... > > > > <?php > > > > print "Content-type: text/html \n\n"; > > print "<HTML><HEAD><TITLE>Search > > Results...</TITLE></HEAD>\n"; > > print "<BODY BGCOLOR='black'><FONT > > FACE='arial,helvetica'><FONT > > COLOR='#FFFF00'>\n"; > > > > print "<H2>Search results for $sFind</H2>\n"; > > > > > > $dsn = "mp3s"; > > > > /* connect to db*/ > > $conn = odbc_connect($dsn,"",""); > > if ($conn <= 0) { > > echo "Error connecting to database<BR>"; > > exit; > > } > > else { > > echo "<P>connected to mp3 database...\n<BR>"; > > }; > > > > > > /* make SQL statement */ > > $sql = "SELECT Artist, Album, Song FROM Mp3List WHERE Song LIKE > > \"*$songTitle*\" ORDER BY Song"; > > echo $sql; > > echo "<BR>"; > > > > /* prepare SQL statement */ > > $sql_result = odbc_prepare($conn, $sql); > > > > /* execute SQL statement and get results */ > > odbc_execute($sql_result); > > > > /* print results in table */ > > odbc_result_all($sql_result,"border=1"); > > > > > > > > Pablo Vera wrote: > > > > > John: > > > > > > Can you send a sample of your script, or of the SQL query you are > > > using. It seems to me that you have a syntax error (a > > misspelled table > > > or field name), because Access is asking for 2 parameters, > > this means, > > > that there are to items not recognized in your query. > > > > > > Saludos, > > > Pablo Vera > > > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > > > > > > Wednesday, September 06, 2000, 9:22:48 AM, John wrote: > > > > > > JW> I am getting the following error when trying to connect > > to a MS Access > > > JW> db using ODBC. > > > > > > JW> Warning: SQL error: [Microsoft][ODBC Microsoft Access > > Driver] Too few > > > JW> parameters. Expected 2., SQL state 07001 in SQLExecute in > > > JW> C:\WEBSHARE\SCRIPTS\findSong.php on line 32 > > > > > > JW> Any thoughts? > > > JW> Thanks. > > > JW> -- > > > JW> John Whitaker > > > > > > -- > > > PHP Windows Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-windows-help@lists.php.net > > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > -- > > John Whitaker > > > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: > > php-list-admin@lists.php.net > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net >