Loading

Connection Problem

Rini

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()

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Khan Abrar Ahmed12y ago
Accepted 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/
0
Rini12y ago
Thank u Khan Abar Ahmed
0