Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function connectToDatabase() {
- var connection = new ActiveXObject("ADODB.Connection");
- var srv = "ServerName";
- var database = "Database";
- var user = "Username";
- var pswd = "Password";
- var connectionstring = "Data Source=" + srv + ";Initial Catalog=" + database + ";User ID=" + user + ";Password=" + pswd + ";Provider=SQLOLEDB";
- try {
- connection.Open(connectionstring);
- var rs = new ActiveXObject("ADODB.Recordset");
- var query = "select * FROM [Database].[dbo].[Table]";
- rs.Open(query, connection);
- rs.close;
- connection.close;
- }
- catch(e){
- alert(e);
- return;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement