MYSQL and vb.net in Visual Web developer

[Bodwad]

Hello

I am a new programmer to MYSQL and Visual Web Developer. I am trying to connect to the MYSQL server on my account but I cant for the life of me work out what the connection string should be. After looking through loads of different sources I have become very confused. My current string is

ADODBString = "DRIVER={ MySQL ODBC 3.51 Driver };SERVER=mysql2.g********.com;DATABASE=Bodwad_mydb ;" & _
"USER=MyUsername;PASSWORD=MyPassword;Port = 3306;Option=3;"

It just wont connect raising the error

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

I am doing it all in a aspx.vb file so I dont know if thats what the problem is. I am also using the odbcconnection object.

Anyone know what I am doing wrong?

Paul

[Stephen]

http://connectionstrings.com/ is a good resource

It says:
Server=myServerAddress;Database=myDataBase;Uid=myU sername;Pwd=myPassword;

or the MS version of OLEDB should also work with:
Provider=MySQLProv;Data Source=mydb;User Id=myUsername;Password=myPassword; and System.Data.OleDb.OleDbConnection

[Bodwad]

Thanks for your help.

I have tried both of these but I dont think I understand what I should be putting in the "provider=" bit.

My string at the mo is
"Provider=64.71.229.253;Data Source=Bodwad_Master;User Id=Bodwad_Bodwad;Password=password;"

The more I try to understand that website the more my brain huts

Thanks

[Stephen]

no provider is what it says, that tells the OS which driver to load, so it needs to be MySQLProv

[Bodwad]

hmmm but if I try that I get

The 'MySQLProv' provider is not registered on the local machine

which means its not installed. I have tried using the .net MySqlConnector aswell and this isnt installed either :o(

Do I need to do something in the web.config file?

Sorry if these are simple things, its all odd to me

[Stephen]

You can load one of the connectors in your /bin as well the MySQL.DATA.dll is the connector

[Bodwad]

ahhh I didnt realise we could create a bin file on the server and copy Dll's into it. Now I have copied the dll in it works great. Thankyou for your help, I have to say this web malarky is very frustrating, I think I will stick to VB and c++