TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Mayur Gujrathi
386
3.9k
1m
Error in database connection in classic asp
Mar 1 2013 8:42 AM
Error
Operation is not allowed when the object is closed.
<%@LANGUAGE="VBSCRIPT" aspcompat=true%>
<%
If request("submit") <> "" Then
Dim connectionstr1, rs, Sql,newcon
Connectionstr1 = "Provider=SQLOLEDB.1;Password=d@45678;Persist Security Info=True;User ID=Mallik;Initial Catalog=buildshopping;Data Source=BD-SRV\MSSQLSERVER2008"
newcon = server.createObject("ADODB.connection")
newcon.open(connectionstr1)
Sql = "sp_Check_Login_New_Rights '" & UCase(Request.Form("txtEmailID")) & "', '" & Request.Form("txtPassword") & "' "
rs = Server.CreateObject("ADODB.RecordSet")
rs.open(sql,newcon)
If Not rs.Eof Then 'I am getting error here
%>
<script language="javascript">
window.opener = 'x'
window.open('', '_parent', '');
window.close();
window.open('asp2.asp', '', 'toolbar=no,directories=no,location=no,status=yes,menubar=no,resizable=yes,scrollbars=no,left=0,top=0,width=' + (screen.availwidth - 10) + ',height=' + (screen.availHeight - 50));
</script>
<%
Else
Response.write ("Invalid User ID Password")
End if
newcon.Close
End If
%>
Reply
Answers (
2
)
getting error while applying css to the master file and aspx
what is DOM (Document Object Model)?