Hi all,
I have a mysql database stored in an FTP site. Currently I am able to connect to this database bacause it is on my pc and I have a connection string hardcoded in my code in vb.net, that looks like this:
Dim DBname As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};" &
"SERVER=localhost;" & _
"DATABASE=DBname;" & _
"UID=me;" & _
"PASSWORD=*****;" & _
"OPTION=3;")
I have a form in which:
userid is written in textbox1
password is written in textbox2
How do I set up this connection to look at the database in the ftp site and use the username and password from the textboxes on the form??
Going mad!
Thankyou in advance
This must be very simple, surely?
I have a mysql database stored in an FTP site. Currently I am able to connect to this database bacause it is on my pc and I have a connection string hardcoded in my code in vb.net, that looks like this:
Dim DBname As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};" &
"SERVER=localhost;" & _
"DATABASE=DBname;" & _
"UID=me;" & _
"PASSWORD=*****;" & _
"OPTION=3;")
I have a form in which:
userid is written in textbox1
password is written in textbox2
How do I set up this connection to look at the database in the ftp site and use the username and password from the textboxes on the form??
Going mad!
Thankyou in advance
This must be very simple, surely?