Murray Brown
asked on
Javascript reference in ExcelWebAddIn Project
Hi
To use the following code in my JavaScript what reference would I have to make
"Microsoft ActiveX Data Objects 6.0 Library" and it didn't work
To use the following code in my JavaScript what reference would I have to make
"Microsoft ActiveX Data Objects 6.0 Library" and it didn't work
connection = new ActiveXObject("ADODB.Connection");
var ConnString = "Provider=SQLOLEDB;Data source=xxx;Initial catalog=Demo1;User Id=xxx;";
connection.open(ConnString);
var rs = new ActiveXObject("ADODB.Recordset");
rs.Open("SELECT [Company] FROM [Contacts]", connection);
rs.MoveFirst();
while (!rs.eof) {
document.write(rs.fields(1));
rs.MoveNext();
}
rs.close();
connection.close();
I get this serrorASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER