Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 start a sql database connection in C language.

Author  Topic 

maddineni_vr
Starting Member

3 Posts

Posted - 2008-03-15 : 22:02:34
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

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-16 : 04:26:59
www.connectionstrings.com



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -