How to connect SQL To VC++

Question

0.00/5 (No votes)

See more:

hi,

How do i write a code that connects to SQL and takes the data and display it.

I want to do this in usng C/C++.

I have done lots of googling on it, didnt got any thing.

Any one have any solution. Pls let me know.

Thanks
:)

Posted 18-Apr-12 23:09pm

amit28august

Add a Solution

Comments

AshwinK4 17-Sep-13 5:05am

How can this be done in MFC dialog based app?

2 solutions

Solution 1

Please refer following thread:
Accessing SQL Server from C++[^]
http://www.sqlapi.com/[^]
http://www.codeguru.com/[^]
C++ SQL Interface[^]

Posted 18-Apr-12 23:11pm

Prasad_Kulkarni

Updated 18-Apr-12 23:13pm

v2

Comments

amit28august 19-Apr-12 5:17am

hi, thanks for reply, here i am not able to locate these file :sqlfront.h or sqldb.h, where do i get these files.
Also dont want to go for third party tools.

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)

Resmi Anna · Accepted Answer · 2012-04-18T23:27:00

The following program takes all data from a table called TestTable in the database TestDB and displays to the user
Here you need to replace the Data Source(Your server name), Initial Catalog(your DB name) and table name

C++

#include "stdafx.h"
#include <stdio.h>
#include <ole2.h>
#include <iostream>

#import "C:/Program Files/Common Files/System/ado/msado15.dll"  rename( "EOF", "AdoNSEOF" )

using namespace std; 
using namespace ADODB;

_bstr_t bstrConnect("Provider='SQLOLEDB'; Data Source='PC001\\SQLEXPRESS'; Initial Catalog='TestDB'; Integrated Security='SSPI';");
int main() 
{

	HRESULT hResult = CoInitialize( 0 );
    if( FAILED( hResult ))
    {
        return hResult;
    }
    try
    {
        ADODB::_ConnectionPtr pConnect("ADODB.Connection");
        hResult = pConnect->Open( bstrConnect, "admin", "", ADODB::adConnectUnspecified );
        if (SUCCEEDED(hResult))
        {
            _bstr_t query = "SELECT * FROM TestTable;";
            ADODB::_RecordsetPtr pRecSet( "ADODB.Recordset" );
            hResult = pRecSet->Open( query, _variant_t((IDispatch *) pConnect, true), ADODB::adOpenUnspecified,
                                     ADODB::adLockUnspecified, ADODB::adCmdText);
            if( SUCCEEDED( hResult ))
            {
                ADODB::Fields* pFields = NULL;
                hResult = pRecSet->get_Fields( &pFields );
                
                while( !pRecSet->AdoNSEOF )
                {
                    for( long lIndex=0; lIndex < pFields->GetCount(); lIndex++ )
                    {
                        cout<<" | ";
						cout << _bstr_t(pFields->GetItem(lIndex)->GetValue());
                    }
					cout<< "\n----------------------------------------------------------------------------\n";
                    pRecSet->MoveNext();
                }
            }
            pRecSet->Close();
            pConnect->Close();
        }
    }
    catch( _com_error& e )
    {
        // Handle Exception
    }

    // Release COM
    CoUninitialize();
	getchar();
    return hResult;
}