Solved

Connecting vb.net 2003 (.net framework 1.1) with mysql

Posted on 2007-12-04
6
871 Views
Last Modified: 2013-11-26
All,

I would like to design a GUI to connect to a MySQL database on my local machine.  I tried to use VB.net 2003 to do this but for the MySQL version 5.0.8 I needed the MySQL Connect/Net and it required .net Framework 2.0.  I installed .net Framework 2.0 and it doesn't work with Visual Studio .net 2003.

How can I connect a database using MySQL with Visual Studio .net 2003?  What programs do I need to download?  Is there a version of MySQL that I can download that will let my use the .net framework 1.1 instead of 2.0 for ODBC and ADO connection strings?

I started this project using Oracle but the overhead required by using Oracle was more than I wanted to spend in resources to design this database/GUI.

Thanks,

Rick
0
Comment
Question by:rchrdrea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 9

Expert Comment

by:sognoct
ID: 20403874
you can use framework 2.0 with the free Visual Studio 2005 Express Edition
0
 
LVL 96

Expert Comment

by:Bob Learned
ID: 20403892
For web site development, you would need to download Visual Web Developer, because the VB.NET 2005 Express won't let you create web sites.

Bob
0
 
LVL 9

Accepted Solution

by:
sognoct earned 250 total points
ID: 20403909
For using Visual Studio .net 2003 you should remove framework 2.0, install framework 1.1 and then you can connect to the mysql database using OleDB or ODBC (which are included into the framework)
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:sognoct
ID: 20403950
Visual Web Developer express  does ... but I have never used it
0
 

Author Comment

by:rchrdrea
ID: 20404953
Sognoct and TheLearnedOne,

I don't want to download another programming software package.  I had considered getting VS 2005, but declined because I am cheap.

I have 2003 I think that this should be enough for basic .NET programming.

At the moment I don't have a desire to put database work that I have done for personal use on the internet.  No web development.

sognoct I think you answered my question with oledb and ODBC.  I will see if I can make this work and get back to you.

thanks,

R
0
 

Author Comment

by:rchrdrea
ID: 20414003
Sognoct,

You almost answered what I needed.

Since i didn't know the name of the reference that I could use for the ODBC and OLEDB connections between vb.net 2003 and mysql I did some more internet searching, and downloaded MySQL Connector/Net 1.0.

After I had installed it the MySQL.Data.dll file showed up in my references in vb.net 2003 and I was able to use it to connect to my database.

Thanks,

R
0

Featured Post

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question