Advertisement
Guest User

Untitled

a guest
Sep 28th, 2016
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. <%
  2. strconn="PROVIDER=SQLOLEDB;Data Source=192.168.101.3;User Id=sa;Password=11111;Database=TestDb"
  3. Set cnn = Server.CreateObject("ADODB.Connection")
  4. cnn.Open strconn
  5.  
  6. sqlstr="select * from Wallpaper order by id desc"
  7. Set conn = CreateObject("ADODB.Recordset")
  8. conn.Open sqlstr, cnn, 1, 3
  9. response.write conn("name")
  10. %>
  11.  
  12. <%
  13. function conndb()
  14. strconn="PROVIDER=SQLOLEDB;Data Source=192.168.101.3;User Id=sa;Password=11111;Database=TestDb"
  15. Set cnn = Server.CreateObject("ADODB.Connection")
  16. cnn.Open strconn
  17. conndb = cnn
  18. end function
  19.  
  20. cnn = conndb()
  21. sqlstr="select * from Wallpaper order by id desc"
  22. Set conn = CreateObject("ADODB.Recordset")
  23. conn.Open sqlstr, cnn, 1, 3
  24. response.write conn("name")
  25. %>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement