Solved

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

Posted on 2007-12-04
6
854 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
  • 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
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.

943 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now