How to use SQLAPI in VC++ console program?

Question

3.00/5 (2 votes)

See more:

I am trying to link my c++ console program with the SQL database and i have downloaded the SQL API from sqlapi.com but after putting .lib in additional dependencies,DLL in system 32 and SQLAPI.h in header it still dont work and when i try to include the sqlheader in my program it shows error and also it shows another error of sqlapi.dll? can anybody explain me the process to use SQL API in visualC++.

/thanks in advance

Posted 30-Jul-12 22:20pm

meshinator

Add a Solution

Comments

Malli_S 31-Jul-12 4:44am

Include the SQlAPI.h file path in you project settings 'Additional Include Folder Path'. And for dll problem, you may have to copy the dll at the path where the your project exe is generated.

Richard MacCutchan 31-Jul-12 5:38am

it still dont work and when i try to include the sqlheader in my program it shows error and also it shows another error of sqlapi.dll?
Unless you you provide the exact error messages and the lines of code that cause them you will not get much help. Try to help yourself by providing proper details with your question.

meshinator 31-Jul-12 7:41am

Thanks Malli,this was first time i was using SQL API and i forgot to gib the path.

Malli_S 31-Jul-12 10:24am

You're welcome!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2012-07-31T07:35:00

Solution 1

Based on OP's comment Thanks Malli,this was first time i was using SQL API and i forgot to gib the path., it looks like issue is resolved.

Posting just to pop it out of unanswered list.

Posted 31-Jul-12 7:35am

Sandeep Mewara

Ido Hadar · Accepted Answer · 2012-08-01T09:11:00

You can also try the ODBC ..

take a example:

#include <windows.h>
#include <sqlext.h>
#include <stdio.h>

int main(void)

{
HENV hEnv = NULL; // Env Handle from SQLAllocEnv()
HDBC  hDBC = NULL; // Connection handle
HSTMT hStmt = NULL; // Statement handle
UCHAR szDSN[SQL_MAX_DSN_LENGTH] ="db97";   // Data Source Name buffer
UCHAR* szUID = NULL; // User ID buffer
UCHAR* szPasswd = NULL;// Password buffer
UCHAR  szModel[128]; // Model buffer
SDWORD  cbModel; // Model buffer bytes recieved
UCHAR   szSqlStr[] = "Select Model FromMakes Where Make='Vauxhall'";                // SQL string
 RETCODE              retcode; // Return code

// Allocate memory for ODBC Environment handle
SQLAllocEnv (&hEnv);

// Allocate memory for the connection handle
 SQLAllocConnect (hEnv, &hDBC);

// Connect to the data source "db97" using userid andpassword.
retcode = SQLConnect (hDBC, szDSN, SQL_NTS, szUID,SQL_NTS, szPasswd, SQL_NTS);

 if (retcode == SQL_SUCCESS || retcode ==SQL_SUCCESS_WITH_INFO)
 {
    // Allocate memory for the statementhandle
    retcode = SQLAllocStmt (hDBC, &hStmt);

    // Prepare the SQL statement by assigningit to the statement handle
    retcode = SQLPrepare (hStmt, szSqlStr,sizeof (szSqlStr));

    // Execute the SQL statement handle
    retcode = SQLExecute (hStmt);

    // Project only column 1 which is themodels
    SQLBindCol (hStmt, 1, SQL_C_CHAR, szModel,sizeof(szModel), &cbModel);

    // Get row of data from the result setdefined above in the statement
    retcode = SQLFetch (hStmt);

    while (retcode == SQL_SUCCESS || retcode== SQL_SUCCESS_WITH_INFO)
    {
         printf ("%s",szModel);                      // Print row(model)
        retcode = SQLFetch(hStmt);              // Fetch next row from result set
    }

    // Free the allocated statement handle
    SQLFreeStmt (hStmt, SQL_DROP);

    // Disconnect from datasource
    SQLDisconnect (hDBC);

}


// Free the allocated connection handle
SQLFreeConnect (hDBC);

// Free the allocated ODBC environment handle
SQLFreeEnv (hEnv);

return 0;

}