Start A Sql Database Connection In C Language.

HI

I have sql database. now i want to connect to this server and get the data. Please let me know how to initiate the server and get the data.

Earlier the program is using MS access database and code is like below.

CDaoDatabase* pDB = NULL;
pDB = new CDaoDatabase;
char query[256], *name;
try
{
// Force usage of latest DAO engine
AfxGetModuleState()->m_dwVersion = 0x0601;
AfxDaoInit();

char *dbPath = new char[strlen(envVar) + 40];
sprintf(dbPath, "%s\MilkDB.mdb",envVar );
pDB->Open(dbPath);
}

now i am using sql server as database size was increased a lot. So please let me know how to initiate sqlserver from C program.

Thanks in advance.

Thanks
venkat