My idea would be to run something like apache/php
in front of it (that's how my hosting servers are all set up). Then you
can go ahead and make certain queries and add/delete functions in php against
the database, calling them from your app just by connecting to port 80 and doing
a simple HTTP GET or POST command. HTTP headers are simple to put together
(just 2 lines are needed) and you can have your php spit back something like
THE_RESULT_STARTS_HERE, and just search for that on what apache sends back and
parse out your result. The reason I'd do it this way is because I'm
already familiar with accessing mysql from php on apache and it would be
quickest for me. The php abstracts you from mysql-specific return codes,
error descriptions, etc. And you can format the results easily in php and
send them back to your app any way you want to.
Alternately you can learn mysql commands and use
tcp to connect to the mysql port and send commands directly and parse the
results that come back. And I'd bet there's an api around here somewhere
that will automatically call into mysql for you that would be wrote in
C/C++. If it were me and I wasn't going to go the HTTP route I'd look for
an api to use.
|
_______________________________________________ msvc mailing list [email protected] See http://beginthread.com/mailman/listinfo/msvc_beginthread.com for subscription changes, and list archive.
