Previn Kumar - Thursday, April 21, 2011 12:11 AM:
Hi,
Is it possible to call a stored procedure in another sql server database using IOM.dll. If it is possible how to do that.
Please help me.
Thanks
Previn
aknourenko - Thursday, April 28, 2011 12:35 PM:
No (I assume that you meant: IOM.Innovator.applySQL(...) method). In general, to use IOM.dll one has to establish a connection to an Innovator server. This is done when you create a connection to an Innovator server (e.g. IomFactory.CreateHttpServerConnection(...)). Note that when you connect to Innovator server you have to specify a particular db as a single server can support multiple DBs; from user stand point each serverdb combination is a separate instance of Innovator. User has to log into the Innovator instance after which all IOM calls (including Innovator.applySQL(..)) will be sent to this Innovator instance.
If in your application you have to connect to a totally separate non-Innovator SQL database you have to write your own code that does it. Fortunately there plenty of books and MS documentation that can help you here :-)
