Running Queries from Visual Studio Application

[anicolais]

I am trying to run Queries on my MYSQL Database that is hosted over the web and integrated with Sugar. I need to set it up to only allow certain users to have access to certain data so I am thinking about setting up small applications using Visual Basic in Visual Studio. What would be the process I need to follow to get my database to connect in visual studio?

Thanks
SugarCRM CE 5.5
Windows VIsta
MYSQL
Visual Basic

[Angel]

You can get a .NET Data Provider from here: http://dev.mysql.com/downloads/connector/net/5.0.html

Not sure if you've made arrangements to address this, but most hosting providers do not allow direct access to the MySQL server, which would present a problem for what you are trying to do.

If that is the case, you might want to instead access the data via the Sugar SOAP API.