Connection to MySQL through HTTP using Vb.NET

[rizwan6feb]

Hi all, i am looking for a way to connect to a Remote MySQL server through HTTP using VB.NET. Actually my application has no direct access to internet. The application connects to a proxy server which is blocking access to database server. The proxy server only allows web requests. How can i connect in this scenario. Please help

[kenobewan]

I believe that it can be done via HttpWebRequest. One example I saw used https and this code:

req.Proxy = GlobalProxySelection.GetEmptyWebProxy();  

[rizwan6feb]

Thanks kenobewan
Previously i have been using the following code to connect to MySQL server after adding a reference to MySQL.Data.dll

        Dim cnString As String
        cnString = "server=xxx.xxx.xxx.xxx;database=dbname;UID=user;password=123;"
        cn = New MySqlConnection(cnString)
        cn.Open()
        MsgBox("connected")
 

xxx.xxx.xxx.xxx is the ip address of MySQL server

I have no idea how to use HttpWebRequest with above code.

[kenobewan]

Here is an article that may help:
A Deeper Look at Performing HTTP Requests in an ASP.NET Page