Web App - Not connecting to Db.

[AvatarZA]

I have made a web application

All i wanted it to do is read a MS Access db list all the contents of a table in a datagrid and a combo-box, then with the combo-box edit a item then save to the db. I have a desktop version of this app and the dll works fine, i have the web app working on my pc, but when i put it on a server i go to the page and i don't get any of the information in the grid or combo? The database is in the correct place i think cause i have a web serivce running and the db for it is in the same place at the db for this web app.

I dunno whether there is a problem with my security settings or what it is.

Anyone with any suggestions please help!

 

[drew10]

Are you receiving an error message, or just no data?

 

[AvatarZA]

I am just not recieving any data.

 

[jfrost10]

What happens when you try to step through the code? Are you sure its connecting properly (it may not be, hence why you aren't getting an error message)

D

 

[AvatarZA]

I have stepped through it on my own pc, i cannot step through it on the server though.

I still think that it has something to do with the security settings of the database, i give asp full rights what else is needed, must i give the folder where the db resides more rights or what?

 

[jfrost10]

Oh, silly me: your database isn't in the same folder as your web app, is it?

Yes, you do need to give the asp.net user access priveledges to the folder (and to the file as well wouldn't hurt)

D

 

[AvatarZA]

Well my db aint in the same folder but it runs from the startup path, ie windows\microsoft.net\framework\v....
You know...

I cannot try the rights thing now, i know that i have given the Access db the rights but i aint sure about the folder where it is in.

Besides using the application startup path what other way is there to tell your prog where the db is, can you put it in the same folder as the web app? Besides hard coding that is.