SQL Server Job and ActiveX | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL Server Job and ActiveX

Ok, forum: Another question relating to the wonderful world of 64-bit.
We are migrating our old 2000 server to 2005, along with jobs that calls an ActiveX component (dll) through VBScript. Naturally being compiled in the 32-bit world, it doesn’t work and gets the error ‘ActiveX cannot create the component’
We wanted to use the new ActiveX type in the job step – which seemed perfect, except for the 32/64 incompatibility.
After several troubleshooting steps, we discovered that the job agent invokes the 64-bit cscript.exe (which is in system32). When we invoke the vbs script via cmdline using the path to cscript in WOW64 it works.
But, how (if) can we force the ActiveX job type to use 32-bit cscript? Please advise
TIA!
Have you tried in searching VB & Activex related forums? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Try creating the batch file to execute vbs file and execute batch file using OS command in the sql job.
Mohammed U.
]]>