CODEWITHSUNDEEP
sql-serverc
Sam Liao
Sam Liao

Reputation: 46043

How to access ms sql server 2008 in c?

I know little about sql server access, and all googled out for sql server accessing are using C# or php like language.

Is there a good step by step about how to set up sdk and write an start program in c to access sql server database?

Upvotes: 0

Views: 117

Answers (1)

Pablo Santa Cruz
Pablo Santa Cruz

Reputation: 181280

You have a couple of options:

  1. ODBC
  2. SQLServer's DB-Library

If your application has a fairly simple DB interface (mostly common insert, update, delete, select commands), I would go for ODBC because of portability issues.

Do keep in mind that in order to use DB-Library you might need to get DLL's from older versions of SQLServer, since it's been deprecated in 2008.

Upvotes: 1

Related Questions