SAAuto14 Problem

[Christopher_Pai]

I wrote a C# utility for dynamically adding sql scripts to an ISM using an autogenerated SAAuto14 interop. When I run on my dev machine it works but on my clean machine with SAB2008 installed it fails.

Just to make sure it wasn't a strange C# problem I wrote a small vbscript snippet and it confirms the problem.

set project = createobject("SAAuto14.ISWiProject")
project.OpenProject( "foo.ism" )

for each connection in project.ISWiSQLConnections
	connection.InsertSQLScript( "foo.sql" )
next
project.SaveProject
set project = nothing

BTW, that's not a typo... I'm calling InsertSQLScript and it's complaining about AddSQLScript.

Any thoughts?

[Christopher_Pai]

I seems like the real problem is SAAuto14.ISWiSQLScript. If I run:

set foo = CreateObject("SAAuto14.ISWiSQLScript")

It'll work on my dev machine but not my clean machine.

[sternr]

You need to register the Dll before using it
(That's why it worked on your dev machine - IS registered it during the install of the IDE)

[Christopher_Pai]

I've tried that and uninstall/reinstall. Something funky is going on.... when I look at SAAuto14.dll using COM Explorer some of the ClsId's are different from one machine to another.