I have the Oracle not-logged on error that keeps popping up intermitently. When I restart the web server the problem is solved and everything is fine. I am unable to figure out what the problem is?
I do not have this problem with other websites running on the same web server. Can any one advise about what I need to do to solve this or atleast what direction I need to look?
I had developed a messageboard in asp which allows users to post new messages,reply to existing messages.I am using textarea (Html tag) for a messagebox in my asp page .When the user enters any characters in messagebox except a single quote ('),the message gets inserted in oracle database without any problem.But if message contains single quotes (') , while inserting in a database it gives the following error
"Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00917: missing comma ".
Is there any solution to insert messages containing single quotes in a database?
im trying to add the values in 2 taables using asp + oracle 9i error
OraOLEDB (0x80040E14)
ORA-00936: missing expression
Code:
My system is on a NT4 (w/SP6a) running IIS 4. I am developing a page that query one record from my Oracle DB 8.1.6 on a separate machine. I am using the MS ODBC for Oracle drive. In my ASP page I have (Connection object has been crreated.) then..
View Replies View RelatedHow do i connect to Oracle Database through ASP? I have Used the Following Syntax But it gives me ADODB .Connection error no as '800a0e7a' saying Provider Cannot be Found.
set objcn1=server.createobject("Adodb.connection")
objcn1.Open "Provider=OraOLEDB.Oracle;Data Source=servername;User Id=abc;Password=cbs"
OR
objcn1.Open "Provider=msdaora;Data Source=servername;User Id=abc;Password=cbs"
When a User has Loged In to my site, I would like to display Logged In as:
and then a link to log them out of the site Code:
How do we have a track of users who have logged in? I want to have a table of record with usernames and the status(logged in or logged out).
Whenever the user logs in, the status shud indicate he is logged in and when he logs out the status shud change accordingly. Does anybody know how to do this???
I want to create a page in ASP language which gives me information about
currently logged users. I thought to do it by this way: when somebody
will log in to page, there will be a value of this user id stored in the
table among the other fields in the form which are filling in. After
clicking on the button "Log off" the value of the user id will be
deleted from the MS SQL Server 2000 database. I would do it, but I don`t
know how to solve the problem when somebody will close the Internet
Explorer window by clicking "x". Then the procedure of deleting a value
of user id will not call, and this value will be still stored in the
database, so I will not have actual state of currently logged users.Maybe there is another possiblity to do it?
I have a website where about 300 to 500 are logged in all the times. I am trying to find a way to see who's logged in right now.I learned that session variables can produce such an outcome. Every member, who is logging in, is recognized by saving that member's unique user ID in a session variable.
View Replies View Relatedi have the following script in one of my logged in pages.
Active Users: <%=Application("CurrentNumberOfUsers")%>
Is there any code that I can add to this which also hows who is logged in to the website?
i set up a login page and when the user logs in he/she is directed to the main site. What I wish to know is how can I show the user name that is logged in the main site:
For example:
Logged in as:
Username
tell me the code as i am new to ASP .
I need some asp code that can give me the user that is logged on to the PC.
View Replies View Relatedit was possible to query the logged in windows user from a remote machine. I'm thinking of designing a website that will tell you what users are logged in where. This isn't really necessary but I thought it might be nice to know and keep track of users.
View Replies View RelatedI'm developing an intranet site that will require knowing who is accessing the site. Since all of my users are using a WIndows domain, I figured I could cut the necessity to log into the intanet site if I could identify each user based on who is logged into the workstation being used to access it. So I figured I would need some Microsoft-specific tech to get this done.
Is something like this even possible? I figure ASP .NET would be my best hope, but seeing that I've never programmed for a Microsoft environment, I would need some coaching. Here's how I thought this could be accomplished (I may need some help filling in the details):determine the IP of the machine accessing the sitedetermine which machine on the network currently has that IPask Active Directory who is currently logged into that machineI don't know that this is possible in this manner, though. Anyone accomplish something like this before? I would think so as it seems like something a lot of developers would want for web applications.
below is an insert statement on an asp page that stores the date and time
that a driver logged on, what I need is to check that they are now already
logged on fields are SQL Server 2000
ID int
DRIVER_NO int
ON_DATE datetime
OFF_DATE datetime
ON_NOW nvarchar
SESSION_ID int
The ON_NOW column reads on or off depending whether the driver logged out or
not, if they havent we need to close the previous logon session and mark it
with 'off' and enter a date time into OFF_DATE column. Code:
I am trying to build an sqldatasource using a parameter which I want set to the currently logged in user's username. Any idea how to declare the parameter in the <SelectParameter> tag? I am using .net 2.0...
View Replies View RelatedI would like to know how to let users log in to my page and keep track of them until they log out? Will i be using cookies or what?
View Replies View RelatedI use a database to authenticate users. Thier logon info is stored in a session.When the session times out it redirects the user back to the login page,which, when logged in sends them to the secured homepage.How can I return them to the page they were on when the session timed out,rather than starting over on the homepage?
View Replies View RelatedI have a LOGIN.asp page which will ask the user to input their username and password. The text box name for this two text field is txtUsername and txtPassword. What i want to do is to display the value of "txtUsername" in my main page after the user has logged in! That means what ever that the user enter in the username text field, it will be display in the next page. how to code this in ASP session variable?
View Replies View RelatedI have an asp website which allows registered users to login in, I want to create a page which shows the names of all logged in users. Can i do this in asp, and if possible can some one tell me how can i let the logged in users communicate with each other.
View Replies View Relatedhow i can pull the logged in user name from a computer for a web form? this is what i did to pull from the cookie when user log into my site but now i want to get request from non site users but capture non logged in users ids too.
~ <input type="text" name="EmailID" maxlength="10" size="10"
Value="<%=Request.Cookies("NPSC")("UserName")%>"
~
This is the code for my default asp page.
<%
'Check if user is logged in
if Session("name") = "" then
'If not, go to login page
Response.Redirect("login.asp")
else
'If, build page
Response.Write("<title>ASP Page</title>")
end if
%><body leftmargin="100" text="#004080" bgcolor="#EBEBEB"><p><font size="6">
I want users that have been logged on successfully to be redirected to a website address that I specify.
Any Ideas?
I last posted to this group about 6 months ago and was very pleased by the
excellent response I got and the great help offered to me. I am back this
time with another request for your expert help on a bit of ASP code I use on
my windows server 2003 with IIS6 machine.
I would like the code below to display in different colours depending on the
status of the page. I am looking to make the not logged in code appear red
and the logged in code green.
The code:
How to get the Windows current logged user name using Classic ASP. If no direct way are there any work arounds.
View Replies View RelatedMy asp application allows a number of users to log into it. Each user has a different type of access level (General User, Manager or Administrator). I want the administrator to be able to see how many other users are logged into the application at a particular time. How can I do this? Would the use of an application object work for this?
View Replies View RelatedHow can I get the user ID (Novell 5, IIS5 on Windows 2000 Server) using ASP?
I did find an example using JavaScript however it uses an ActiveX control
and then all my users would have to click OK to allow the control to run.
Or I could change the security setting, but we are talking over 1,500
machines.
I have this asp page (see code below). It grabs the values from the previous page and populates the email which gets sent to the recipient from the person bidding on his product. I need to grab the bidder's email address (he is logged in when sending this email) from the database.
I can't seem to figure out the code for grabbing a logged in visitor's information from the database to display in the "From" field. Can anyone help? I need the code that grabs his email address, and the code that goes in the "mailer.from" variable to populate that field. Here's the code:
I'm building a website using the oracle database engine. i'm conneting
to the database using the odbc. the database is created on a webserver.
when i'm using the odbc on my local workstation the connection works.
but when i'm trying to publish the site i receive the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in
OraHome92).
/arabic/news_index.asp, line 46
line 46 is when i'm opening the connection.
Note: what i mean with "my local workstation" is when i call the
website using the localhost. and i mean by "publish the site" is by
giving the website a dns name.
When I place a record set on an asp page designed in dreamweaver. I get the following error when i try to run d page.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 127
I am connected to the database i can see my tables i was able to make a record set but when i place it on the pace and try to prview the page in internet explorer i get the above error. I have used oracle 10g to create the database.
i would like to ask what is the best and easiest way to connect an ASP application to an ORacle database? i will be accessing the database server from our network. do i still need to install anything in my local pc?
View Replies View RelatedI know how to connect with Access.How can we connect ASP with oracle without mentioning the Data Source Name?
View Replies View RelatedI written a procedure in oracle which returns a value. What all I want to do is to hold the value in a ASP vairable. The Oracle procedure,
create or replace procedure tat
(j out number,i in nnumber,k in number)
is
begin
j:=i+1;
end tat;
I need to get the value of j in a variable & how to pass more parameters. i need this to be handled in asp i will pass through request form and call the procedure, and the procedure will return a value that also has to be hold.
My asp application is connect to oracle database. However, when i try to open the default page, an error occurs and i receive this message:
- Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'MoveFirst'
The code that is causing this error is following:
Code:
<%
Dim objConn
Dim rsForums
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=ORCL9; uid=toy; pwd=yes;"
Set rsForums = Server.CreateObject("ADODB.Recordset")
rsForums = objConn.Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
%>
<table width="100%" align="center" cellspacing="0" cellpadding="6" border="1">
<tr>
<td width="60%">
<p><b>Forums</b>
</tr>
<%
While Not rsForums.EOF
%>
<tr>
<td><a href="forum.asp?ForumID=<%= rsForums("ForumID") %>"><B><%= rsForums("Forum") %></B></a>
<BR>
<BLOCKQUOTE>
<%= rsForums ("Description")%><BR>
<SMALL>[Total Posts: <%= rsForums("Posts") %>] [Last Post on <%= rsForums("LastPost") %>]</SMALL>
</BLOCKQUOTE>
</tr>
<%
rsForums.MoveNext
Wend
rsForums.Close
The forums table in the oracle database has 2 lines of records, and it should not occur this error. Do you have any idea what is happenning?