Re: .Net Install/Not working

[Stig Benning]

Hi Dain Muller. Here is what worked for me, having the same error:

Located the Program Files\MySql\MySql Connector 1.0.4\bin\.Net 1.1 and moved the MySql.Data.dll to Windows\Microsoft.Net\Framework\v1.1.4322 - folder. After that I added a new reference to my project and located MySql.Data and then agian used Imports MySql.Data

Then you can define a connection like (vb):

dim constr As String
connstr = String.Format("server=localhost;userid=userid;password=password;database=dbname;pooling=false")

dim conn as MySql.Data.MySqlClient.MysqlConnection
conn = new MySql.Data.MySqlClient.MySqlConnection(connstr)

conn.Open()
dim reader as MySql.Data.MySqlClient.MySqlDataReader
reader = Nothing

dim cmd as new MySql.Data.MySqlClient.MySqlCommand("select * from tablename", conn)

reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

While(reader.Read())
ComboBox1.Items.Add(reader.GetString(0))
End While

conn.Close()

Hope this works for you,
Stig