C++ access to SQLServer without ODBC

Feb 21, 2013 at 7:35pm
Hi,

I need to connect and manipulate a DB in SQL Server 2008, but need to have high performance too, so, I want to develop an class in C++ that connect direct to DBMS, in a low level, without using ADO, ODBC or OLEDB.

I found this API http://www.sqlapi.com who proposes to do exactly what I want, but I need to develop it by myself.

Anyone has any idea about where I need to start looking?

Thanks!
Feb 22, 2013 at 2:38pm
Search the MSDN Library.

This should be a good start: http://msdn.microsoft.com/en-us/library/dd206988.aspx

Feb 26, 2013 at 3:15pm
Thanks plexus!

I found in this link: http://msdn.microsoft.com/en-us/library/aa174488(v=sql.80).aspx

It's talking about Native APIs:

"Native APIs are low-level APIs implemented with providers or drivers that communicate directly to SQL Server using the Tabular Data Stream (TDS) protocol. They are relatively complex APIs, but offer the best performance because they have the least overhead."

Someone have Knoweldge about the Tabular Data Stream (TDS) protocol ?

Thanks!
Feb 28, 2013 at 10:52am
You don't really have to know about TDS, because it's the protocol the library (DLL) uses to talk to the SQL server.

What you need to know is how you talk to the library via the API.

The table of APIs is pretty interesting, though. It seems that ODBC is already one of the native APIs.
You shouldn't have any problems finding documentation about ODBC.
Feb 28, 2013 at 11:43am
Thanks plexus!

I already worked with the Native SQL Server ODBC, and his documentation in msdn is very helpful.

But I am really interested in the best performance possible, to have the least overhead.

I am studying the the Tabular Data Stream (TDS), let's see how it work.

If anyone know how to work with it, let me know!

Thanks!
Topic archived. No new replies allowed.