EldoS | Feel safer!

Software components for data protection, secure storage and transfer

MySQL Does not work through a tunnel

Also by EldoS: CallbackDisk
Create virtual disks backed by memory or custom location, expose disk images as disks and more.
#2668
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
Code
Using MySql.Data.MySqlClient;


Attached to a button event
Code
            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);
            da.Fill(data);


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
#2674
Posted: 04/03/2007 14:20:21
by Ken Ivanov (EldoS Corp.)

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

Reply

Statistics

Topic viewed 5519 times

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




|

Back to top

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

Got it!