access database with vc++ 6.0

Question

1.80/5 (2 votes)

See more:

Hello,

I am creating MFC project in vc++ 6.0. I choose access databse at the time of creation of new project following steps:

1] New ->MFC AppWizard(exe) -> Multiple document -> Database view with file support
2]Data Source (select) -> ODBC ->MS Access Database -> Database.accdb -> select table.

My project is created successfully . But now I want to change that access database to other access database in the same VC++ 6.0 project. Which are the steps for it. Please help

Posted 2-Jan-16 23:07pm

Kishor-KW

Updated 2-Jan-16 23:17pm

v2

Add a Solution

Comments

Arthur V. Ratz 3-Jan-16 6:04am

I think that, you have to find the connection string declared in the code generated by Visual Studio Project Creation Wizard and manually change the path to the database file

Kishor-KW 3-Jan-16 7:11am

Thank you...It helps

Arthur V. Ratz 3-Jan-16 7:12am

Really, I'm ready to help you again. Thanks for your opinion.

3 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)

Arthur V. Ratz · Accepted Answer · 2016-01-03T00:09:00

Solution 1

For example, Here you'll have to change DBQ=C:\\Users\\Comp\\Desktop\\DB1.mdb; to DBQ=C:\\Users\\Comp\\Desktop\\DB_NEW.mdb;

C++

CString CMFCApplication1Set::GetDefaultConnect()
{
return _T("DBQ=C:\\Users\\Comp\\Desktop\\DB1.mdb;DefaultDir=C:\\Users\\Comp\\Desktop;Driver={Driver do Microsoft Access (*.mdb)};DriverId=25;FIL=MS Access;FILEDSN=C:\\Users\\Comp\\Documents\\TestDS_NEW.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;");
}

Also, if you need to provide access to multiple databases, you'll have to manually add similar functionality to the one generated by VSS's project wizard.

Also if you need here's link to ODBC API Reference

Posted 3-Jan-16 0:09am

Arthur V. Ratz

Updated 3-Jan-16 0:13am

v3

Comments

Kishor-KW 3-Jan-16 7:10am

CString CProductSet::GetDefaultConnect()
{
// return _T("ODBC;DSN=Sample Data");

return _T("DBQ=D:\\Shifting\\down\\57(bookeg)\\Chapter 20\\DBSample");
}

CString CProductSet::GetDefaultSQL()
{
return _T("[Products]");
}

above is my connectionstring
(return _T("ODBC;DSN=Sample Data");
(this is old one which I commented)
Is this right because it is giving error (abort,retry,ignore type)

Kishor-KW 3-Jan-16 7:10am

What changes should I do if database is SQL?

Arthur V. Ratz 3-Jan-16 7:11am

Have you tried what I recommended ?

Kishor-KW 3-Jan-16 7:15am

yes I did, error is Debug Assertion Failed

Arthur V. Ratz 3-Jan-16 7:16am

And what error in particular ?

Kishor-KW 3-Jan-16 7:19am

error is Debug Assertion Failed

Arthur V. Ratz 3-Jan-16 7:20am

How Can I help you to workaround this problem.

Kishor-KW 3-Jan-16 7:21am

return _T("DBQ=D:\\Shifting\\down\\57(bookeg)\\Chapter 20\\DBSample");
is DBQ work if database is sql ?

Arthur V. Ratz 3-Jan-16 7:28am

Can you tell me what MS-Access version you're using: prior to MS-Access 2003 or later ?

Arthur V. Ratz 3-Jan-16 7:29am

Do you actually mean that DBQ attribute is for database created in MS SQL Server ??

Arthur V. Ratz 3-Jan-16 7:30am

Actually, It doesn't matter if the database is sql or not, anyway you can use DBQ attribute.

Kishor-KW 3-Jan-16 7:32am

About access it is MS-Acces 2007
DBQ attribute is for database created in MS SQL Server ??
Yes I mean same

Arthur V. Ratz 3-Jan-16 7:34am

It's not. The difference between DBQ and DSN is explained below:

Arthur V. Ratz 3-Jan-16 7:33am

Clarification:
DBQ is used when you're binding a database file;
DSN is used when you're using a data source previously configured;

Kishor-KW 3-Jan-16 7:34am

Ok, Thanks alot

Arthur V. Ratz 3-Jan-16 7:35am

You're welcome.

Kishor-KW 3-Jan-16 7:36am

:)

Kishor-KW 3-Jan-16 7:39am

Is this possible project already created in vc++ 6.0 without database and now I want to add database to it. which step should I follow.

Arthur V. Ratz 3-Jan-16 7:43am

See https://msdn.microsoft.com/en-us/library/2dhc1abk.aspx for more information on how to do it

Arthur V. Ratz 3-Jan-16 7:42am

Yes, you can do it manually, implementing your own code that solve a particular problem.

Kishor-KW 3-Jan-16 7:45am

Ok I will, It will be greatfull if you provide some example or steps to do that...Thanx once again

Arthur V. Ratz 3-Jan-16 7:46am

If you have a question, just let me know by posting a message or comment under this subject.

Kishor-KW 3-Jan-16 7:52am

I follows the steps as :

1] Create new dialog for which I want to access database for storing and retrieving purpose.
2] Then I create class for this,By default its base class is Dialog, I changed it to RecordView.
3]Then It is ask for class but in drop down there is no class so I create class by click on New tab overthere.
4]But It give message that Class name create .h and .cpp file and contain reclaim of it.
Dos not able to create class.

Am I follows right steps?

Arthur V. Ratz 3-Jan-16 7:59am

1. You have to use single/multiple documents template.

2. Step 2,3,4 are incorrect. Have you read this https://msdn.microsoft.com/en-us/library/2dhc1abk.aspx

Kishor-KW 3-Jan-16 8:08am

but how to add single or multiple document after creating project(at the time of creation project we choose that), then if we want to add/insert new control then Dialog is option. This project is handover to me and I don't know that is Developer select Multiple document at the time of creation or not.

Kishor-KW 3-Jan-16 8:09am

I did't read that uptill but ok I read it first and then any problem occured I will ask you. Thank you

Arthur V. Ratz 3-Jan-16 8:05am

Normally you have to use CDatabase + CRecordset classes functionality.

Kishor-KW 3-Jan-16 11:25am

I read but I did not found how to add databse to project already created

Arthur V. Ratz 3-Jan-16 11:32am

The only what I can suggest is:
Option1: Read the documentation on how to create A - SDI interface using document/view template, B - MDI interface using document/view template. And then, try to implement the code that works with database.
Option2: Find someone who will create this customized project for you.

Kishor-KW 3-Jan-16 23:02pm

please just specify steps to add database to newly added dialogbox.

Arthur V. Ratz 4-Jan-16 0:11am

1. Add a dialog box to your newly created application;
2. Since, the project wizard does not generate the code that implements the database access functionality for dialog boxes, you have to manually use CDatabase + CRecordset classes methods to implement the database access.

Is that actually what you have ment ?
If this would allowed to attach files to the posts, I would post a complete VSS project that you could download and use.

Arthur V. Ratz 4-Jan-16 0:16am

O'key, I'll email you a complete project as soon as I can.

Kishor-KW 4-Jan-16 0:20am

That will be really greatfull

Arthur V. Ratz 4-Jan-16 0:23am

O'key, I've just started.

Arthur V. Ratz 4-Jan-16 1:48am

What do you mean "complete" ?

Kishor-KW 4-Jan-16 2:01am

means did you send me a mail?

Arthur V. Ratz 4-Jan-16 2:10am

Not now, I'm still working on it. Is it really urgent?
I'm about to complete in just an hour or a half.
Are you able to wait for just a bit more ?

Kishor-KW 4-Jan-16 2:14am

Ok I will wait

Arthur V. Ratz 4-Jan-16 3:00am

I've sent you my project's source. Check your e-mail.

Arthur V. Ratz 4-Jan-16 3:14am

Have you received my e-mail ?!?!

Kishor-KW 4-Jan-16 3:15am

yes I got a mail. Thank you very much

Arthur V. Ratz 4-Jan-16 3:19am

You're welcome. I've sent your message reply by e-mail. I've got a question for you in.

Arthur V. Ratz 4-Jan-16 3:26am

Is this is it ? Any other questions or the subject is closed ?

Kishor-KW 4-Jan-16 3:58am

To add more colums I think I have change in following for loop, but what should be change. My fisrt cloumn is integer and other all are Text. plz give one example
for (int iRow = 0; !pRecordSet->IsEOF(); iRow++)

Kishor-KW 4-Jan-16 4:23am

what wrong here:

pRecordSet->MoveFirst();
for (int iRow = 0; !pRecordSet->IsEOF(); iRow++)
{
CDBVariant varField[8];
pRecordSet->GetFieldValue((short)0, varField[0]);

_TCHAR szField0[256] = _T("\0");
wsprintf(szField0, _T("%d"), varField[0].m_iVal);
pListCtrl->InsertItem(LVIF_TEXT | LVIF_STATE, iRow, szField0, 0, 0, 0, 0);

pRecordSet->GetFieldValue((short)1, varField[1]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[1].m_pstringW));

//pRecordSet->GetFieldValue((short)2, varField[2]);

/*_TCHAR szField2[256] = _T("\0");
wsprintf(szField2, _T("%d"), varField[2].m_iVal);
pListCtrl->SetItemText(iRow, 2, szField2);*/

pRecordSet->GetFieldValue((short)1, varField[2]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[2].m_pstringW));

pRecordSet->GetFieldValue((short)1, varField[3]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[3].m_pstringW));

pRecordSet->GetFieldValue((short)1, varField[4]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[4].m_pstringW));

pRecordSet->GetFieldValue((short)1, varField[5]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[5].m_pstringW));
pRecordSet->GetFieldValue((short)1, varField[6]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[6].m_pstringW));
pRecordSet->GetFieldValue((short)1, varField[7]);
pListCtrl->SetItemText(iRow, 1, static_cast<const wchar*="">(*varField[7].m_pstringW));

pRecordSet->MoveNext();
}

pRecordSet->Close();
pdb->Close();

return TRUE; // return TRUE unless you set the focus to a control
}

Arthur V. Ratz 4-Jan-16 4:30am

Oh my god. Everything is wrong in this code. Just use the Solution 3.

Kishor-KW 4-Jan-16 4:50am

First-chance exception at 0x75877250 (KernelBase.dll) in SampleDBApp.exe: 0xC0000005: Access violation reading location 0xFEEEFEEE.
This exception occured

Arthur V. Ratz 4-Jan-16 4:52am

Let me see

Kishor-KW 4-Jan-16 4:55am

For loop of insert/set run successfull then exception occured on line
return (BOOL) ::SendMessage(m_hWnd, LVM_SETITEMTEXT, nItem, (LPARAM)&lvi);
of following function

BOOL CListCtrl::SetItemText(int nItem, int nSubItem, LPCTSTR lpszText)
{
ASSERT(::IsWindow(m_hWnd));
ASSERT((GetStyle() & LVS_OWNERDATA)==0);
LVITEM lvi;
lvi.iSubItem = nSubItem;
lvi.pszText = (LPTSTR) lpszText;
return (BOOL) ::SendMessage(m_hWnd, LVM_SETITEMTEXT, nItem, (LPARAM)&lvi);
}

Arthur V. Ratz 4-Jan-16 4:59am

I know. I'll probably send you this project again with changes made. Just wait a little bit more time.

Kishor-KW 4-Jan-16 5:01am

plz in vc++ 6.0 will be good

Arthur V. Ratz 4-Jan-16 5:10am

1. I don't have vc++ 6.0 unfortunately;
2. I've sent you an update see your email inbox.

Kishor-KW 4-Jan-16 5:12am

Ok Thanks

Arthur V. Ratz · Accepted Answer · 2016-01-03T20:56:00

C++

#define LVCOLUMNS 3

static LVCOLUMN lpSampleDBListColumns[] = 
	{ { LVCF_TEXT | LVCF_WIDTH, 0, 30, _T("CustID"),   256, 0 },
	  { LVCF_TEXT | LVCF_WIDTH, 0, 30, _T("CustName"), 256, 0 },
	  { LVCF_TEXT | LVCF_WIDTH, 0, 30, _T("CustQty"),  256, 0 } };

BOOL CSampleDBAppDlg::OnInitDialog()
{
	CDialogEx::OnInitDialog();

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		BOOL bNameValid;
		CString strAboutMenu;
		bNameValid = strAboutMenu.LoadString(IDS_ABOUTBOX);
		ASSERT(bNameValid);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon

	// TODO: Add extra initialization here
	CListCtrl* pListCtrl = NULL;
	if ((pListCtrl = (CListCtrl*)GetDlgItem(IDC_SAMPLEDBLIST)) != NULL)
	{
		CRect lvRect; pListCtrl->GetClientRect(&lvRect);
		int nColumnsCount = sizeof(lpSampleDBListColumns) / sizeof(LVCOLUMN);
		for (int iIndex = 0; iIndex != nColumnsCount; iIndex++)
		{
			lpSampleDBListColumns[iIndex].cx = lvRect.Width() / nColumnsCount;
			pListCtrl->InsertColumn(iIndex, &lpSampleDBListColumns[iIndex]);
		}
	}

	CDatabase* pdb = new CDatabase();
	if (!pdb->OpenEx(_T("DBQ=E:\\SampleDB.mdb;DefaultDir=E:\\;Driver={Driver do Microsoft Access (*.mdb)}; \
		DriverId=25;FIL=MS Access;FILEDSN=E:\\TestDB0.dsn;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;")))
	{
		TRACE0("Unable to connect to database using the data source");
	}

	CRecordset* pRecordSet = new CRecordset(pdb);
	if (!pRecordSet->Open(AFX_DB_USE_DEFAULT_TYPE, _T("SELECT * FROM CUSTOMERS")))
	{
		TRACE0("Unable to open recordset");
	}

	pRecordSet->MoveFirst();
	for (int iRow = 0; !pRecordSet->IsEOF(); iRow++)
	{
		CDBVariant varField[3];
		pRecordSet->GetFieldValue((short)0, varField[0]);

		_TCHAR szField0[256] = _T("\0");
		wsprintf(szField0, _T("%d"), varField[0].m_iVal);
		pListCtrl->InsertItem(LVIF_TEXT | LVIF_STATE, iRow, szField0, 0, 0, 0, 0);

		pRecordSet->GetFieldValue((short)1, varField[1]);
		pListCtrl->SetItemText(iRow, 1, static_cast<const>(*varField[1].m_pstringW));

		pRecordSet->GetFieldValue((short)2, varField[2]);

		_TCHAR szField2[256] = _T("\0");
		wsprintf(szField2, _T("%d"), varField[2].m_iVal);
		pListCtrl->SetItemText(iRow, 2, szField2);

		pRecordSet->MoveNext();
	}

	pRecordSet->Close();
	pdb->Close();

	return TRUE;  // return TRUE  unless you set the focus to a control
}</const>

Arthur V. Ratz · Accepted Answer · 2016-01-03T22:08:00

Like this:

C++

pRecordSet->MoveFirst();
for (int iRow = 0; !pRecordSet->IsEOF(); iRow++)
{
     CDBVariant varField[3];
     pRecordSet->GetFieldValue((short)0, varField[0]);

     _TCHAR szField0[256] = _T("\0");
     wsprintf(szField0, _T("%d"), varField[0].m_iVal);
     pListCtrl->InsertItem(LVIF_TEXT | LVIF_STATE, iRow, szField0, 0, 0, 0, 0);

     for (short iField = 1; iField < 3; iField++)
     {
	  pRecordSet->GetFieldValue((short)iField, varField[iField]);
	  pListCtrl->SetItemText(iRow, iField, 
            static_cast<const>(*varField[iField].m_pstringW));
     }

     pRecordSet->MoveNext();
}</const>