need a proper database for mfc

Question

0.00/5 (No votes)

See more:

Hello Guys,

I am doing a Database project in VC++, I need a database which can store up to 4000 values also it should not depend on any server related matter like need for a local or network server to store/load data :sigh:

Database should be like access along with project files it can be copied(but access lacks storing capacity :( ) and can be executed in any pc.

Please suggest me the proper database :((

Posted 18-Jan-11 6:00am

Rashmi R

Updated 18-Jan-11 6:05am

Henry Minute

v2

Add a Solution

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

Yusuf · Accepted Answer · 2011-01-18T06:06:00

Solution 1

Even though the question was for .net, is there something you can benefit from this SO[^] post?

Posted 18-Jan-11 6:06am

Yusuf

Comments

Espen Harlinn 18-Jan-11 12:08pm

5+ Sqlite for easy deployment, or Firebird - way more powerfull - in embedded mode

Rashmi R 25-Jan-11 9:10am

Thank u, your article helped me..

Espen Harlinn · Accepted Answer · 2011-01-18T06:12:00

Solution 3

Just as an addition to Yusuf's answer - this might be of interest:
SQLite3 MFC Wrapper[^]

Regards
Espen Harlinn

Posted 18-Jan-11 6:12am

Espen Harlinn

Comments

Rashmi R 25-Jan-11 9:13am

Thank u,i will check the article

Nish Nishant · Accepted Answer · 2011-01-18T06:14:00

Solution 4

Not sure what you mean by saying Access is not copyable and that it does not have "storing capacity". Access is file-based, so you only need to distribute the mdb file along with your application. The machines running the app don't even need to have Access installed, it just needs the required ODBC/DAO drivers (which are included by default in Windows installations).

Posted 18-Jan-11 6:14am

Nish Nishant

Comments

Espen Harlinn 18-Jan-11 12:33pm

Note: 64-bit apps doesn't seem to be supported - http://msdn.microsoft.com/en-us/library/ms810810.aspx

Nish Nishant 18-Jan-11 12:35pm

Ok, I am confused. MDAC 2.8 was released as both 32 bit and 64 bit. What else is needed?

Nish Nishant 18-Jan-11 12:36pm

Ah I see, DAO won't be available. But that does not matter, there are non-DAO ways to access an Access database on 64 bit systems.

Espen Harlinn 18-Jan-11 12:40pm

Those mechanisms used, as far as I can remember, to rely on DAO internally. Are you sure it will work for 64-bit solutions? It would be nice to know, in case somebody asks :)

Nish Nishant 18-Jan-11 12:43pm

I haven't used Access in ages, but if there is a 64 bit MDAC library, I would think it's safe to assume that using it should work.

Espen Harlinn 18-Jan-11 12:44pm

This doesn't sound promising though:
Microsoft Jet Database Engine 4.0: Starting with version 2.6, MDAC no longer contains Jet components. In other words, MDAC 2.6, 2.7, 2.8, and all future MDAC/WDAC releases do not contain Microsoft Jet, the Microsoft Jet OLE DB Provider, the ODBC Desktop Database Drivers, or Jet Data Access Objects (DAO). The Microsoft Jet Database Engine 4.0 components entered a state of functional deprecation and sustained engineering, and have not received feature level enhancements since becoming a part of Microsoft Windows in Windows 2000.

There is no 64-bit version of the Jet Database Engine, the Jet OLEDB Driver, the Jet ODBC Drivers, or Jet DAO available. This is also documented in KB article 957570. On 64-bit versions of Windows, 32-bit Jet runs under the Windows WOW64 subsystem. For more information on WOW64, see http://msdn.microsoft.com/en-us/library/aa384249(VS.85).aspx. Native 64-bit applications cannot communicate with the 32-bit Jet drivers running in WOW64.

Instead of Microsoft Jet, Microsoft recommends using Microsoft SQL Server Express Edition or Microsoft SQL Server Compact Edition when developing new, non-Microsoft Access applications requiring a relational data store.

Nish Nishant 18-Jan-11 12:47pm

Ah, thanks. That's quite useful to know. Although I am rather surprised too!

Wow - so there is no way a 64 bit app can talk to an Access mdb file? Really surprised at that!

Espen Harlinn 18-Jan-11 12:53pm

I find it a bit odd too, considering the number of access based solutions out there. On the other hand, I'll certainly recommend upgrading to a "real" database engine - so maybe it isn't so bad after all :)

Nish Nishant 18-Jan-11 12:55pm

Yeah, given that SQL Express is free it's hard to find a reason not to use that instead of Access.

Nish Nishant 18-Jan-11 12:50pm

Okay, I did some googling. Apparently you can still access an Access mdb file from a 64 bit app if you stick to ADO. It's just DAO/JET that do not have 64 bit equivalents.

Not surprising since even Office 2010 includes a full version of Access. So it'd be absolutely stunning if Microsoft decided they won't provide a 64 bit way of accessing Access.

Espen Harlinn 18-Jan-11 12:54pm

Well, thanks, thats good to know ...

Espen Harlinn 19-Jan-11 6:18am

5+ Valuable info in the comments section, might come in handy

Rashmi R 25-Jan-11 9:08am

storing capacity means access has limited no of fields (255) in it, so it's not possible to store 4000 values and can be copied means i can give to the clients .exe file and accessruntime.exe.

jk chan · Accepted Answer · 2011-01-18T06:08:00

Solution 2

I may be wrong,
DO you really need database ? or just files ? :)
If you need to execute queries , i agrees with you.

Posted 18-Jan-11 6:08am

jk chan

Comments

Rashmi R 25-Jan-11 9:09am

i need a database, i've mentioned it in post heading i think..