Online Remote MySQL using Visual Basic .Net

Question

0.00/5 (No votes)

See more:

Hi this is joshua.
I would like to ask everyone here if any of you know good Mysql database hosting services with reasonable prices.

I have developed a time and attendance system using Visual Basic .Net
Now i would like to work like an online app where my app will just be install to a clients pc and its database is hosted somewhere else and access via (tcp/IP, user id and paasword) static connection

To understand me more i simple need an online mysql database hosting like the service they offer in "db4free.net" the only problem here is that db4free.net is not for production use.

I want my app to connect to an online mysql database via .Net connector using static tcp/ip, user id and paasword

Posted 9-Jun-12 19:44pm

JMAM

Add a Solution

2 solutions

Solution 1

Why?
All you really need is to host your DB on a site that allows database remoting, and modify your connect string to connect to it:
For my remote access I use:

"Data Source=p*****e.com;Initial Catalog=S*****g;Persist Security Info=True;User ID=XXXX;Password=XXXX"

For testing I use:

"Database=S*****g;Data Source=GRIFFPC\SQLEXPRESS;Initial Catalog=S*****g;Integrated Security=True"

To be honest, I wouldn't use a free service - you get what you pay for. If you want to use a DB in a production environment, then you need to host it somewhere where it will be available 24/7 and subject to backups - pay for web hosting, they normally provide DB support at the same time, and will allow you to move it to a WCF service or similar later if you need that.

Posted 9-Jun-12 20:02pm

OriginalGriff

Comments

JMAM 10-Jun-12 2:27am

I tried justhost.com the problem is that clients ip address should be registered to remote mysql whitelist before the app can access the db.

OriginalGriff 10-Jun-12 3:02am

That is a problem between you and JustHost - it's their firewall! :laugh:
https://my.justhost.com/cgi/help/308

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

emond alcala · Accepted Answer · 2013-05-09T02:36:00

Solution 2

Hi,

Another option is to use cloud Database , some DaaS(database-as-a-service) providers are Xeround, ClearDB, Amazon,etc.

Sample Vb.Net Connection string:

CSS

Public MySQLConnectionString As String = "Server=instance04868.db.xeround.com; " & _
                                 "Port=6632;" & _
                                "Database= testl_db;" & _
                                "UID=123456;" & _
                                "PASSWORD=111111;" & _
                                "Connect Timeout = 10000000;pooling=true"

Posted 9-May-13 2:36am

emond alcala

Comments

JMAM 9-May-13 14:38pm

Thanks for your time, Do you know the best and cheap Mysql cloud and VPS hosting companies? if yes share some of your experience with them so i have ref. :) thanks

yogesh vaidya 23-Feb-18 6:46am

i want to creat inventry pacge for my own shop ,which need to run more thsn 5 pc like store,godown ,cash counter and i creat a sql class for connect the data base but it suould not works when i run program from diffaent pc or varcual box

this is my code
Imports System.Data.SqlClient
Public Class Sql_control
Public DBCon As New SqlConnection("Server=DEV-ASUS\SQLEXPRESS;Database=Buss_db;trusted_connection=true;")
Private DBCmd As SqlCommand

' DB DATA
Public DBDA As SqlDataAdapter
Public DBDT As DataTable

' QUERY PARAMETERS
Public Params As New List(Of SqlParameter)

' QUERY STATISTICS
Public RecordCount As Integer
Public Exception As String

Public Sub New()
End Sub

' ALLOW CONNECTION STRING OVERRIDE
Public Sub New(ConnectionString As String)
DBCon = New SqlConnection(ConnectionString)
End Sub

' EXECUTE QUERY SUB
Public Sub ExecQuery(Query As String)
' RESET QUERY STATS
RecordCount = 0
Exception = ""

Try
DBCon.Open()
If DBCon.State = ConnectionState.Open Then MsgBox("open")
' CREATE DB COMMAND
DBCmd = New SqlCommand(Query, DBCon)

' LOAD PARAMS INTO DB COMMAND
Params.ForEach(Sub(p) DBCmd.Parameters.Add(p))

' CLEAR PARAM LIST
Params.Clear()

' EXECUTE COMMAND & FILL DATASET
DBDT = New DataTable
DBDA = New SqlDataAdapter(DBCmd)
RecordCount = DBDA.Fill(DBDT)
Catch ex As Exception
' CAPTURE ERROR
Exception = "ExecQuery Error: " & vbNewLine & ex.Message
Finally
' CLOSE CONNECTION
If DBCon.State = ConnectionState.Open Then DBCon.Close()
End Try
End Sub

' ADD PARAMS
Public Sub AddParam(Name As String, Value As Object)
Dim NewParam As New SqlParameter(Name, Value)
Params.Add(NewParam)
End Sub

' ERROR CHECKING
Public Function HasException(Optional Report As Boolean = False) As Boolean
If String.IsNullOrEmpty(Exception) Then Return False
If Report = True Then MsgBox(Exception, MsgBoxStyle.Critical, "Exception:")
Return True
End Function
End Class
pleasa help me