?
Solved

Portable DBMS which can be easily intergated in VC++

Posted on 2003-03-24
10
Medium Priority
?
416 Views
Last Modified: 2012-06-27
Hi all,
  I'm looking for a portable DBMS which can be easily intergated in VC++.
  My program uses millions of strings and I've got to find a way to store them in a file. Any one tell me the most popular DBMS to store them. All the methods I need are INSERT, DELETE, SELECT with the simplest form. Or you can teach me another way to store and retrieve mass stuff when program is running.
Thanks.
Wang
0
Comment
Question by:wang1st
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +4
10 Comments
 
LVL 6

Expert Comment

by:DaniPro
ID: 8196310
You can use Adaptive Server Anywhere of Sybase and connect it with ODBC.
The database is very strong but not required a database administration.
0
 
LVL 1

Expert Comment

by:hberndt
ID: 8196430
Another way is to use ORACLE Lite. You candownload a developer version from http://otn.oracle.com/software

You can use it stand-alone or connected with an ORACLE Server for synchronization purpose.
0
 
LVL 9

Expert Comment

by:mcallarse
ID: 8196622
Sybase is more powerful. Oracle is more popular. SQL Server is Microsoft. If you have Access 2000+, can install the MSDE engine, which is SQL Server Lite. mySQL is free (Open Source), but not as robust as the other options.
0
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 
LVL 1

Expert Comment

by:__Holly__
ID: 8199511
definitely go with Access and/or MSDE/SQL Server.

you wont need anything THAT complicated in order to 'make it portable' because Windows/MDAC ships with all of the drivers that you need for Access MDB.
0
 

Author Comment

by:wang1st
ID: 8199730
To Holly and all,
  Do all verious version of windows contain the drivers needed to access ACCESS DB? I want to ship my program to all version of windows. If not, is the driver easy to install? I want a driver which can easily access to a DB file so that I do need to customize ODBC and DNS.
Best regards,
Wang
0
 
LVL 1

Expert Comment

by:hberndt
ID: 8201214
If you install Office, you will get the ODBC bridge for Access within the MDAC-components. I am not sure, but while installing Windows, you will get the Data Access Controls to access MDBs. You will to package an Install to ensure that you have all components you need.
0
 
LVL 9

Expert Comment

by:mcallarse
ID: 8202596
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10352089
This question has been classified as abandoned.  I will make a recommendation to the moderators on its resolution in approximately 4 days.  I would appreciate any comments by the experts that would help me in making a recommendation.

It is assumed that any participant not responding to this request is no longer interested in its final deposition.

If the asker does not know how to close the question, the options are here:
http://www.experts-exchange.com/help.jsp#hs5

walterecook
EE Cleanup Volunteer
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10392306
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ - no points refunded

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer
0
 

Accepted Solution

by:
amp072397 earned 0 total points
ID: 10426216
PAQed - no points refunded (of 250)

amp
Community Support Cleanup Moderator
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question