Link to home
Start Free TrialLog in
Avatar of murond
murond

asked on

ASP page won't display

I had a designer create an asp database for our products.  I have seen the page, on his server, but when he tried to post it to my Hosting site, it won't display (http 500 Internal error) The designer and Host each say its the other's problem, and i don't know nearly enough to figure it out.  Its a very simple site, with a listing of our products (maybe 20) - I can't see why this is such an issue.  Any help on where to look in the Servers options or in the page itself would be greatly appreciated.

Thank you, anyone who responds!
Avatar of AndrewK
AndrewK

It's all very well for the designer to say it's the ISPs issue, but he should ensure that the two environments are the same. He can't just go and code a page to run under his environment and expect it to work elsewhere unless he did due dilligence and made sure the two environments are the same. This is the first place I would start.
A 500 error is kind of ugly to deal with.  Debugging it without good ASP knowledge is ugly.  You can start by chopping up the page into smaller bites and testing it.

More than likely your problem is with the connection string to the database.  Since if ASP works one place, the only place it would get goofy in this scenario is the database.  If the database isn't setup properly, you can run into all sorts of issues that stack up since there are probably more than one call going to the DB on that first page.

R
First of all, you need to go to:

Tools > Internet Options >

And click on the "Advanced" tab.

Then, UNCHECK where it says "Show friendly HTTP error messages".

That way, you will see the REAL server error in your browser.

Hope this helps.
P.S. I'm talking about Internet Explorer there.
P.P.S. Once you get the actual error by following the instructions above, please post it here, that will be the first step in determining what the problem is. :)
>> I have seen the page, on his server, but when he tried to post it to my Hosting site, it won't display (http 500 Internal error) <<

Why do you want your script to produce a HTTP 500 error? Wouldn't you want it to work, without errors? What exactly is the problem at hand?

Wakie.
Oh, sorry... I think I read that wrong :-/

whammy's solution is appropriate here, do that and you should see where your problem lies.
Avatar of murond

ASKER

this is the error, following whammys suggestion (btw, thanks)

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

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

/products.asp, line 56
ASKER CERTIFIED SOLUTION
Avatar of whammy
whammy

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of murond

ASKER

this is the error, following whammys suggestion (btw, thanks)

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

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

/products.asp, line 56
Not that, it looks like you just refreshed this page on accident.

Can you post the section of your ASP code, that has the connection string, etc. in it (right around line 56), with a few lines above and below?
Avatar of murond

ASKER

thanks for the help - I posted your answer to my designer, and things sem to work ok.  BTW, do you think this service is good enough for the pay (or premium option)?

tpendergrass@wernercorp.net

again, thanks
It depends upon your needs, I suppose. There are definitely a great deal of knowledgeable and experienced people here.

I just come here to try and help people when I can, since I do this stuff for a living. :)
Avatar of murond

ASKER

Is this intended just for computer professionals?  I'd hate to annoy everyone with my questions that i'm sure are very basic to all of you.  I have an office that recently upgraded to a server and 13 desktops - yet we have no comp guy - i guess since i don't say no very i well, i wound up with it.
Well, this is a forum in which you ask questions, if someone has the answer (or thinks they do), then they might post a solution for ya.

I'm a professional web developer, but I didn't see any prerequisites for asking questions when I signed up. :)

Your question was very much less basic than many I see on here. Ask away! :)
P.S. It does help if you post in the appropriate forum, though... which you did in this case, just make sure that you're targeting the right group. :)
You should also check out the newsgroups too. Try this for a starting point:

http://groups.google.com/groups?group=comp&hl=en

you'll find a wealth of info in these groups and no limit to the number (and types!) of people who'll respond!

I really wouldn't worry about "annoying" anyone. Anyone who gets annoyed by a question - no matter how trivial it may "appear" - shouldn't be here in the first place. Everyone - even those who think they were born under a star - knew nothing about anything at one point!
Amen to that! Whenever you think you are an ASP God that knows everything (which I still am not by any means, but I have a lot of day-to-day experience with it), start learning .NET (and make sure if you're using VBScript that you use C#).

I'm not saying C# is bad, quite the contrary - it makes VB.NET look horrible!

But I feel like a newbie again. Such is life.