ajaywazir - Wednesday, July 9, 2008 4:48 AM:
Hi
We are trying to use com compatible IOM.dll in excel using VBA (Aras V 9.0.1). The DLL is registered and is visible. It can be loaded in the VBA macro.
I am trying to connect to the server using the following code
Sub main()
Dim url As String: url = "localhost/.../InnovatorServer.aspx"
Dim db As String: db = "InnovatorSolutions"
Dim user As String: user = "admin"
Dim password As String: password = "innovator"
Dim factory As New IomFactory
Dim conn As HttpServerConnection:
Set conn = factory.CreateHttpServerConnection(url, db, user, password)
Dim login_result As Item: Set login_result = conn.Login
If login_result.IsError Then
MsgBox "Failed to login"
Exit Sub
End If
Dim inn As Innovator: Set inn = factory.CreateInnovator(conn)
End Sub
However, the line
Set conn = factory.CreateHttpServerConnection(url, db, user, password)
gives an exception error "automation error 80131700", after some search on the net I found this http://support.microsoft.com/kb/908002/. Which talks about this kind of problem.
Do you have any other method connect to the server from MSExcel?. (server is up and running correctly)
Regards
Ajay
ajaywazir - Saturday, September 6, 2008 9:47 PM:
Hi
Any one have any ideas?
muethomas - Tuesday, October 7, 2008 5:42 PM:
IOM.dll has been build with .NET 1.1. Please install .NET 1.1 on the Office Workstation including newest Patch and try it again.
Thomas
mozes - Tuesday, December 9, 2014 2:12 PM:
I had the same problem, eventually I had to resort to the use of "Msxml2.ServerXMLHTTP"
which works fine btw, (if you do not use active-directory to logon)
If someone has a simple excel-sheet that can connect to innovator using IOM.tlb.
I for one would love to put my hands on it.
