MySQL help!!!

Bill Gates Antimatter Particle

Has anybody used MySQL via MFC? All I need to do first off is get a noddy database working programmaticly using MySQL in MFC. eg Name Table:- (Unique ID,Surname,Forename,DOB,UniqueKey) Address Table:- (Unique ID,LineOne,District,Town,County,PostCode) Contact Table:- (UniqueID,Number,Type) Can anybody do this in their coffee break? Im stuck where to start is the problem. Im sure its a doddle though. :confused: "Life begins at 140"

Jon Hulatt

Really what is the need to repost? I answered your first question. Perhaps you should follow my advice. Read MSDN a little too. People here are happy to help, but not to do your work for you. Sorry to dissapoint you all with my lack of a witty or poignant signature.

Bill Gates Antimatter Particle

The reason I reposted is that you did not answer my question. I was happy to receive a response: however I do not want to use MyODBC! That is the whole point. It is too slow. I want to use MySQL++ preferably or MySQL c api. Any further constructive responses are welcome. "Life begins at 140"

markkuk

You said you want to use MySQL via MFC, and the MFC database classes are based on ODBC (requiring the use of MyODBC). If you want to use MySQL++ or MySQL C API, you won't be using it via MFC.

Nish Nishant

Bill Gates Antimatter Particle wrote: Can anybody do this in their coffee break? Ouch!!!! Nish Sonork ID 100.9786 voidmain www.busterboy.org If you don't find me on CP, I'll be at Bob's HungOut

Bill Gates Antimatter Particle

What you said is correct except for one thing. Its not necessary to use CRecordset. If you avoid CRecordset then you dont require ODBC drivers. I have now managed to create a project using MySQL++ api directly. It is many times faster than interfacing to the MySQL api via ODBC eg opening a table via ODBC driver was s - l - o - w ~ 2 seconds a table as opposed to 0.05 seconds using the MySQL++ api directly. That was the question I was asking and which nobody attempted to answer.:mad: "Life begins at 140"