How can I connect MySql database on windows phone 8.1 using vb?

[altjen]

Hi every one. I post a topic similar with this at mobile development section but posted here too because I need help from a VB.net programmer

I want to create a software for my windows phone 8.1 but already stucked on online database.

I tried to use this VB code that I use for 1 of my softwares

Mysqlconn = New MySqlConnection
        Mysqlconn.ConnectionString = "server=db4free.net;Port=3306; user id=a****; password=******; database=****"
        Try
            Mysqlconn.Open()
            Dim Query As String
            Query = "SELECT Count(*) FROM Drejtoret WHERE Name='" & TextBox1.Text & "' AND Password='" & TextBox2.Text & " ' "
            Command = New MySqlCommand(Query, Mysqlconn)
            Dim count As Integer = Command.ExecuteScalar
            If count > 0 Then
                MsgBox("Welcome'" & TextBox1.Text & "'")
                'Assign the property value and show the form
                Form1.Show()
                Me.Close()
            Else
                MsgBox("Please try again. Your data are not correct", MsgBoxStyle.Critical, "Error!")
            End If
            Mysqlconn.Close()
        Catch ex As MySqlException
            MsgBox(ex.Message)
        Finally
            Mysqlconn.Dispose()
        End Try

but this doesnt work on windows phone app.
can any one help me?

[Santanu.Das]

From my opinion there is a problem in construction of connection string.
Please see here.http://www.connectionstrings.com/mysql/

[altjen]

can you suggest me anything sir?

[altjen]

many researchs over google and youtube and still nothing...
is there any way how to do this?

[Santanu.Das]

The type of your connection string should be

Server=ServerAddress;Port=3306;Uid=myUsername;Pwd=myPassword;Database=DataBaseName;

Please check your connection string.

[altjen]

no no I mean cant import Mysql data
at the beggining

something like this

Imports MySql.Data.MySqlClient

cant add and Reference of Mysql Data..
but can import reference of SQLite for Windows Phone 8,1

any suggestion?

[pritaeas]

It can reference SQLite because that can be installed on the phone. If you want to load data, I think you're stuck with creating a webservice, instead of connecting to MySQL directly.

[altjen]

I want to import datas from my database at db4free.net

and do you suggest any website or db hoster?

[altjen]

so what suggestion do you have guys?