asp.net publish site problem- pages with DB are not found (404)

i'm using VS 2008, asp.net, framework 3.5

this is the first time i built an asp.net website. the site is quite simple, with some pages getting there text onLoad from a DB (ms access), and some with plain text.

it works fine on debugging.

i used publish web site, and got a preCompiled website folder on my computer.

i copied all the files to my hosting server. the pages that don't need DB work fine, all the ones that call the DB on loading are not found.

i thought it was permissions, but the hoster checked it up with me. the db folder has all permissions.

i have 2 questions: 1. how do i get exact info on the error, better than 404 ?? 2. what's happen开发者_开发问答ing? why doesn't it work?

thanks for reading this far..

I know it sounds obvious but did you leave your testing connection string in the web.config or where so ever you keep it?

You may have used an alias for the DB you are using on your local machine but your ISP will not have the same alias. That would be my first port of call.

To get a better error message you could turn off custom errors in your web.config and perhaps use trace.axd.