Go Back   Access World Forums > Apps and Windows > VB.NET

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-10-2014, 11:10 PM   #1
bjsteyn
Newly Registered User
 
Join Date: May 2008
Posts: 108
Thanks: 1
Thanked 9 Times in 9 Posts
bjsteyn is on a distinguished road
MySQL Server not accepting connection over VPN unless Telnet first

Hi

We are using a OpenVPN as our VPN software to access mysql databases across the country with MySQL Server 5.1 running on the hosting servers.

I am using VB.NET with MySQL Connector 6.6.4 for software to run queries on the databases on the VPN, but for some reason on the one server on the VPN it doesn't want to open a connection with my .NET application unless i telnet the port first.

This is what i normally do:
Open cmd.exe
telnet 10.?.?.? 3306
As soon as the connection opens i run my software. Sometimes it opens a connection and runs the queries, sometimes it doesn't.

Also sometimes i ping the server and everything is fine, but i can't open a telnet connection.

It is like the mysql server is sleeping sometimes and i need to wake it up before i try and open a connection.

Does anybody know what this can be and have a solution for this?

Thanx
BJ

bjsteyn is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Server gone - Relink MySQL Tables cdlpatrickusa Modules & VBA 0 07-18-2013 12:09 PM
Basic PHP/MySql Connection speedman_2001 PHP & MySQL 6 03-09-2012 06:09 AM
Local SQL Server vs. Online mySQL Server G37Sam General 5 10-06-2011 06:31 PM
Remote Connection to MYSQL Steve R. PHP & MySQL 2 01-28-2010 08:06 PM
[SOLVED] Connection to MySQL thru DSN osvaldo General 4 05-07-2006 09:02 PM




All times are GMT -8. The time now is 01:51 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World