Autodesk Inventor

[#1]

Hi,

Is it possible to make a SQL database search and write from an Ilogic rule?

/Lars

[#2]

I would think that this would be possible since ILogic has the ability to run straight vb code. It does look like something that I would do when I could create a DLL to do the work for me and return back to ILogic the required info.

[#3]

Yes, this is exactly right. It's reasonably straightforward to incorporate the use of ADO.NET into your rules to add database access. We haven't yet delivered samples on this, but others in the community have done this, and I'm sure could provide some examples of what they've done.

Jeff

[#4]

I am also trying to read data from an SQL file.   I have written a DLL which is accessed from iLogic using the AddReference command When I try to use the rule I get the error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine" when I call the read SQL function in the DLL.

The code was originally written in the ipart in VBA and worked without any problems.

Can anyone help, or give an example of what I should do?  Is there something I should be registering?

Alistair