Solved

odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.

Posted on 2010-11-09
2
2,048 Views
Last Modified: 2012-05-10
I have a client that is running PHP script to update some pricing and item descriptions in an SQL database.  Since we moved the Access database to a new server, we have been having problems.  I have completely redone the ODBC for this app and all the other components are working except this one.  I can't imagine anything else has changed that would cause this error.  It was working fine before we moved the database and once we re-established the ODBC all other components of this web frontend are working except this one.
Error Message:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in C:\wamp\www\ItemUpdate\UpdateItemDescriptions.php on line 113

Code:starting at line 112;  $connect1 is defined earlier in the code and seems to work in the other PHP script

$query1 = "SELECT RefNum,SHORT_DESCRIPTION FROM AllPrices ORDER BY RefNum";
$result1 = odbc_exec($connect1,$query1);

$itemcount=0;
while (odbc_fetch_row($result1)) {
  //put the data into an array; we'll pop the data later if it is the same in the Inventory system
  $itemref = odbc_result($result1,"RefNum");
  $itemdesc = odbc_result($result1,"SHORT_DESCRIPTION");
  $pbArray[$itemref] = $itemdesc;
  ++$itemcount;


thanks for the help


0
Comment
Question by:chenault68
2 Comments
 
LVL 13

Accepted Solution

by:
darren-w- earned 500 total points
ID: 34094517
Hi,

it may be something to do with how your ref number is being added?

try echoing  the $query1 line out before issuing the call and copy the calling line into you sql client to see if it works.
0
 

Author Closing Comment

by:chenault68
ID: 34123506
Thanks for the help
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now