?
Solved

Portable DBMS which can be easily intergated in VC++

Posted on 2003-03-24
10
Medium Priority
?
418 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
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 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