VC++ Database Connection

SIMPLE Question.. I am using C++, and I want to connect to a database.

Additional (Maybe important):
Please do not ask me questions. I don't care what compiler you tell me to use (VC++, Mac-Based, DevC++, etc), I don't care what database (MS Access, MySQL, SQL Server, etc), I don't care about any of that. If you have a working database connection with a single SQL recordset, I'll take it.

Repeat: I don't CARE What setup your example is in.. I just want to see a working database connection so I at least know it exists. I'll get the compiler you used, on the platform you used it on, with all the setup you have, and I'll use that for the rest of my life if I have to.

I have read the Codeguru FAQ, I have searched online through forums and tutorials for nearly 3 weeks and have attempted every bit of sourcecode imaginable to me, including the MSDN Visual C++ Tutorial on how to create a database connection, which failed miserably because my VC++ 2008 express doesn't seem to have any of the features in that tutorial.

A lil background: I know what I'm doing in anything having to do with web development, and I am also pretty dam good at Visual Basic.

I am attempting C++ because I want the power and memory controls. I am about to throw my computer out the window, though, if I can't create a database connection.

In the 10 other languages I know, I type something like this:

dataConn = Connect kthx;

But for C++ it seems like I have to type a custom 100 module executable just to create a database connection, then the same for each SQL statement I want. I am about to break down.

As far as I can see, the only responses to this question, "How do you connect to a database?" are with more questions, and there are no answers in the FAQ's of any website... so maybe it is as complicated and perhaps even impossible.

Well, there are many articles on CG.
http://www.codeguru.com/cpp/data/mfc_database/

And you didn' find that on MSDN ?!!!
There are dozens of complete samples in MSDN (ODBC, ADO, etc) to connect to a database !!

See reply #8 in this thread http://www.codeguru.com/forum/showthread.php?t=337819 for an example of using the ATL OLE DB Consumer classes inside an MFC app. The reply includes a sample app with the source and database.

Great! I believe it's generally working. Thanks for the link to that tutorial. It was incomplete, which confused me a lot, but the zip'd source file had the complete code.

So it's running, but the run is printing an error:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

I'm guessing that means it can't find my database? Because it surely isn't open. This is my connection string:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Suamere\\Documents\\Visual Studio 2008\\Projects\\Lordaeron\\Lordaeron.accdb;Persist Security Info=False

Is there a problem with it? I checked the directory using windows RUN, and it opened the DB, so the location IS correct. My database has a table named authors with two columns named au_id and au_fname.

I am assuming the problem might be that this script wasn't written to use MS Access?

Here is my full code:

test.cpp

Quote:

---

#include <stdio.h>
#include <iostream>
#include <comdef.h>
#include <conio.h>
#include "Database.h"



//"Provider=SQLOLEDB.1; Persist Security Info=False; User ID=lab;Initial Catalog=pubs;Data Source=PRASUN@CSE";
char CnnStr[200]="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Users\\Suamere\\Documents\\Visual Studio 2008\\Projects\\Lordaeron\\Lordaeron.accdb;Persist Security Info=False";
char ErrStr[200];

int main()
{
::CoInitialize(NULL);
Database db;
Table tbl;
if(!db.Open("lab","cse-98",CnnStr))
{
db.GetErrorErrStr(ErrStr);
std::cout<<ErrStr<<"\n";
}
if(!db.Execute("select * from authors order by au_fname,au_id",tbl))
{
db.GetErrorErrStr(ErrStr);
std::cout<<ErrStr<<"\n";
}
/*if(!db.OpenTbl(ADODB::adCmdText,"select * from authors order by au_fname,au_id",tbl))
{
db.GetErrorErrStr(ErrStr);
cout<<ErrStr<<"\n";
}*/
char id[100];
if(!tbl.ISEOF())
tbl.MoveFirst();

while(!tbl.ISEOF())
{
if(tbl.Get("au_id",id))
std::cout<<"\nid:"<<id;
else
{
tbl.GetErrorErrStr(ErrStr);
std::cout<<"\n"<<ErrStr<<"\n";
break;
}
if(tbl.Get("au_fname",id))
std::cout<<" fname:"<<id;
else
{
tbl.GetErrorErrStr(ErrStr);
std::cout<<"\n"<<ErrStr<<"\n";
break;
}

tbl.MoveNext();
}
::CoUninitialize();
return 0;
}

---

__________________________________
database.h

Quote:

---

#define CATCHERROR(ptr,a) catch(_com_error &e)\
{\
ErrorHandler(e,m_ErrStr);\
ptr=NULL;\
return a;\
}

#define CATCHERRGET catch(_com_error &e)\
{\
ErrorHandler(e,m_ErrStr);\
sprintf(m_ErrStr,"%s\n**For Field Name:%s",m_ErrStr,FieldName);\
return 0;\
}

#import "c:\Program Files\Common Files\System\ADO\msado15.dll" \
rename("EOF", "EndOfFile")

typedef ADODB::_RecordsetPtr RecPtr;
typedef ADODB::_ConnectionPtr CnnPtr;

class Database;
class Table;


class Database
{
public:
CnnPtr m_Cnn;
char m_ErrStr[500];
Database();
bool Open(char* UserName, char* Pwd,char* CnnStr);
bool OpenTbl(int Mode, char* CmdStr, Table& Tbl);
bool Execute(char* CmdStr);
bool Execute(char* CmdStr, Table& Tbl);
void GetErrorErrStr(char* ErrStr);
};

class Table{
public:
RecPtr m_Rec;
char m_ErrStr[500];
Table();
void GetErrorErrStr(char* ErrStr);
int ISEOF();
HRESULT MoveNext();
HRESULT MovePrevious();
HRESULT MoveFirst();
HRESULT MoveLast();
int AddNew();
int Update();
int Add(char* FieldName, char* FieldValue);
int Add(char* FieldName,int FieldValue);
int Add(char* FieldName,float FieldValue);
int Add(char* FieldName,double FieldValue);
int Add(char* FieldName,long FieldValue);
bool Get(char* FieldName, char* FieldValue);
bool Get(char* FieldName,int& FieldValue);
bool Get(char* FieldName,float& FieldValue);
bool Get(char* FieldName,double& FieldValue);
bool Get(char* FieldName,double& FieldValue,int Scale);
bool Get(char* FieldName,long& FieldValue);
};

---

__________________________________
database.cpp

Quote:

---

#include <stdio.h>
#include <iostream>
#include <comdef.h>
#include <conio.h>
#include "Database.h"

#define _CRT_SECURE_NO_WARNINGS

ADODB::_RecordsetPtr rec1=NULL;

_variant_t vtMissing1(DISP_E_PARAMNOTFOUND, VT_ERROR);

void ErrorHandler(_com_error &e, char* ErrStr)
{

sprintf(ErrStr,"Error:\n");
sprintf(ErrStr,"%sCode = %08lx\n",ErrStr ,e.Error());
sprintf(ErrStr,"%sCode meaning = %s\n", ErrStr, (char*) e.ErrorMessage());
sprintf(ErrStr,"%sSource = %s\n", ErrStr, (char*) e.Source());
sprintf(ErrStr,"%sDescription = %s",ErrStr, (char*) e.Description());
}

Database::Database()
{
m_Cnn=NULL;
sprintf(m_ErrStr,"NULL POINTER");
}

void Database::GetErrorErrStr(char* ErrStr)
{
sprintf(ErrStr,"%s",m_ErrStr);
}

void Table::GetErrorErrStr(char* ErrStr)
{
sprintf(ErrStr,"%s",m_ErrStr);
}

bool Database::Open(char* UserName, char* Pwd,char* CnnStr)
{
//cnn->Open(strCnn,"sa","sa",NULL);
try
{
HRESULT hr;
hr = m_Cnn.CreateInstance( __uuidof( ADODB::Connection ) );
m_Cnn->Open(CnnStr, UserName, Pwd, NULL);
}

CATCHERROR(m_Cnn,0)

sprintf(m_ErrStr,"Success");
return 1;
}

bool Database::OpenTbl(int Mode, char* CmdStr, Table &Tbl)
{
if(m_Cnn==NULL)
{
Tbl.m_Rec=NULL;
sprintf(m_ErrStr,"Invalid Connection");
return 0;
}
RecPtr t_Rec=NULL;
try
{
//t_Rec->putref_ActiveConnection(m_Cnn);
//vtMissing<<-->>_variant_t((IDispatch *) m_Cnn, true)
t_Rec.CreateInstance( __uuidof( ADODB::Recordset ) );
t_Rec->Open(CmdStr,_variant_t((IDispatch *) m_Cnn, true),ADODB::adOpenStatic,ADODB::adLockOptimistic,Mode);
}

CATCHERROR(Tbl.m_Rec,0)

Tbl.m_Rec=t_Rec;
sprintf(m_ErrStr,"Success");
return 1;
}

bool Database::Execute(char* CmdStr)
{
try
{
m_Cnn->Execute(CmdStr,NULL,1);
}
catch(_com_error &e)
{
ErrorHandler(e,m_ErrStr);
return 0;
}
sprintf(m_ErrStr,"Success");
return 1;
}

bool Database::Execute(char* CmdStr, Table& Tbl)
{
RecPtr t_Rec=NULL;
try
{
t_Rec=m_Cnn->Execute(CmdStr,NULL,1);
}

CATCHERROR(Tbl.m_Rec,0)

sprintf(m_ErrStr,"Success");
Tbl.m_Rec=t_Rec;
sprintf(m_ErrStr,"Success");
return 1;
}

Table::Table()
{
m_Rec=NULL;
}

int Table::ISEOF()
{
int rs;
if(m_Rec==NULL)
{
sprintf(m_ErrStr,"Invalid Record");
return -1;
}
try{
rs=m_Rec->EndOfFile;
}

CATCHERROR(m_Rec,-2)

sprintf(m_ErrStr,"Success");
return rs;
}

bool Table::Get(char* FieldName, char* FieldValue)
{
try
{
_variant_t vtValue;
vtValue = m_Rec->Fields->GetItem(FieldName)->GetValue();
sprintf(FieldValue,"%s",(LPCSTR)((_bstr_t)vtValue.bstrVal));
}

CATCHERRGET

sprintf(m_ErrStr,"Success");
return 1;
}

bool Table::Get(char* FieldName,int& FieldValue)
{
try
{
_variant_t vtValue;
vtValue = m_Rec->Fields->GetItem(FieldName)->GetValue();
FieldValue=vtValue.intVal;
}

CATCHERRGET

sprintf(m_ErrStr,"Success");
return 1;
}

bool Table::Get(char* FieldName,float& FieldValue)
{
try
{
_variant_t vtValue;
vtValue = m_Rec->Fields->GetItem(FieldName)->GetValue();
FieldValue=vtValue.fltVal;
}

CATCHERRGET

sprintf(m_ErrStr,"Success");
return 1;
}

bool Table::Get(char* FieldName,double& FieldValue)
{
try
{
_variant_t vtValue;
vtValue = m_Rec->Fields->GetItem(FieldName)->GetValue();
FieldValue=vtValue.dblVal;
//GetDec(vtValue,FieldValue,3);
}

CATCHERRGET

sprintf(m_ErrStr,"Success");
return 1;
}

HRESULT Table::MoveNext()
{
HRESULT hr;
try
{
hr=m_Rec->MoveNext();
}
catch(_com_error &e)
{
ErrorHandler(e,m_ErrStr);
//m_Rec=NULL;
return -2;
}
sprintf(m_ErrStr,"Success");
return hr;
}

HRESULT Table::MovePrevious()
{
HRESULT hr;
try
{
hr=m_Rec->MovePrevious();
}
catch(_com_error &e)
{
ErrorHandler(e,m_ErrStr);
//m_Rec=NULL;
return -2;
}
sprintf(m_ErrStr,"Success");
return hr;
}

HRESULT Table::MoveFirst()
{
HRESULT hr;
try
{
hr=m_Rec->MoveFirst();
}
catch(_com_error &e)
{
ErrorHandler(e,m_ErrStr);
//m_Rec=NULL;
return -2;
}
sprintf(m_ErrStr,"Success");
return hr;
}

HRESULT Table::MoveLast()
{
HRESULT hr;
try
{
hr=m_Rec->MoveLast();
}
catch(_com_error &e)
{
ErrorHandler(e,m_ErrStr);
//m_Rec=NULL;
return -2;
}
sprintf(m_ErrStr,"Success");
return hr;
}

---

That is way more code than you need. Way, way, way more.

If you can use MFC, look at the CRecordset class.

Quote:

---

Originally Posted by Suamere

Great! I believe it's generally working. Thanks for the link to that tutorial. It was incomplete, which confused me a lot, but the zip'd source file had the complete code.

---

I take it you are not referring to my link?

Quote:

---

Originally Posted by Arjay

I take it you are not referring to my link?

---

There was a link before yours. If this one doesn't work tonight I'll try your link... it does look simpler, lol.

a CDatabase connection can be use to create the ODBC Connection very easily. The default option when creating this will bring up a dialog box allowing you to select an existing ODBC connection already setup as a data source on your PC/Server (depending on how you're deploying the app) - or you can store the DSN (datasource name) as a #def, extract it from a field or hardcode it (just for testing of course :-)

You can use the wizards to create a CRecordset class based on an extant SQL database (SQL Server express will do just fine) using your existing tables - and it will create a class with all the member variables you need (representing the table as presented in SQL).

Once you get it working you'll be amazed at how simple this method is.

Quote:

---

Originally Posted by GCDEF

That is way more code than you need. Way, way, way more.
If you can use MFC, look at the CRecordset class.

---

I'm running into some similar problems again. I tried "Post Number 8" in the thread linked above, and it keeps talking about going to Add Class, then to choose a selection I don't have (In both post 8 and in post 4). The only options I have when I am in the Add Class wizard are:
C++ Class
Windows Form
Component Class

These options are NOTHING like what I am being told to select. If I select C++ Class, it is simply a "type in a name and finish" scree, no options.

So... I did a search for CRecordset, and just got some general syntax pages, I don't know how to implement it or use it. Do you know of a good tutorial or code sample?

Did you try to load the AccessWOLEDb.zip solution in the link provided?

What version and edition of Visual C++ are you using? (i.e Visual Studio 2008 Professional).

I'm using VC++ 2008 Express
Microsoft Visual Studio 9.0.30729.1 SP
.NET Framework 3.5 SP1

When using the provided code, None of the includes in stdafx.h can be found.

Quote:

---

Originally Posted by Suamere

I'm using VC++ 2008 Express
Microsoft Visual Studio 9.0.30729.1 SP
.NET Framework 3.5 SP1

When using the provided code, None of the includes in stdafx.h can be found.

---

In your first post, you mentioned..

Code:

---

Repeat: I don't CARE What setup your example is in..

---

So I sent you the code for opening an Access database using the ATL Consumer classes in MFC.

Unfortunately the VC++ 2008 Express edition that you have doesn't support MFC. Use a non-Express VC++ edition from 2003 onwards and the code should work fine.

This explains why you don't see the options with regard to inserting an ATL OLEDB consumer class.

Ah... That makes sense. And makes me mad again, lol. I'll try to get one. Thanks.

Turns out it is impossible to use a Database with C++ unless you pay for Microsoft's VC++ 2008. Previous versions are no longer available for download from what I've read, and the express editions don't support MFC.

In addition, it appears there is no way to connect to a database using another compiler such as Dev C++, since MFC is apparently the ONLY way to connect to a database.

So sorry to all you C++ Wannabe developers who wanna use a database (the backbone of any application). You can't unless you buy VC++ 2008 from Microsoft.

Quote:

---

Originally Posted by Suamere

Turns out it is impossible to use a Database with C++ unless you pay for Microsoft's VC++ 2008. Previous versions are no longer available for download from what I've read, and the express editions don't support MFC.

In addition, it appears there is no way to connect to a database using another compiler such as Dev C++, since MFC is apparently the ONLY way to connect to a database.

So sorry to all you C++ Wannabe developers who wanna use a database (the backbone of any application). You can't unless you buy VC++ 2008 from Microsoft.

---

This is untrue. For one thing, any non-Express editions of Visual Studio will work. That includes VC6, VC 2002, VC 2003, and VC 2005.

C++ is huge and I admit that it has a lot more steeper learning curve than any of the modern present day languages.
Regarding your knowledge of Visual Basic, I am not sure if you are talking about classic VB (VB 6 and versions before that) or VB.NET. VB 6 is old and Microsoft has stopped encouraging any one from using classic VB that runs without .NET framework. But it still continues to support and improve up on its versions of Visual C++. Every edition of Visual Studio that comes out has a good amount of enhancements made for Visual C++.
And if you are talking about VB.NET it is very much in use and is huge. Ofcourse, having an expertise of Vb helps but it has a lot more to it than classic VB. Also, if you are using VB.NET then it runs on .NET framework which also supports development in C# and C++ language. If you are developing windows apps, you can use managed C++ and follow the wizards provided by Visual Studio to connect to database.
Regarding the edition problem, I would suggest you to d/l the trial versions for free from MSDN for learning purposes. You can d/l Visual Studio 2008 professional edition trial version that works for 90 days from MSDN which I believe would be enough for u to get a feel of the immense database connectivity support provided by MS for C++.
It happens to everyone...banging ur head, tearing ur hair, throwing computer out of the window and all...But it occurs to be that u are not there yet. C++ means patience and extreme debugging. And of course, Codeguru forums. I have got 95% of help for my academic project which was a software developed using MS VC++ 2005 from Codeguru forums.
Thank god TheCPUWizard did not see ur post, otherwise he would have first asked u to scrap out any older versions u are working on and get new ones. Arjay's example for database connectivity using ATL OLE DB is good one and it is only one way of doing things.

Just a tip: You can use a good book for Visual C++ and turn to the database section. It has a step by step tutorial type explanation of how to connect to a database. There are plenty from Wrox, The Complete reference ones, MFC programming Unleashed, Visual Studio 2003 kick start and more....

Regards,
Bhushan

Quote:

---

Originally Posted by Suamere

Turns out it is impossible to use a Database with C++ unless you pay for Microsoft's VC++ 2008. Previous versions are no longer available for download from what I've read, and the express editions don't support MFC.

In addition, it appears there is no way to connect to a database using another compiler such as Dev C++, since MFC is apparently the ONLY way to connect to a database.

So sorry to all you C++ Wannabe developers who wanna use a database (the backbone of any application). You can't unless you buy VC++ 2008 from Microsoft.

---

That's just not true. You seem to have had an attitude of failure from the beginning. There are MFC classes that make it easiers, but MFC is not a requirement.

Quote:

---

Originally Posted by GCDEF

That's just not true. You seem to have had an attitude of failure from the beginning. There are MFC classes that make it easiers, but MFC is not a requirement.

---

Yes yes, I know. Arjay and you others are nice for reading and responding to my post. But though I haven't put years of work into "connecting to a database with C++) I have put a few hours a night for the last 3 weeks and am still unsuccessful.

This thread has turned into an exact copy of every other 1,000,000 threads out there asking how to connect to a database. It has turned into vague comments and no resolve.

I sound irate because it is literally impossible to get a database connection without paying for VC++ (year). Express edition is the only free edition, and previous versions are no longer available, since MS found out people want them.

I'm mainly using Dev C++, and have created a pretty nice MUD just as my program for learning to develop in C++. I have everything working except a database, so when I shut down, everything is lost.

So thanks for attempting to think you're helping, but vague "YES YOU CAN" comments don't make my program connect to a database.

If this happens to be the last post, my current "hope" is that searching for "C++ ODBC Wrapper" can help me track down a solution, and perhaps in that wrapper is the secret to how to properly connect to a DB.

Good grief dude. This took all of 30 seconds to find.

http://www.easysoft.com/developer/la..._tutorial.html

Quote:

---

Originally Posted by GCDEF

Good grief dude. This took all of 30 seconds to find.
http://www.easysoft.com/developer/la..._tutorial.html

---

Yes, that is helpful. Not sure what you searched for, but in all my searches I haven't found that. While it actually didn't work, it did lead me to something that did, with some tweaking.

Quote:

---

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

#define _countof(arr) (sizeof(arr)/sizeof(arr[0]))

int main() {
SQLHENV henv;
SQLHDBC hdbc;
SQLHSTMT hstmt;
SQLRETURN retcode;
SQLPOINTER rgbValue;
int i = 5;
rgbValue = &i;

SQLCHAR OutConnStr[255];
SQLSMALLINT OutConnStrLen;

HWND desktopHandle = GetDesktopWindow(); // desktop's window handle

// Allocate environment handle
retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);

// Set the ODBC version environment attribute
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER*)SQL_OV_ODBC3, 0);

// Allocate connection handle
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

// Set login timeout to 5 seconds
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
SQLSetConnectAttr(hdbc, SQL_LOGIN_TIMEOUT, (SQLPOINTER)(rgbValue), 0);

retcode = SQLDriverConnect( // SQL_NULL_HDBC
hdbc,
desktopHandle,
(SQLCHAR*)"Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\\Database.mdb",
_countof("Driver={Microsoft Access Driver (*.mdb)}; DBQ=c:\\Database.mdb"),
OutConnStr,
255,
&OutConnStrLen,
SQL_DRIVER_NOPROMPT );


// Allocate statement handle
std::cout << OutConnStr;
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
std::cout << "Successfully Connected";
system("PAUSE");
// Process data
if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
}

SQLDisconnect(hdbc);
}else{
fprintf(stderr, "Failed to Connect\n");
system("PAUSE");
}

SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
}
SQLFreeHandle(SQL_HANDLE_ENV, henv);
}
}

---

I mentioned the prompt coming up, and I edited my code above to fix it, it simply required the NOPROMPT instead of PROMPT, lmao.

Now I just have to figure out how to implement this into my programs and run SQL on it.

Quote:

---

Originally Posted by Suamere

Please do not ask me questions. I don't care what compiler you tell me to use (VC++, Mac-Based, DevC++, etc)

---

Quote:

---

Originally Posted by Suamere

Repeat: I don't CARE What setup your example is in..

---

...

Quote:

---

Originally Posted by Suamere

I sound irate because it is literally impossible to get a database connection without paying for VC++ (year). Express edition is the only free edition, and previous versions are no longer available, since MS found out people want them.

---

:rolleyes:

Quote:

---

Originally Posted by Suamere

I sound irate because it is literally impossible to get a database connection without paying for VC++ (year). Express edition is the only free edition, and previous versions are no longer available, since MS found out people want them.

---

I doubt that Microsoft has anything to do with it. I don't know what country you are from, but if you are interested in programming, it just may be worth buying a copy of Visual Studio.

Search google for "buy VC++ 2005 professional". I've found Visual Studio 2005 Standard Edition" for as low as $50.

Look at it this way. You said you've spent 3 weeks trying to figure this stuff out only to find out that your free VS edition couldn't get the job done. If you spent just 2 hours a day and pay yourself a modest $10/hour, you've spent $300 worth of time over the past 3 weeks searching for a solution.

That's not the worse of it. Consider what will happen if you have to program using the antiquated ODBC api. Using the raw api, it's going to take you 10 times as long to get anything done compared to using a non-express VS edition and being able to use some modern classes like MFC, ADO, ATL OLEDB an so on.

If you are a hobbyist, that's fine, but if you are serious about a career in software development, then it might be worth investing in a copy of Visual Studio. It might even make you more attractive in the job market as well, if you had more up date technologies under your belt.

Thanks Martin, lol. I've posted on other forums playing "yes sir" and all those threads turned into nothing. By presenting you guys with a challenge I finally got a response that started to help me get into the general area by which I could find help. Good enough for me, though.

Hey, since you're all here, do you happen to know what this code set is called? I am an SQL master, but SQL seems so dirty in C++. When I look it up, I get a lot of MFC results and some conn->Execute stuffs that wouldn't work with the code I'm using.

I've looked into SQLDirectExec and SQLExecute, and will eventually figure it out. But what is this code set called? Is it called SQLExt?

My next goal is to use Stored Procedures in my Access Database.

Quote:

---

Originally Posted by Suamere

Thanks Martin, lol. I've posted on other forums playing "yes sir" and all those threads turned into nothing. By presenting you guys with a challenge I finally got a response that started to help me get into the general area by which I could find help. Good enough for me, though.

Hey, since you're all here, do you happen to know what this code set is called? I am an SQL master, but SQL seems so dirty in C++. When I look it up, I get a lot of MFC results and some conn->Execute stuffs that wouldn't work with the code I'm using.

I've looked into SQLDirectExec and SQLExecute, and will eventually figure it out. But what is this code set called? Is it called SQLExt?

My next goal is to use Stored Procedures in my Access Database.

---

SQL isn't 'dirty' in C++ if you don't program with 20 year old technology. I can create a SQL connection and call a SQL stored procedure in about 5 minutes in C++. Can you do that with the raw SQLDirect et al, api's?

Last I knew stored procedures weren't available in Access. What version have they become available?

Quote:

---

Originally Posted by Arjay

Last I knew stored procedures weren't available in Access. What version have they become available?

---

Since forever:
http://images.devshed.com/af/stories...les/adop02.jpg

You just have to manage the database with a server.

I see where there was confusion, though. I suppose I could just ask in general how to call stored procedures with C++.

Good that this thread got you going. Just a thought, looking at your extent of expertise with C++, I would really suggest you to grab a decent book for a specific compiler you are using and then turn to the database section. After, you have worked with 2-3 compilers or environments and database connectivity techniques, you will yourself find it easier to learn ahead. Also, you might not need a book for your subsequent attempts to connect to a database. It is only for the starters. To sustain in the current market, you need to know a handful of these.
Goodluck,
Bhushan.

I bought bibles for PHP, .NET, MCDBA, and other books that I've used over the years. I'd do the same for C++ (Dev C++ preferably based on what I've seen and used so far), but I don't even have money for a piece of candy. I can buy bread, milk, gas, and that's about it right now. But I'll get one eventually.

Quote:

---

Originally Posted by Suamere

I bought bibles for PHP, .NET, MCDBA, and other books that I've used over the years. I'd do the same for C++ (Dev C++ preferably based on what I've seen and used so far), but I don't even have money for a piece of candy. I can buy bread, milk, gas, and that's about it right now. But I'll get one eventually.

---

That's odd. In your original post you said "I'll get the compiler you used, on the platform you used it on, with all the setup you have, and I'll use that for the rest of my life if I have to."

Ya. So if somebody said "use this, do this, and this works like this." I'd have done it. What came out of that was the link you posted to a tutorial that linked to something that worked with DevC++. So that's what worked, that's what I'm using.

So I made this DB Connection a function that I call at the beginning of my program, and now whenever I wanna do SQL, how do I do it? I can do SQL within the function like so:

Quote:

---

strcpy((char *) SQLStmt, "Select etc...");
retcode = SQLExecDirect(hstmt, SQLStmt, SQL_NTS);

SQLBindCol(hstmt, 1, SQL_C_CHAR, &rtnCellValue1, sizeof(rtnCellValue1), NULL );

for(;; ){
retcode = SQLFetch(hstmt);
if (retcode == SQL_NO_DATA_FOUND) break;
std::cout << rtnPassword << " - " << rtnCellValue1 << endl;
}

---

That works fine after the SQLDriverConnect within the function, but how do I do that like... in a new function? Do I have to make hstmt global? (Tried that). I dunno how to make the connection useable throughout the program.

Quote:

---

Originally Posted by Suamere

Since forever:
http://images.devshed.com/af/stories...les/adop02.jpg

You just have to manage the database with a server.

I see where there was confusion, though. I suppose I could just ask in general how to call stored procedures with C++.

---

Oh, since 2000 then. The previous Access versions didn't have support for stored procedures.

Quote:

---

Originally Posted by Suamere

Ya. So if somebody said "use this, do this, and this works like this." I'd have done it.

---

You were told that. I supplied a link for using ATL OLEDB with Access in MFC. After walking around the block for about two days, we come to understand you are using a limited version of Visual Studio that doesn't support MFC or ATL. Since it doesn't appear that your questions related to Visual Studio, this forum is no longer the correct forum to post non-Visual Studio related questions. Please post any further inquiries to the C++ (Non Visual C++ Issues) forum.

OH YA!! I JUST BOOTED YOU FROM THIS FORUM!!! /boot

BAM, lmao.