I want to see example of using ODBC & Oracle.
Could someone give one?
Which is the best book for ODBC & Oracle?
Printable View
I want to see example of using ODBC & Oracle.
Could someone give one?
Which is the best book for ODBC & Oracle?
Have a look at MFC CDatabase and CRecordset classes.
I did not write "MSDN".
There are many examples in MSDN which are for the professors's level.
Sometimes examples are absent even in MSDN.
Unfortunately, in the Internet you can find fake code with bad examples.
Could you give me seasoned and tested code with pure ODBC?
No. Look at MSDN. Try their explanations and examples. If something from MSDN doesn't make sense or doesn't work, post your attempt at it and I, or somebody else, will tell you what you did wrong. Their examples and explanations are as good as or better than anything I could come up with.
You need to learn to use the documentation. You can't just decide it's all useless and post here every time you have a question without putting some effort into it yourself first.
Thank you GCDEF.
I'll use your recommendations for sure.
Don't you have tested pure ODBC examples?
Of course I do, but once you understand it, you'll realize why they won't do you much good. You'll have to learn how to derive a class from CRecordset that's specific to your database and your tables. It's really not very difficult. I'm not sure why you're so reluctant to give it a try.
This is probably a good place to start.
http://msdn.microsoft.com/en-us/library/w2c4cthk.aspx
Then go here and read the documentation (there is even a sample program):
http://msdn.microsoft.com/en-us/libr...=vs.85%29.aspx
ODBC is a specification, therefore it is not dependent on the OS. The same ODBC function calls will work for both Windows and Linux, as long as the database driver is ODBC compliant. All you need to do is specify the right driver and connect string in the SQL calls.
Regards,
Paul McKenzie
Mister Paul McKenzie.
Thank you very much indeed.