connect to mySQL with VB.Net

[amNewatVB]

hi all
i'm trying to connect a mySQL server (not on my local machine) from VB.Net using OLEDB Connection.
the connection string used is :

Provider=MySQLProv;Data Source=mySQLDB;User Id=myusername;password=mypassword;"

the error my prog shows is "MySQLProv not supported by local machine."
do i have to download it explicitly ??? i dont have to use ODBC at all. plz help

[amNewatVB]

ok...i've downloaded the OLEDB3.0 and have installed it too.
now when i run, it asks for the data Source name....is this the DSN or the server name ?? i've provided the default..it shows the error : No error information available:E_FAIL(0x80004005)

plz help me n lemme know what am i doing wrong

[salvelinus]

Here's a quick link, hope it helps.

[Pirate]

http://www.connectionstrings.com

[amNewatVB]

hi...well i know the connection string and everything.
the problem i'm facing is that when i give the details..a dialog box appears when the application starts which requires the database name details. as my database is not on the local machine, i have given the location in the connection string but i on connecting i get the error : No error information available.

Do i have to make a DSN...i dont want to...can u guys help me here
the conn string i use is :

Provider=MySQLProv;Location=IP Address;Data Source:mydatabase;Username=uid;Password=pwd

[amNewatVB]

please ppl i need ur help here.....what am i doing wrong ???
my setup is as follows:

i've downloaded and installed myOLEDB3 and have registered myProv.dll

the connection string i'm using is:

Dim SQLConn As New OleDbConnection()
strSQLConn = "Provider=MySQLProv;Location=IPAddress where the mySQL database is;Data Source=database_name;User Id=uid;Password=pwd"
SQLConn.ConnectionString = strSQLConn
SQLConn.Open()

the connection doesn't open...when i run the prog, i get a kind of dialog box which is for the data source name details, it has a column ofr datasource name which has default written in it, the other columnsa are filled with the details i gave. when i click on connect on that dialog box, the error i get is:

No error information available:E_FAIL(0x80004005)

c'mon ppl help me out here

[amNewatVB]

ok..i had to make a DSN to get it work....the connection is working and i'm able to do what i wanna.

now my second question is..is there a way i can make the DSN on the fly..i mean the user wont have to explicitly make it...the vb.net code makes it for him. he just have to provide the server name, the usre id, password, dsn name and the database(thru an interface)
waiting for ur replies...but remember in vb.net

[stingrae]

i'm trying to do it now, but can't get past point 1.

question: "where do i download/install the MySQLProv Providor from?"

reason is, that i'm getting this error:

An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll

Additional information: The 'MySQLProv' provider is not registered on the local machine.

[stingrae]

Ok, I just got the providor. Now how do I create a DSN?