Using dotconnect to connect remotely to MySql

Using dotconnect to connect remotely to MySql

Postby CAVU » Tue 05 Oct 2010 00:51

I'm attempting to use dotconnect to connect remotely to a MySql database on a shared host.

Since I am new to dotconnect, I am hoping someone can answer these questions.

1) Can I use dotconnect to tunnel (HTTP) to the database since the shared host will not allow remote access to the database. I have already installed the tunnel.php scripted installed on the server and it is working.

2) Can I use VB6 versus .net to make the ADO connection? In other words I want to make the connections independent of any dotconnect GUI. If so which component do I need to install. I can't figure out how to install it.

3) Which version of dotconnect do I need?

Thanks for the help
CAVU
 
Posts: 1
Joined: Tue 05 Oct 2010 00:41

Postby StanislavK » Wed 06 Oct 2010 16:03

1) dotConnect for MySQL supports HTTP tunnels. For detailed information on this, please refer to
http://www.devart.com/dotconnect/mysql/docs/Tunneling.html#tunnel

2) We are now analyzing the possibility of using dotConnect for MySQL in unmanaged code. We will inform you about the results as soon as our investigation is completed.

As for connecting without GUI, the components necessary for this are available in the Devart.Data.dll and Devart.Data.MySql.dll assemblies.

3) HTTP tunneling is available in the Standard, Professional and Developer editions. Provided that it is the only advanced feature you need, the Standard edition should be sufficient. For detailed information on edition differences, please refer to
http://www.devart.com/dotconnect/mysql/editions.html

Feel free to contact us if anything is unclear.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for MySQL