Connecting database using C++ Programming

Asked By jaysonm009 0 points N/A Posted on - 09/22/2011

I have a problem about how will I connect my Program or Software to the Database using C++ Programming Language.

Do I have to make a code for connecting my database?
How can I also create a database and what database that could be compatible with C++ Programming?

• Status: Open
• Question Views: 1314
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: C++

Best Answer by Franks good

Go To Solution

Answered By Motin 0 points N/A #126114

Connecting database using C++ Programming

C++ programming language is a high level language that you must remember it cannot run from first to an end. Example: #include<stdio.h>char*suits[4]=("Brown,"Yellow","Red","Black")char values.You can use code in C++ programming language.You should write your database into code language of C++ program.Thus install your C++ program software.Could you learn the basic code of C++ program.If you don't know the exact code then how you can be able to make your database into code.C++ programming language is a difficult programming language.Class colours int sidx.vidx.colours.

About Motin

Questions
0

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/24/2011
• Question Category: C++

Best Answer

Best Answer

Answered By Franks good 15 points N/A #126115

Connecting database using C++ Programming

Just follow these steps.

• Include the Header Files
• Open a Connection to a Database
• Choose Driver.
• Query the Database
• Extract the Data out of the Executed Query
• Traverse Through the Results
• Close the Statement and the Connection

 

//Header files:

#include <sql.h>

#include<sqltypes.h>

#include<sqlext.h>

...

....

//Declaration:

SQLHandle hdlEnv, hdlConn, hdlStmt, hdlDbc

char* stmt = "SELECT * from NutHead"; //SQL statementß NutHead is the Table name 

//for example

char *dsnName = “COLLECTOR” ß name of your program or what ever….. 

char* userID = "eXceed";

char* passwd = "hole";

char* retVal[256];

unsigned int cbData;

SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &hdlEnv); 

SQLSetEnvAttr(hdlEnv,SQL_ATTR_ODBC_VERSION,(void*)SQL_OV_ODBC30);

SQLAllocHandle(SQL_HANDLE_DBC, hdlEnv, &hdlConn); 

SQLConnect(hdlConn, (SQLCHAR*)dsnName,SQL_NTS,(SQLCHAR*)userID,SQL_NTS, (SQLCHAR*)passwd, SQL_NTS);

SQLAllocHandle(SQL_HANDLE_STMT, hdlDbc, &hdlStmt);

SQLExecDirect(hdlStmt, (SQLCHAR*)stmt, SQL_NTS); 

//Initialize the database connection

while(SQLFetch(hdlStmt) == SQL_SUCCEEDED)

{

  SQLGetData(hdlStmt,0,DT_STRING,retVal,256,&cbData);

  std::cout << retVal << std::endl;

}

SQLFreeHandle(SQL_HANDLE_STMT, hdlStmt);

SQLFreeHandle(SQL_HANDLE_DBC, hdlConn); 

SQLFreeHandle(SQL_HANDLE_ENV, hdlEnv);  //End the connection

 

About Franks good

Questions
4

Answers
60

Best Answers
34

• Vote Up 0 Vote Down

• Posted on - 12/09/2012
• Question Category: C++