Data Source for VB.NET program

proximad

New Member
Messages
2
Reaction score
0
Points
0
"
Hi everybody,
i'm new, and i'm trying to connect to my mysql database using a VB.NET program, i need for that to know the Data Source" of my database, i can't type "localhost" because I'm trying to connect to the x10hosting database that i create from my computer, i tried to put 74.86.116.190 as suggested in this thread : http://forums.x10hosting.com/free-hosting/53469-cannot-connect-vb2005-app-mysql-databse.html but it didnt' work and finally i puted 67.228.162.200 as i saw in my Cpanel but it didn't work too.

may somebody help me please.
thank you
 
Last edited:

proximad

New Member
Messages
2
Reaction score
0
Points
0
ok thank you for the advices,
here is the code i use to connect the program with my local data base i installed using easyphp, and it works, this time i need to connect my program with my online database who is installed in x10hosting, i tried to put the ip adress of the server but it didn't work, maybe it's because of the php restrictions, i changed the setings, and i'm waiting them to take effects, (it may take 12 hours) i hope that's the solution
Code:
Public Const ConnnectionStr = "Database=proximad;Data Source=localhost;User Id=root;Password=;"
Public Function SeConnecter(ByRef Conn As MySql.Data.MySqlClient.MySqlConnection) As Boolean
        On Error GoTo dberr
        ' Se connecter à la base MySQL
        Conn.ConnectionString = ConnnectionStr
        Conn.Open()
        ReconLoop = 0
        explorerFrm.ReconTimer.Enabled = False
        Return True
        Exit Function
Edit:
HI,
i recieved an email that tell's me that my hosting account's version of PHP has been updated to version 2 successfully, unfortunally it still doesn't work, here is the code i used to connect to my database!
Code:
Public Const ConnnectionStr = "Database=proximad_proximad;Data Source=67.228.161.42;User Id=proximad_imad;Password=*******;"
here is the error i recieved:
Unable to connect to any of the specified MySQL hosts.
thank u fot your help
 
Last edited:
Top