Connecting to MS SQL Server

[heckflosse230]

Hi,

I'm to write a C++ app that is to retrieve data from a MS SQL Server database.

So far the only option I've found is ODBC FreeTDS.

Working with ODBC is ridiculous.

Are there any better options?

Thanks,
Chris Plasun

[Rubberman]

MS SQL is derived from Sybase, and they both use Transact-SQL. "Unadorned" T-SQL should work on either system. Also, I'm not sure, but the Sybase Linux libraries/API might connect with and work with MS SQL Server connections. As I said, I cannot say for sure because while I have done a considerable amount of work with Sybase's T-SQL and API's in the past, I haven't tried them with MS SQL Server, so at best this is just a SWAG, and something possibly worth trying.

The only other option is something like ODBC, which as you rightly point out, is a total pain.

[heckflosse230]

Good point about Sybase. I was talking about MSSQL's history to a co-worker yesterday and was wondering about connectivity possibilities with their respective drivers.

It might turn out that it wasn't a waste of time programming with ODBC years ago when even then it was obsolete =)

Thanks Rubberman.

Chris Plasun