I quick search on google threw up these links which all sound like they might help:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168 http://www.learnasp.com/learn/FAQdbUpdate.asp http://theaspsite.org/examples_display.asp?id=90 Martin On 09-Jul-2002 Jeff Urlwin wrote: > Can you turn on DBI tracing at, say, level 3 and capture the output and post > here, with the whole script? > > Regards, > > Jeff > > >> >> >> Hiya. On my home comp, I'm able to insert into my Players table >> perfectly. I >> uploaded my scripts and DB to my domain, try to insert, and get the >> following error: >> >> Content-type: text/html >> Software error: >> Died while executing: [Microsoft][ODBC Microsoft Access Driver] Operation >> must use an updateable query. (SQL-S1000)(DBD: >> st_execute/SQLExecute err=-1) >> at d:\gearhost\hostingaccounts\ebahoops\www\cgi-bin\submit_player.pl line >> 439. >> >> I don't understand why the insert works on my home comp but not on my >> hoster's server. >> >> Also, why is the error saying that the "Operation must use an updateable >> query" when I'm trying to insert rather than update? >> >> Here's my code for inserting: >> >> #the fields are split into groups >> of 5 to make reading a whole lot >> easier >> $sth = $dbh->prepare("INSERT INTO Players >> ( >> PlayerID, >> LName, >> FName, >> Address, >> AptNum, >> >> City, >> PostalCode, >> Phone, >> BusinessPhone, >> DOB, >> >> Gender, >> PrimaryEmail, >> Email2, >> Email3, >> ReturningPlayer, >> >> Division, >> ReferenceNum, >> RepOrHouseLeague, >> HasPayed, >> ProblemWithRegistration, >> >> TeamNum, >> Notes >> ) >> VALUES (?,?,?,?,?, >> ?,?,?,?,?, ?,?,?,?,?, ?,?,?,?,?, ?,?)"); >> >> #the fields are split into groups >> of 5 to make reading a whole lot >> easier >> if ($sth->execute >> ( >> $new_playerID, >> $player_info{'player_last_name'}, >> $player_info{'player_first_name'}, >> $player_info{'player_address'}, >> $player_info{'player_apt_num'}, >> >> $player_info{'player_city'}, >> $player_info{'player_postal_code'}, >> $player_info{'player_phone'}, >> >> $player_info{'player_business_phone'}, >> $player_info{'player_DOB'}, >> >> $player_info{'gender'}, >> $player_info{'player_email1'}, >> $player_info{'player_email2'}, >> $player_info{'player_email3'}, >> $player_info{'sibling'}, >> >> $player_info{'division'}, >> $player_info{'reference_number'}, >> $player_info{'rep_or_house_league'}, >> 'No', >> 'No', >> >> 0, >> '' >> ) || die "Died while >> executing: $DBI::errstr") >> { >> print "Player >> successfully added to the database.<p>"; >> } #end if executed properly >> >> >> I doubt that there could be something "wrong" with the SQL, since it works >> on my home comp. However, I'm guessing that there's something >> that I can do >> differently with the SQL so that it'll work both on my home >> system and on my >> hoster's server. >> >> So, if anybody has any suggestions or insight, please give me a shout. >> >> Thanks! >> Nick Hoffman >> >> -- Martin J. Evans Easysoft Ltd, UK Development
