Advertisement
Guest User

Untitled

a guest
Apr 6th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. <%@ Page aspcompat=true Debug=true %>
  2. <%
  3. Dim oConn, oRs
  4. Dim qry, connectstr
  5. Dim db_name, db_username, db_userpassword
  6. Dim db_server
  7.  
  8. db_server = "OS3-EC69267A548\SQLEXPRESS"
  9. db_name = "master"
  10. db_username = request.form("username")
  11. db_userpassword = request.form("password")
  12.  
  13. On Error Resume Next
  14. connectstr = "Driver={SQL Server};SERVER=" & db_server & ";DATABASE=" & db_name & ";UID=" & db_username & ";PWD=" & db_userpassword
  15. oConn = Server.CreateObject("ADODB.Connection")
  16. oConn.Open(connectstr)
  17.  
  18. If Err.Number <> 0 Then
  19. Response.Write("ACCESS DENIED")
  20. Else
  21. Response.Write("ACCESS GRANTED<br/>")
  22. qry = "SELECT @@VERSION;"
  23. oRS = oConn.Execute(qry)
  24. Response.Write(oRs.GetString())
  25. oRs.Close
  26. End If
  27.  
  28. oRs = nothing
  29. oConn = nothing
  30. %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement