Set connStr = Server.CreateObject("ADODB.Connection") connStr.Open "Provider=SQLOLEDB; Data Source=#####;" & _ "Initial Catalog=#####;UId=#####;pwd=#####;"