tags:

views:

24

answers:

1
Q: 

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?

+1  A: 

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.

Pablo Santa Cruz  2010-10-25 17:09:38

related questions

any good tool for makefile generation?
How do you pass a function as a parameter in C?
Where should a veteran C programmer start in order to master Java ?
Any good book on best practice and guidelines in developing a SDK in C?
How do you determine the size of a file in C?
Decoding printf statements in C (Printf Primer)
Shift operator in C
How to avoid redefining VERSION, PACKAGE, etc.
Alpha blending sprites in Nintendo DS Homebrew
When should I use type abstraction in embedded systems
How to implement continuations?
What are the barriers to understanding pointers and what can be done to overcome them?
Anyone have experience creating a shared library in MATLAB?
String.indexOf function in C
Passing multidimensional arrays as function arguments in C
C/C++ library for reading MIDI signals from a USB MIDI device
Choosing a static code analysis tool
How do you printf an unsigned long long int?
Good STL-like library for C.
Rockbox audio format
Why am I getting a malloc: double free error with realloc()?
Should I learn C?
GTK implementation of MessageBox
Is gettimeofday() guaranteed to be of microsecond resolution?
How to use the C socket API in C++ on z/OS