Community discussion forum
Problem after hosting an asp.net website in IIS
Last post was 05 Mar 2009 at 11:58
Tags:
India
-
The Asp.net website i created consumes an activex dll created in VB with MS Access as DB.On local host everything is working fine.But after hosting on IIS,there are errors in executing queries.I am new to asp.net.Please help me... :)Post was edited on 05/03/2009 04:54:46 Report abuse
-
-
hi, Can you tell us what the errors are? Si
-
Hi Si The following is the error message displayed: *Server Error in '/Website' Application. -------------------------------------------------------------------------------- Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. * dheeps
-
Hi Si The previous reply was the error message when run on remote machine.The error message when run from local host is: * [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE' *
-
sounds like you have a problem with the SQL that is being run on the database. If you check the application warning logs on the server, does it show the same error message? Si
-
I get the same error message when it is run on server.While it is run from MS Visual Studio 2005,it works fine. dheeps
-
is it a connection string issue, if you host the IIS locally (if you are using XP Pro) and tell Visual studio to run it in that instance, can you step through the code? does the connection to the database open properly? what is the SQL you are trying to run? Does the IIS have impersonation turned on? could it be an access right issue? Si
-
It is working fine when run on local host. On IIS,all retrieval queries (SELECT..)are working fine.Only functionalities using DML queries like INSERT and DELETE are creating problems. dheeps
-
since those effectively edit the data on the system, the aspnet user or the user that is being impersonated will need modify access on that database folder won't they? have you checked if that is allowed? Si
-
I haven't worked on this before and I don't know how to grant access to other users in MS Access.Can you tell me how to do that?
-
it isn't so much the database, but the folder that the database resides in. so if you store it in a folder called database, make sure the user that the site is impersonating or the aspnet user has write access to that folder. Si
-
In the security tab of database properties, i checked full contol option and the website works fine now :) Thank Si ,for your support. Dheeps
-
No problems, but full control was probably a little excessive, you should reduce it so that it has the minimum required, read and modify should do it. Regards Si
-
Ya sure..I'll reduce it Si..Thank you :) Dheeps
Post a reply
Related discussion
-
urgent help me(GPRS application using Asp.net with Vb)
by balajifeb14 (1 replies)
-
Web Services in E-Commerce application
by JamesBDB (1 replies)
-
Menu.css corrupting my other theme.css
by Montague (0 replies)
-
How to query multiple xml files?
by lamin (0 replies)
-
query regarding VB
by abe2308 (2 replies)
Related articles
Quick links
Recent activity
- James Crowley replied to I wanna developer in UK .
- Mihail Jvanecky replied to Converting flash files to EXE
- Mihail Jvanecky replied to Load flash movies directly ...
- Mihail Jvanecky replied to SDK for emulating a file system
- Mihail Jvanecky replied to DLL protection (embedd in o...
- Mihail Jvanecky replied to Effective tool for GDI memo...
Enter your message below
Sign in or Join us (it's free).