SQLDMO - Operating System Cannot Run %1

[mgorman]

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.Applicat ion
Dim oSQLServer As New SQLDMO.SQLServe r
Dim oJob As SQLDMO.Job

oSQLServer.Logi nTimeout = 30 ' ERROR OCCURS HERE
oSQLServer.Logi nSecure = 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

[mgorman]

As an addendum:

I had a batch program that copied certain dlls to directories on my
local machine. All of the XP machines utilized the directory
c:\windows\Syst em32. The server however utilized the directory
c:\WINNT\System 32. Hence, my batch file was failing to copy over some
of the pertinent batch files ( I had hardcoded the path instead of
using system variables). In any event, this got me through the issue
of setting parameters on the SQLServer object. However, when I tried
to use the connect method (oSqlServerObje ct.Connect "<Server Name>",
"Login ID>","<Password >") I am now getting the error message
[Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier.
Using intellisense, I am definitely sending the connect method the
proper parameters, and, as I mentioned before, it works on my XP
desktops. Any ideas? Thanks.

[mgorman]

I ended up going back and installing MDAC 2.8 on the application
server. This must have resolved an issue with one of the dependent dll
files. My application works fine now.