Advertisement
Guest User

Untitled

a guest
May 26th, 2016
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. Set ConnectionString = Server.CreateObject("ADODB.Connection")
  2. ConnectionString.Open "Provider=SQLOLEDB.1; Password=pass@123;User ID=sa;Initial Catalog=USERDB; Data Source=SQLMSSQLSERVER2014;"
  3.  
  4. Dim rs
  5. strSQL = "SELECT * FROM user WHERE username= 'test' AND Password='test123'
  6. rs.Open strSQL, ConnectionString
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement