ODBC & Oracle

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.

Quote:

---

Originally Posted by VictorN

Have a look at MFC CDatabase and CRecordset classes.

---

Thank you.
Do you have some best of your examples using CDatabase ang CRecordset?
Could you give the master secrets?

Quote:

---

Originally Posted by ArnoldRich

Thank you.
Do you have some best of your examples using CDatabase ang CRecordset?
Could you give the master secrets?

---

Why don't you read the documentation first and then come back with questions. MSDN is full of examples.

Quote:

---

Originally Posted by GCDEF

Why don't you read the documentation first and then come back with questions. MSDN is full of examples.

---

Thank you.
Because there are a lot of fake code with bad examples in the documentation, which are not suitable.

Quote:

---

Originally Posted by ArnoldRich

Thank you.
Because there are a lot of fake code with bad examples in the documentation, which are not suitable.

---

MSDN is "full of fake code with bad examples"? That's one of the goofier things I've read on this site.

Quote:

---

Originally Posted by GCDEF

MSDN is "full of fake code with bad examples"? That's one of the goofier things I've read on this site.

---

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?

Quote:

---

Originally Posted by ArnoldRich

I did not wrote "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?

Quote:

---

Originally Posted by ArnoldRich

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

Quote:

---

Originally Posted by GCDEF

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

---

Thank you. I'll try.
But I must use the same ODBC code for applications in Windows and Linux. As far as I know MFC are not usable for Linux, though ODBC can be used.

Quote:

---

Originally Posted by ArnoldRich

Thank you. I'll try.
But I must use the same ODBC code for applications in Windows and Linux. As much as I know MFC are not usable for Linux, though ODBC can be used.

---

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.