VB.Net to MySql DataBase Connection

8 views
Skip to first unread message

chaitanya kumar

unread,
Nov 25, 2009, 1:15:47 AM11/25/09
to DotNetDe...@googlegroups.com
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

unread,
Nov 25, 2009, 2:03:49 AM11/25/09
to dotnetde...@googlegroups.com
try oledb connection

chaitanya kumar

unread,
Nov 26, 2009, 10:41:14 PM11/26/09
to DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting
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

unread,
Nov 27, 2009, 3:32:27 AM11/27/09
to DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting

Charles A. Lopez

unread,
Nov 27, 2009, 11:37:16 AM11/27/09
to dotnetde...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages