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
Using dotconnect to connect remotely to MySql
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
1) dotConnect for MySQL supports HTTP tunnels. For detailed information on this, please refer to
http://www.devart.com/dotconnect/mysql/ ... tml#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.
http://www.devart.com/dotconnect/mysql/ ... tml#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.