Having issues getting mySQL++ 2.1 to work with VS.net 2005, any tutorials or advice?

Hello everyone, I'm having issues getting Visual Studio 2005.net to work with mySQL++ 2.1.1.

I download mySQL 5.0 which is located in C:\Program Files\MySQL\MySQL Server 5.0

Inside this directory i have bin, include, data, etc files

Am I suppose to use this database or the one provided by VS.net?

Microsoft SQL Server 2005 installed at:
C:\Program Files\Microsoft SQL Server\
Which has some files called: 90, 80 and MSSQl.1

What i'm trying to do is create a console application with C++ where the user can enter some information and it will be stored in a mySQL server and from the console you can access the data, delete it, sort it, etc

I'm doing this for a term project due at the end of the semester but i'm having troubles getting mySQL++ to work with VS 2005. I can't compile any of the examples becuase It can't find the mySQL++ libraries nor do I think it knows which database i'm using, the mySQL 5.0 or the MIcrosoft mySQL server. i'm not sure which would work better.

I downloaded the following file:
mysql++-2.1.1.tar

I have it on my system but i'm not sure how i'm suppose to tell Microsoft Visual Studio C++ to find the libraries that mySQL++ uses.


Does anyone know of any websites or tutorials that explain how to get it all set up so I can run the examples provided by mySQL++ 2.1.1?

I tried google but they are only showing some tutorials with Visual Studio 6 and an older version of mySQL++. The website that has tutorials for this assume you already figured out how to isntall it and get it working with your compiler: http://tangentsoft.net/mysql++/doc/u...html#id2860437



Thank you sorry about rambling!

I know nothing about MySQL but here is a link I found that may give enough to help out.

http://www.devarticles.com/c/a/Cplus...h-MySQL-and-C/

Awesome, thanks alot man! I think this will help me alot!

voidflux:

The questions and problems you are having are the reasons why I don’t use MySQL.

However, if you have to use it, these Web sites should answer most of your questions.

You can download the latest version of MySQL (which is 5.0) here:

http://dev.mysql.com/downloads/

Don’t forget to download MySQL Connector/Net 5.0 which you will need if you are using MySQL with .Net.

Instructions for installing and getting it to work are here:

http://dev.mysql.com/doc/administrator/en/index.html

Since you have said that you have Microsoft SQL Server 2005 I would use that instead of MySQL, but maybe your assignment requires the use of MySQL.

Hope this helps a little.

Good Luck

Thanks AIS4U, I'll try to find tutorials on using MS SQL Server 2005 and console.

I'm not required to use mySQL, the professor recommend I do use that, but I can use anything, infact this project could be anything, I just got the idea from CornedBee in the C++ section of this forum by making a data management program.

I orginally was going to use text files to store all the information but that would turn out into a ton of code and wouldn't be very useful....

What database do you recommend I use that will work well for storing/searching/deleting/displaying information via C++?

voidflux:

I think one of the main reasons a lot of people have used MySQL is because if is free. However, now that Mircrosoft is giving away SQL Express I think you will find that a majority of people who are working in the .Net area are using that.

For small, simple projects I personally prefer Access, but that is probably just because I have used it more than SQL Express.

Quote:

---

I just got the idea from CornedBee in the C++ section of this forum by making a data management program.

---

Since I don't know or use C++ I would have to defer to CornedBee. However, it really doesn't matter what language you are using for the frontend of your application, you could use most any database.

I am not certain about this statement, but I think if you use either MySQL or SQL Express, any computer you want to run your app on will have to have that particular database installed, but I may be wrong about that.

If you use Access, you can run your app on another computer that does not have Access installed. So, that might be a consideration.

Good Luck with your project.

Thanks AIS4u,

I'll search around for coding examples to see which one I'll use. If it was up to me I'd rather use C# it seems to be great with databases or java but this class is forcing us to use C++.


I think your right about the SQL and SQLexpress, I did a similar application that used vb6 and ODBC with mySQL when i was younger and it wouldn't run on another machine unlesss it had mySQL installed.

AIS4U,

Do I really need the net connector if i'm using C++ in visual studio 2005.net? Or is it only if i'm using VC++.net w/ ADO.net? Because the description says: MySQL Connector/Net is an ADO.NET driver for MySQL.

Thanks.

voidflux:

Quote:

---

Do I really need the net connector if i'm using C++ in visual studio 2005.net?

---

I think it is required for all .Net languages, but since I haven't used C++ I can't be certain.
Enjoy