Not connecting to SQL Database during OSD
I am working with SCCM and I want to display some item from Database during OSD. But its not making the connection with SQL database :
following is my VB script,and i am connecting with a SQL express database.
Do i need to add any driver. This step is running after apply operting system step in the task sequence.
MsgBox("Started")
Set db = CreateObject("ADODB.Connection")
cnstring = "Provider=SQLOLEDB.1;Password=myPassword;Persist Security Info=True;User ID=sa;Initial Catalog=Serial;Data Source=Myserver\SQLExpress"
db.open cnstring
Dim rs
Set rs = CreateObject("ADODB.recordset")
Set rs = db.Execute ("Select * from machine where sn = '"& strNewName &"')
strValue = rs("Dept")
MsgBox(strValue)
Script is executing fine in a running OS, but not executing during OSD.
Any help would be appreciated.Thanks Chandan
May 24th, 2011 6:49am