ODBC Drivers error '80040e10'

[Kikineko]

Hi, my boyfriend (Deekman) is doing a website in asp coding. He's being stubborn and unreasonable so I decided to ask a question for him.

There's an error on the index page saying:

Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/Deekman/index.asp, line 48


The problem is, this page was working fine up until today and quit working for no apparent reason. Line 48 of the code is. Set RS = conn.execute(querystring)

I'm not sure if this helps but here's a link to the site. http://k.domaindlx.com/Deekman/index.asp

Thanks in advance for any assitance.

[plasterx]

maybe u coudl try paste more codes,so we can really take a look and see what's wrong ? what software are you using to do ur pages?

[Deekman]

I'm using dreamweaver, but I'm programming in pure code i'm only using it for the colour reference.
The thing is it was working earlier and now it has apparently stopped, I've uploaded a version of the site that I KNOW works and still nothing.
The other sections of the website can read and write to the different tables in the database just fine however there's a problem whn reading it from the comics section.
Here's the code i'm using on my index page:
<%
querystring = "SELECT users.ID AS users_ID, users.Username, users.Password, users.Image, users.email, users.ContactDetails, news.ID AS news_ID, news.PosterID, news.Headline, news.Story FROM users INNER JOIN news ON users.ID = news.PosterID ORDER BY news.ID DESC"
Set RS = conn.execute(querystring)
if not RS.EOF then %>
<% Do while not RS.EOF %>
<p><table border="0" width="90%" cellspacing="2">
<img src="<% Response.write RS("Image") %>">
<font size="3"><strong><% Response.write RS("Headline") %></strong></font><br>
<font size="2"><% Response.write RS("Story") %></font><br>
</table>
<center><table border="0" style="border-top: 1px dotted #f2f3f3" width="98%" cellspacing="0">
<tr><td>
<font size="1">Posted By <a href="mailto:<% Response.write RS("email") %>"><% Response.write RS("Username") %></a></font><br>
</td></tr>
</table></center>
</span>
<% RS.MoveNext
Loop
RS.Close
%>
<% else
Response.write "No Articles <p>"
end if
%>

As I said it was working before and everything was fine however earlier this morning everything on the index page stopped working and it gave that error that Kiki posted. The only thing I can think of is that there's a problem with the server but how could that be if the other secitons are working just fine.

[plasterx]

i guessed you were using dreamweaver as much .Dreamweaver is also what i'm using and it often runs into lotsa problems like it works now,and suddenly it doesnt work and give you tonnes of errors. What you could try is to copy and paste the code onto a whole new page,and save the page as someting else. wel since you said thecode was working fine earlier, i suppose you didn't edit your codes or anything like that. so well up to now this is the best solution i can offer ... don't see anything wrong with your codes just yet since it was said to be working earlier =)

try it and let meknow how it goes.

[plasterx]

or one other reason could be dreamweaver was slow in detecting the error previously. i checked the net for you and found that your cause of error could be with your column names.

http://support.microsoft.com/default.aspx?scid=kb;en-us;216425

i think this should help.

[Deekman]

I was trying to fix the comics section aswell and I looked at my code and there was a HUGE amount of things in there that didn't used to be there.
There was a whole if statement I don't even remember making (because it was bloody stupid) and it wrecked the whole thing. I cannot work out what's going on. I'm gonna keep trying this index page, thanks for the help if anyone else can see something wrong with it please let me know.

[Deekman]

Ok I think I solved it.
The problem with the indexpage is that it was trying to call a list out of the database that no longer exists (how it got deleted I'm not sure because I deleted it from a later version not my back up copy just in case) however this field was completely gone from it. I took the firld out of the query and presto it worked.

The comics seciton on the other hand is still a mystery to me, I found 12 lines of code that should not have been in there. I kno I didn't put them there because they really were VERY stupid. I guess this will remain as a mystry to me. Now to back up 6 copies of this working version.
Someone can lock this topic if they want to.
Thanks for the help.
(Edit: Sorry for the double post)