EldoS | Feel safer!

Software components for data protection, secure storage and transfer

MySQL Does not work through a tunnel

Posted: 04/03/2007 12:37:30
by Rocco Valotta (Standard support level)
Joined: 04/03/2007
Posts: 3

I would like to say that I am also having trouble getting MySQL to work through a SSH Tunnel.

I've taken your LocalPortForward application, Installed the MySQL-Connector-Net-5.06, added it as a refrence made the forwarding port 3306 and just added a few lines.

At the top
Using MySql.Data.MySqlClient;

Attached to a button event
            String sQuery = "Select id from users_sequence;";
            MySqlConnection cn = new MySqlConnection("Database=itsfeedback;Uid=UserID;Password=Password;pooling=false");
            DataTable data = new DataTable();
            MySqlDataAdapter da = new MySqlDataAdapter(sQuery, cn);
            MySqlCommandBuilder cb = new MySqlCommandBuilder(da);

it will stop on the Fill

P.S. Replace the User-ID and Password with appropriate values

The table users_sequence is a single table with one field "id" that is of type Int(11) and manually assigned the value 30.

If you want source code i'll be glad to share what i've written
Posted: 04/03/2007 14:20:21
by Ken Ivanov (Team)

Thank you for the message. I answered to the parallel topic.



Topic viewed 5739 times

Number of guests: 1, registered members: 0, in total hidden: 0


Back to top

As of July 15, 2016 EldoS business operates as a division of /n software, inc. For more information, please read the announcement.

Got it!