C++ and MySQL connection

[tech291083]

Hi,

I was wondering if it is possible to connect a C++ program to a MySQL database on Linux Fedroa Core 5 os. It would be great if I could create a program in C++ that allows me to create a completely new database in MySQL, edit, modify, delete and update records and tables within it. But can't find much help on the net. Can any one please lend me some of the necessary knowledge. Thanks.

[~s.o.s~]

Something like this ?

[tech291083]

Something like this ?

Hi,

Thanks a lot for the reply, it seems that there is a need to download the C++ API for MySQL in order to make a connection between the two, but what actaully I am after is a simple piece of code that demonstrates the connection between C++ and MySQL. I would also like to have the basic guidelines on how to install the C++ API from the url you have kindly given to me. I would also go on trying to do it on my own, but there is a strong possibility of a failure underlying the fact that I am quite new to Linux and C++ both. More help would be sincerely appreciated. Cheers.

[sree_asrl]

Hi,

I was wondering if it is possible to connect a C++ program to a MySQL database on Linux Fedroa Core 5 os. It would be great if I could create a program in C++ that allows me to create a completely new database in MySQL, edit, modify, delete and update records and tables within it. But can't find much help on the net. Can any one please lend me some of the necessary knowledge. Thanks.

hi,
I have done a similar application in windows platform.
there i have used an ODBC Driver to connect,even u can connect Mysql server directly.
u create databases,execute queries also.
bye,
sree

[tech291083]

hi,
I have done a similar application in windows platform.
there i have used an ODBC Driver to connect,even u can connect Mysql server directly.
u create databases,execute queries also.
bye,
sree

Thanks for the help, but I am using Fedora core 5 32+ bit as my os and I would like to ask again weather I need to download the C++ API to make it all work from the following url:

http://tangentsoft.net/mysql++/

But if I do not install the above API and try to connect to a MySQL database with a C++ program is it going to work? I am a bit confused and lost here, need some more guidance. Thanks,

[~s.o.s~]

I guess you will have to put in a bit more effort and try it on your own. Download the documentation related to the API and do some experimentation....

[tech291083]

I guess you will have to put in a bit more effort and try it on your own. Download the documentation related to the API and do some experimentation....

Hi,

Thanks, I have downloaded the source rpm to my desktop.

Here they are on the page (http://tangentsoft.net/mysql++/) under a big heading called "Latest Stable Version" and they are the second link saying

"mysql++-2.2.0-1.src.rpm (2.6 MB, 2007.01.23) — Source RPM, for those that need to build their own binary RPMs. To do this, run this command as root:

# rpmbuild --rebuild /wherever/it/is/mysql++-2.2.0-1.src.rpm"

and then tried to build it with the following command in a terminal:

# rpmbuild --rebuild /wherever/it/is/mysql++-2.2.0-1.src.rpm

but some error messages showed up. Here they are:

warning: user tangent does not exist - using root
warning: group tangent does not exist - using root
error: Legacy syntax is unsupported: copyright
error: line 5: Unknown tag: Copyright: LGPL

This is what the terminal windows looks like:

[root@localhost Desktop]# rpmbuild --rebuild mysql++-2.2.0-1.src.rpm
Installing mysql++-2.2.0-1.src.rpm
warning: user tangent does not exist - using root
warning: group tangent does not exist - using root
error: Legacy syntax is unsupported: copyright
error: line 5: Unknown tag: Copyright: LGPL
[root@localhost Desktop]#

Can you help me with these errors please. Can't figure out any thing here at all.

[~s.o.s~]

Why do you want to build from source code when pre built binaries are readily available on the site?

I haven't personally used this API but you can try downloading the binary files under "Linux Binary RPM's" and trying them out. (they even have some examples).

If that doesn't work, you can try out this API.

[tech291083]

Why do you want to build from source code when pre built binaries are readily available on the site?

I haven't personally used this API but you can try downloading the binary files under "Linux Binary RPM's" and trying them out. (they even have some examples).

If that doesn't work, you can try out this API.

I think you are right I have made a mistake here. I will try the 4 binaries under "Linux Binary RPM's" and let you know as what it happening. Thanks your help is crucial.

[mikejonesey]

libmyodbc

(a simple odbc for linux and mysql)

would be great if we had a wine odbc, I'd love to get some of my odbc reliant dbase apps runnning via wine.