Connection Problem

Question

When i connect my database in VB.net i got an error format of the initialization string does not conform to specification starting at index 0.

My code is:

Dim conobj1 As MySqlConnection

conobj1 = New MySqlConnection("server" + txtdatabase.Text & "';'" & "userid" + txtUser.Text & "';'" & "password" + txtPass.Text & "';'" & "database" + txtData.Text)
conobj1.Open()

Khan Abrar Ahmed · Answer

Hi try this Dim MysqlConn As MySqlConnection MysqlConn = New MySqlConnection() MysqlConn.ConnectionString = server= & txtServer.Text & ; _ & user id= & txtUsername.Text & ; _ & password= & txtPassword.Text & ; _ & database=test MysqlConn.Open() MessageBox.Show(Connection to Database has been opened.) MysqlConn.Close() or refer this link http://www.dreamincode.net/forums/topic/115753-use-vbnet-to-connect-to-mysql/

Rini · Answer

Thank u Khan Abar Ahmed