| Just spent a few days working out why a userexit.vbs script that works with BDD2007 failed on MD so I thought I'd better share it. Error showed up as a Type Mismatch error in userexit.vbs
The basic problem is that ZTIUtility.vbs no longer creates a global dictionary called dicSQLConnections. The userexit.vbs was calling an SQL stored procedure using a connection that used to be kept in dicSQLConnections. Original code was: set rs = createobject("adodb.recordset")
Set conn = dicSQLConnections("MCRSMS01")
rs.Open "Exec spSS_RoleSelect",conn Fixed code: Dim oSQL
Set oSQL = new Database 'object defined in ZTIUtility
oSQL.SectionName = sDetail 'populate object
set rs = createobject("adodb.recordset")
Set conn = oSQL.Connect
rs.Open "Exec spSS_RoleSelect",conn Hope this helps someone else!
|