C++ access to SQLServer without ODBC

[ViNiCamps]

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!

[plexus]

Search the MSDN Library.

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

[ViNiCamps]

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!

[plexus]

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.

[ViNiCamps]

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!