VB.Net to MySql DataBase Connection

[chaitanya kumar]

Hi,

I am creating a windows Application with the Back-End Database as MySql, Which is in my domain.
can any one say me the coding to link to the database using VB.Net to MySql.

Actually i am having the coding but it is not working, i am getting an error while running it as

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified in vb.net 2008


To rectify this error what i have to do.

I also downloaded the MySQL Connector Net 5.1.7 & MySQL Server 5.0, even though i was not able to rectify that error.
 and also say me the procedure for installing these two.


N.Chaitanya Kumar.

http://vinayaka2005-08.webs.com

http://kumarnc2003.webs.com

[vinay kumar]

try oledb connection

[chaitanya kumar]

as u said i tried the oledb connection string also,
at that time i am getting another error

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

On Nov 25, 12:03 pm, vinay kumar <namavinayku...@gmail.com> wrote:
> try oledb connection
>

[Benj Nunez]

Check this out: http://forums.mysql.com/read.php?37,42065,237471#msg-237471


Cheers!



Benj

[Charles A. Lopez]

you'll need to install the mysql driver on the machine you're trying to connect from. Once you do that you can test your connection outside the application. If that doesn't work, you'll never be able to connect from your app. 

2009/11/25 chaitanya kumar <kumar...@gmail.com>

--
Charles A. Lopez
charle...@gmail.com

Registered Microsoft Partner

New York City, NY

I'm running on Windows 7 Build 7100

Quality Software Works