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 = "http://localhost/InnovatorServer/Server/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