ASP And Acess And IIS
I am testing an app on my own development machine. I am using IIS 5 with ASP and MS Access. I have the Access database in a directory called Private located one level down from the Web App. When I run the app from the browser everything works just fine.
When I try to debug the app from within Visual Studio .net 2003, it can't connect to the database. If I run the app from within studio without debugging, it works. When trying to debug, I gave it the name and password of the administrator as prompted but it just can't connect. I have set up debugging in IIS.
View Replies
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
/MyWeb/DBConnection.asp, line 11
The password is correct in DSN and DSN works from vb Component but this asp page is giving this error.
Once this problem solved by restarting WWW service of IIS 5.0 in Windows 2000, but i have restarted it many times but the problem is there, I have also tried restarting my PC.
View Replies
View Related
I'm trying to restrict access to a page based on a session variable called MemberUserID, so the way I thought of doing it was to say if MemberUserID is not equal to this value, then you would get an error page, but the operator I'm trying to use is giving me an error:
<%
If Session("MemberUserID") != Name Then
Response.Redirect "error.asp"
End If
%>
is there a better way to do this?
View Replies
View Related
Can someone please help me with this ASp script?
What i am tryiong to do ? Trying to connect to access database
Is DSN set ? Yes
Operationg System ? XP Prof
DSN Name ? NW
<%set cnn = server.createobject("ADODB.Connection")
cnn.open "DSN=NW"%>
<%
cnn.close
set cnn= nothing
%>
View Replies
View Related
The following code runs in less than one second when used in an ASP page but when used in Session_onStart() in global.asa, the first page in a new session is delayed by more than thirty seconds. The code seems to work - its just slooow. Why is this so and how do I fix it?
Dim cnComDoc
Set cnComDoc = Server.CreateObject("ADODB.Connection")
cnComDoc.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:comdoc.mdb;Persist Security Info=False"
cnComDoc.execute "Insert into SessionInfo
(SessionID,BeginDateTime,IPAddress) values ('" & Session.SessionID & "','" &
FormatDateTime(now(), vbGeneralDate) & "','" &
Request.ServerVariables("REMOTE_ADDR") & "')",,adCmdText +
adExecuteNoRecords
Set cnComDoc = Nothing
View Replies
View Related
how to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
View Replies
View Related