Create Connection ConnDummy01 ConnString "Driver={SQL Server};Server=sqlbeta;Database=lookup1;UID=uid;PWD=pwd"
Set oCacheConn = WScript.CreateObject("ADODB.Connection") With oCacheConn .ConnectionString = "Provider=VFPOLEDB.1;Data Source=c:\my.dbc" .CursorLocation = 2 ' adUseServer .Mode = 16 ' adModeShareDenyNone .Open End With cExecString = "Create Connection ConnDummy01 ConnString " &Chr(34)& "Driver={SQL Server};Server=sqlbeta;Database=lookup1;UID=uid;PWD=pwd" & Chr(34) WScript.Echo cExecString oCacheConn.Execute(cExecString)