Advertisement
Guest User

Untitled

a guest
Nov 14th, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. function connectToDatabase() {
  2. var connection = new ActiveXObject("ADODB.Connection");
  3. var srv = "ServerName";
  4. var database = "Database";
  5. var user = "Username";
  6. var pswd = "Password";
  7. var connectionstring = "Data Source=" + srv + ";Initial Catalog=" + database + ";User ID=" + user + ";Password=" + pswd + ";Provider=SQLOLEDB";
  8. try {
  9. connection.Open(connectionstring);
  10. var rs = new ActiveXObject("ADODB.Recordset");
  11. var query = "select * FROM [Database].[dbo].[Table]";
  12. rs.Open(query, connection);
  13. rs.close;
  14. connection.close;
  15. }
  16. catch(e){
  17. alert(e);
  18. return;
  19. }
  20. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement