Solved

Migrating from MSAccess

Posted on 2004-03-31
10
205 Views
Last Modified: 2010-04-05
I have spent lot of time working with DB using Access  driver, but now our requirements have overgrown capabilities of Access, especially in multi-user tasks. I need to switch to something else that works better than Access, uses no BDE/ADO/DAO/ODBC connection, handles multi-user fine and supports full-featured SQL.
0
Comment
Question by:elise_r
10 Comments
 

Expert Comment

by:arnie145
ID: 10727065
Definitively Oracle – it’s the most powerful.
0
 

Expert Comment

by:georg44
ID: 10727094
I know Oracle is not bad :) but it costs a whole bag of bucks. I need something less expensive, without royalty fee.
0
 

Expert Comment

by:layned31
ID: 10727166
When I was walking myself through this choice I picked up Absolute Database from www.componentace.com; after free evaluation I understood that it can fully replace any other DB. Plus it has many extended useful features such as encryption and memory usage. It is especially good in handling frequently-queried tables.
Moreover they have a good support team that answers a question within half a day. When I meet a difficult place I ask ‘em and they write a demo for me which is actually code I need. Just don’t use it very often ;)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 11

Accepted Solution

by:
shaneholmes earned 20 total points
ID: 10727197
"BDE/ADO/DAO/ODBC connection"

What type of conduit do you expect to use? If none of these.

How about MYSQL:

Using Delphi's dbExpress with MYSQL

http://www.mysql.com/



There is also DBISAM

www.elevatesoftware.com

You can make make large two tier apps with that, and it doesn't require and special drivers. Its conduit to the data is compiled right into your EXE, with little footprint.

Shane
0
 
LVL 3

Expert Comment

by:BJThomsen
ID: 10727506
You might wanna check out firebird http://firebird.sourceforge.net/ its an open source verson of Interbase.
0
 
LVL 14

Expert Comment

by:DragonSlayer
ID: 10741322
Yea, FireBird is a good choice if you want opensource but with support for SP and Triggers (which mySQL doesn't have, yet)

Also check out the Embedded Firebird, which allows you to deploy your app without installing the whole Firebird DBMS package.
0
 
LVL 4

Expert Comment

by:Delphian
ID: 12871107
DS:
The whole FB package.... 3.5 Mb... ;-))))

 elise_r :

You can access directly Firebird with:
Commercial ones:
--> IBO -- one of oldest and coolest component suite to Interbase/Firebird (www.ibobjects.com)
--> FIBPlus -- a newer suite, earned respect from community (http://www.devrace.com/en/fibplus/?r1=fibplus&r2=Direct_Link)

Free/Open Source
UIB -- a suite of components for Firebird/Interbase (http://www.progdigy.com/UIB/). They have also
 DBExpress drivers
Mercury Database Objects(MDO) -- brazilian opensource suite for Firebird/Interbase
 http://mdo.sourceforge.net/
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

939 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now