Solved

How to deploy database embeded application? I cannot use install shield express for delphi.

Posted on 2003-11-03
16
487 Views
Last Modified: 2012-05-04
I use delphi 5 enterprise edition. I need to make database embeded application. I cannot use install shield express for delphi, because I have to modify some configuration for special purpose. To use another installer, I think, I have to know about .dll and registry which are required for installation.

Can you suggest me , which .dll is required, where to install, and where registry has to be modified with specific content.

Please suggest me which database engine should be choosen. I plan to use BDE, and will not use ODBC to avoid driver conflict between microsoft windows version.
0
Comment
Question by:jittidej
  • 6
  • 6
  • 2
  • +2
16 Comments
 
LVL 5

Expert Comment

by:DeerBear
Comment Utility
Hi,

I extremely discourage you to use BDE as it's a DEAD technology.
I would rather go over to Embedded Firebird( a branch of former IB 6.0 open source ) or
SQLLite.

If your needs are very small, then you could think of using Client Datasets, remembering to
include MidasLib unit in order to gain independence from Midas.dll .

HTH,

Andrew
0
 

Expert Comment

by:IamNewbie
Comment Utility
Hello. I tell u how to deploy BDE.
First, find out if u have "c:\Program Files\Common Files\Borland Shared\BDE\bdeinst.cab"
Then extract it (u'll see "BdeInst.dll" file inside this CAB).
Then run this command:

rundll32 "F:\Program Files\Common Files\Borland Shared\BDE\BdeInst.dll", DllRegisterServer

U'll see BDE installation process.
0
 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
0
 

Author Comment

by:jittidej
Comment Utility
Hey meikl
    If I use BDEINST.CAB as your suggestion, with microsoft acess, what will I do anymore?
0
 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
if u use bde with access and you don't want to use odbc,
then u are limited to access95 and access97,
but you cannot connect to access2000 with the bde
without an odbc-driver

if u want to use access2000, then use ado rather than bde.

if u use access95 or access97 then you must also deploy
the dao-objects (can be found by microsoft)

and of curse the bde must be configured

meikl ;-)
0
 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
curse -> course ;-))
0
 

Author Comment

by:jittidej
Comment Utility
meikl
   Where BDE configuration are strored? I think, I should copy the configuration into my installation file.
0
 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
the bde-configuration is stored in the file
idapi32.cfg
but also partial in the registry

i would advice you to take a look to

http://info.borland.com/devsupport/bde/delphifiles.html

specially to this two samples there

-BDE configuration file API
http://info.borland.com/devsupport/bde/files/bdenet.zip

-BDE network installation example with source
http://info.borland.com/devsupport/bde/files/delcfg32.zip

meikl ;-)
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 27

Expert Comment

by:kretzschmar
Comment Utility
also look at simonet's site at


http://www.bhnet.com.br/~simonet/tipstricks/alias.htm´
(its about how to create aliases)
0
 

Author Comment

by:jittidej
Comment Utility
meikl
        I cannot find dao for ms access 97 in microsoft (msdn.microsoft.com). If I use Interbase 5.5 (in Delphi 5 Enterprise Edition), it is easier? If yes, what a file I have to deploy. Have registry to set up? I've never use IB before, so I don't know what a file extention is used for database file?
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 500 total points
Comment Utility
download the mdac 2.7 from misrosoft,
there should be the dao-objects included
(usual each modern windows-pc should be it already installed)

ib would be a bit more complicated to deploy,
because it needs a seperate installation)

easiest would be to use access with ado (no bde),
because as stated above mdac is usual already intalled,
so you have only to deploy your .exe- and your .mdb file

meikl ;-)
0
 
LVL 6

Expert Comment

by:swift99
Comment Utility
BDE is dead technology, as others have stated

Firebird (www.firebird.org) makes a good embedded DBMS for Delphi.  Firebird is the open source release of Interbase, so all of your interbase controls should work with Firebird.
0
 
LVL 6

Expert Comment

by:swift99
Comment Utility
Since you are using the Enterprise edition, you have Embedded Interbase license already.
0
 

Author Comment

by:jittidej
Comment Utility
kretzschmar
    As your suggestion above, Can I call directly to my .mdb without using ODBC? If yes, please give me some example. If I use ms access 2000, can I do like this?

I hope this will be the final question in this topic, and will give you my point.
0
 

Author Comment

by:jittidej
Comment Utility
kretzschmar
    I found this (from microsoft's site)

    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q271/9/08.asp&NoWebContent=1

 "Starting with Microsoft Data Access Components (MDAC) version 2.6, MDAC no longer contains Jet components. In other words, MDAC versions 2.6 and later do not include Microsoft Jet, Microsoft Jet OLE DB Provider, and the ODBC Desktop Database Drivers".

    The system which will be installed my application has vary from windows 98 to windows XP, so I have to prepare my install program to serve these. If I install on windows 98 I have to install MDAC 2.5 too, but for the others it is not neccessary.

    I think, I cannot avoid using odbc. The only thing I need to know is what is odbc configuration file which will be deploy with my application. I think, it's my final question.
0
 

Author Comment

by:jittidej
Comment Utility
kretzschmar
    To avoid using ODBC, I found that Delphi 5.0 has ADO components. I feel that will not use odbc anymore, but still using ODBC driver: Microsoft.Jet.OLEDB.4.0 for MS Access. If I use ADO, for windows 98 user, I have to deploy MDAC 2.5 to get Microsoft Jet, Microsoft Jet OLE DB Provider. I'm not sure, if I deploy Jet 4.0 Components only, not iclude MDAC 2.5, it's ok or not? Have you ever try this?
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 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

10 Experts available now in Live!

Get 1:1 Help Now