SocketException: when connection through mysql

Hello friends,

I want to create a connection between mysql remote server and asp.net

Where database server information is as follows

my webconfig code is as follows

In code behind on page load

Dim str As String = ConfigurationManager.ConnectionStrings("rtd").ConnectionString

Dim conn As MySqlConnection = New MySqlConnection(str)

Dim cmd As MySqlCommand = New MySqlCommand("SELECT * FROM realtime order by id desc limit 1")

Dim da As MySqlDataAdapter = New MySqlDataAdapter()

cmd.Connection = conn

da.SelectCommand = cmd

Dim dt As DataTable = New DataTable()

da.Fill(dt)

rtgrid.DataSource = dt

rtgrid.DataBind()

when is am execute following code socket exception occurs and error is below

SocketException: A connection attempt failed because the connected party did not properly respond after a period

of time, or established connection failed because connected host has failed to respond

can anyone suggest me where I am wrong?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuman Sahu6y ago
Hi pritaeas

You are saying firewall may block prot 8090, but i am directly access remote server using login and password with port no 8090.
0
Guest User6y ago
Is your firewall perhaps blocking port 8090 ?
0