Error Connecting MySQl in Vb.net Add-in

[BM_Ashraf]

Hi,

I'm building an Add-in for Inventor. One of the Functions is really simple just to connect to MySQl and read some data.

I have done that before using VB.Net Application. Now i tried to do the same Connection from the New Add-in (.dll) I get an Error and can not open the Connection

This is the Error message that i get from the Add-in (.Dll)

The same test on a Windows form Application (outside of Inventor)

I think the Problem is related to Inventor or how the Add-in tries to establish the Connection.

Does anyone have any idea of how to get it working?

[JelteDeJong · Accepted solution]

I have no experience with MySql and addins but here are some thoughts.

• I assume you have checked the connection string?
• the addin runs in the process of Inventor. Have you tried to start the SQL connection on a different thread?
  • Running codeonanother thread could in it self be aproblem for Inventor. So if it doesn't solve your problem stay away from it.
• Inventor use in the background SQLite. Maybe that is an issue. Are you bound to MySql?
  
  • SQLite version info: https://modthemachine.typepad.com/my_weblog/2023/01/3rd-party-libraries-used-by-inventor-2023.html

[BM_Ashraf]

Hi,

Thanks alot for your Reply, I really appreciate your work I'm a great fan of your work !

Yeah, the Connection string is working fine.

Yeah, i had to cut this part of the Process to be done outside of Inventor and it's working great.

Thanks again for your help !