SQL and Windows Database Programming

[valikac]

Hi, I am interested in the SQL programming in the windows platform using raw win32 API, MFC, and COM technology. I have some basic questions. - What are the key differences between ODBC, DAO, ADO, and OLE with regards to SQL programming under windows platform? - Is any of that technology obsolete? What is the most widely used technology (above)? - I know there are MFC wrapper classes for ODBC and DAO. Is ADO primarily used by VB and C# programmers? I am a C++ programmer and have no problem working with raw win32 API, MFC, and COM (including ActiveX). What is the most powerful (speed/efficiency, extensibility, features, etc) technology for SQL programming in the windows platform? Thanks, Kuphryn

[Michael P Butler]

In my experience ODBC and ADO are the most widely used technologies to talk to SQL Servers. kuphryn wrote: I know there are MFC wrapper classes for ODBC and DAO. Is ADO primarily used by VB and C# programmers? There are plenty of wrapper classes here on CP for ADO. Or you could use the #import pre-processor and let it create a wrapper of the ADO Com object. Michael But you know when the truth is told, That you can get what you want or you can just get old, Your're going to kick off before you even get halfway through. When will you realise... Vienna waits for you? - "The Stranger," Billy Joel

[l a u r e n]

for speed use raw odbc and pass direct queries thru

---

"there is no spoon"
biz stuff   about me