I have code that instantiates a sqlserver object and starts a job. I
have used this on numerous XP workstations successfully, when I tried
to move this to a Windows 2000 Application Server attached to a Small
Business Windows 2003 network and run the code, I am receiving the
error:
Automation Error. The Operating System Cannot Run %1.
(Error Number -2147024714)
The following is a code snippet:
*********
Dim app As New SQLDMO.Application
Dim oSQLServer As New SQLDMO.SQLServer
Dim oJob As SQLDMO.Job
oSQLServer.LoginTimeout = 30 ' ERROR OCCURS HERE
oSQLServer.LoginSecure = True
**********
The code fails when setting the LoginTimout parameter. The SQLDMO.dll
has been registered successfully on the server.
Any ideas whey the behavior of this code is different on my application
server vs the client workstations on the network?
Thanks
Mike G