Hmmm, I would give you that information if I only knew what you ment. (I’m more of a Linux man). So I asked our DBA and he didn’t know either. But for the old monitoring system they used to be something like this in place, does that help?
Dim cn, rs, sqlStr, strResult, htmlcolorcode
Set cn = CreateObject (“ADODB.Connection”)
cn.Open “Provider=SQLOLEDB;Data Source=” & strServer & “;Initial Catalog=master” & “;Integrated Security=SSPI”
Set rs = CreateObject (“ADODB.Recordset”)