odb error in asp cant figure out

[gsc123]

Works on my local machine and when uploaded to website get this error

SELECT songs.[Real Song Name] FROM songs WHERE (((songs.id)=78))
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/main.asp, line 52


code line with error is - conntemp.Execute(strSql)


id=Request.QueryString("id")
strSql = "SELECT songs.[Real Song Name] FROM songs WHERE (((songs.id)="&id&"))"
Response.Write strSql
set rs = conntemp.Execute(strSql)
mp3 = rs("Real Song Name")
set rs=nothing
strSql = "UPDATE songs SET songs.[count] = songs.[count]+1 WHERE (((songs.id)="&id&"))"
conntemp.Execute(strSql)
url="

http://www.firejackmusic.co.uk/sounds/"&mp3&".mp3"

Response.Redirect(url)

 

[guitarzan]

You should always begin your search for an answer with Google.

With that said...

http://databases.aspfaq.com/databas...tion-must-use-an-updateable-query-errors.html

 

[gsc123]

bin ther done that...permission maybe?

 

[PaulBricker]

Count is a reserved word (songs.count). That might screw things up. Also, if you have any aggregate functions in the query (or an underlying query) that would make it unupdateable.


Paul

 

[gsc123]

Would this upset an update query?

 

[PaulBricker]

Depending on what it is, any aggregrate funtion will make any query unupdateable as far as I know. I don't know about the using a reserved word like count as a field name.

Paul

 

[PaulBricker]

If the id is a numeric field type you might try adjusting the sytax a little to this.

strSql = "SELECT songs.[Real Song Name] FROM songs WHERE songs.id= "&id

Paul