How to use Macola DLL connection in VB? connection?

[Huanghonglu]

Any one know how to set up the db connection for the Macola DLLs? Thanks

 

[dgillz]

I don't believe this is available.

Exact made some steps in this direction, and the .dlls certaily exist, but there is no documentation on how to use this whatsoever.

If I am wrong would one of you programmers out there please correct me.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

 

[Huanghonglu]

You are right, there is no document at all. However their developers said it does work and they do not want to give out the information. I am wondering if anyone had experience using those DLLs in this forum.

Since the Synergy and ES db had more than one tables have the item information, I would like to use their DLL to cover all those tables.

 

[stravis]

Hello,

I just did some testing and managed to make the following code work for establishing a connection to the database and adding an item to Macola ES.

Dim mf As New IMMasterES.iMasterFiles
Dim im As New IMMasterES.cItemMaster
    
mf.ConnectToDatabase ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=001;Data Source=ISPRING121\ES")
        
im.AddNew ("MYITEM")
    
im.ItemDescription1 = "My New Item"
im.Update

This was done using the "Macola Business Object - IM Master ES" object from withing VB 6. The ConnectToDatabase function takes an ADO Classic connection string. This answers your direct question, but I'm sure you will have to do some hunting around to finalize this solution.

Regards,
Scott Travis
infoSpring, LLC.