Solved

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

Posted on 2007-12-04
6
866 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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

726 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