Deploying Delphi Applications Which Use Access 97

Wayne Herbert

Delphi Developer

Tue, 02 Oct 2001 03:00:00 GMT

Deploying Delphi Applications Which Use Access 97

The scenario: A PC with Access 97 installed. App written in D3.02
using BDE 4.51, and installed with InstallShield Express. Registry
modified by hand for idda3532.dll, and the dll was copied to the bde
directory. Aliases with correponding path names were created with
InstallShield, matching the alaises used in the TDatabase
dexriptions of the Access databases.

When trying to execute the program I get the following message:

c:\Program Files\PlatInfo\DRIVE\PATH\DATABASE.MDB is not a valid
path

for each and every alias. Clearly, this is a true message, but I do
not know how to get the correct path set up. Remember, there is no
BDE Administrator on this machine.

Help greatly appreciated.

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@keymaps.com

"How can we POSSIBLY use sex to get what we want? Sex IS what we
want!"
--Dr. Frasier Crane

Jeff Overcas

Delphi Developer

Tue, 02 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

I see this whenever I set the database name param dynamically and place
a space before or after the = sign. It must be like

Database Name=c:\MyDir\myDb.mbd

If instead I do

Database Name = c:\MyDir\myDb.mdb

I get an error message simular to the one you stated.

Jeff Overcash

Quote

Wayne Herbert wrote:

> The scenario: A PC with Access 97 installed. App written in D3.02
> using BDE 4.51, and installed with InstallShield Express. Registry
> modified by hand for idda3532.dll, and the dll was copied to the bde
> directory. Aliases with correponding path names were created with
> InstallShield, matching the alaises used in the TDatabase
> dexriptions of the Access databases.

> When trying to execute the program I get the following message:

> c:\Program Files\PlatInfo\DRIVE\PATH\DATABASE.MDB is not a valid
> path

> for each and every alias. Clearly, this is a true message, but I do
> not know how to get the correct path set up. Remember, there is no
> BDE Administrator on this machine.

> Help greatly appreciated.

> --
> Wayne Herbert
> Manager, Computer Products
> Key Maps, Inc.
> 1411 West Alabama
> Houston, TX 77006

> Vox: 713.522.7949
> Fax: 713.521.3202
> Email: wherb...@keymaps.com

> "How can we POSSIBLY use sex to get what we want? Sex IS what we
> want!"
> --Dr. Frasier Crane

Brian Bushay Tea

Delphi Developer

Wed, 03 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

Quote

> Aliases with correponding path names were created with
>InstallShield, matching the alaises used in the TDatabase
>dexriptions of the Access databases.

>When trying to execute the program I get the following message:

>c:\Program Files\PlatInfo\DRIVE\PATH\DATABASE.MDB is not a valid
>path

>for each and every alias. Clearly, this is a true message, but I do
>not know how to get the correct path set up. Remember, there is no
>BDE Administrator on this machine.

If you can't edit the aliases at installed site you should not use Aliases.
Instead use a Tdatabase which you can set the parameters for in your code.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Wayne Herber

Delphi Developer

Fri, 05 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

So basically, what we are saying here is that the BDE provides only partial
support for Access 97... without the BDE installed, I can't deploy an app with
aliases and which uses idda3532.dll?

Quote

Brian Bushay TeamB wrote:
> If you can't edit the aliases at installed site you should not use Aliases.
> Instead use a Tdatabase which you can set the parameters for in your code.

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@keymaps.com

"How can we POSSIBLY use sex to get what we want? Sex IS what we want!"
--Dr. Frasier Crane

Stefan Paetow - InstallShield Software Corporati

Delphi Developer

Fri, 05 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

On Fri, 16 Apr 1999 15:37:50 -0500, Wayne Herbert <wherb...@keymaps.com>
wrote:

Quote

>c:\Program Files\PlatInfo\DRIVE\PATH\DATABASE.MDB is not a valid
>path

For each of the ALIASES, add the following line to the Additional
Parameters box in the BDE Wizard. Please note that you can access your
created ALIASES from the dropdown box above that specific editbox.

Database=<PATHTODB>\dbname.mdb (i.e. Database=<INSTALLDIR>\mydb.mdb)

Stefan Paetow
-
InstallShield Software Corporation

Express Newsgroups: news://news.installshield.com/
InstallShield Support: http://support.installshield.com/

Stefan Paetow - InstallShield Software Corporati

Delphi Developer

Fri, 05 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

On Mon, 19 Apr 1999 08:59:54 -0500, Wayne Herbert <wherb...@keymaps.com>
wrote:

Quote

>So basically, what we are saying here is that the BDE provides only partial
>support for Access 97... without the BDE installed, I can't deploy an app with
>aliases and which uses idda3532.dll?

Incorrect. Please see my posting higher up in these threads.

Stefan Paetow
-
InstallShield Software Corporation

Express Newsgroups: news://news.installshield.com/
InstallShield Support: http://support.installshield.com/

Jeff Overcas

Delphi Developer

Fri, 05 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

Shouldn't for MSACCESS that be

Database Name=<PATHTODB>\dbname.mdb (i.e.
Database=<INSTALLDIR>\mydb.mdb)

as the parameter?

Jeff Overcash

Stefan Paetow - InstallShield Software Corporation wrote:

Quote

> On Fri, 16 Apr 1999 15:37:50 -0500, Wayne Herbert <wherb...@keymaps.com>
> wrote:
> >c:\Program Files\PlatInfo\DRIVE\PATH\DATABASE.MDB is not a valid
> >path

> For each of the ALIASES, add the following line to the Additional
> Parameters box in the BDE Wizard. Please note that you can access your
> created ALIASES from the dropdown box above that specific editbox.

> Database=<PATHTODB>\dbname.mdb (i.e. Database=<INSTALLDIR>\mydb.mdb)

> Stefan Paetow
> -
> InstallShield Software Corporation

> Express Newsgroups: news://news.installshield.com/
> InstallShield Support: http://support.installshield.com/

Brian Bushay Tea

Delphi Developer

Sat, 06 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

Quote

>So basically, what we are saying here is that the BDE provides only partial
>support for Access 97... without the BDE installed, I can't deploy an app with
>aliases and which uses idda3532.dll?

You need BDE or one of the 3rd party database alternatives to use Access tables.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Wayne Herber

Delphi Developer

Sat, 06 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

I _know_ that, Brian. What is completely lacking in Borprise doc is the manner in
which one deploys Access 97 in conjunction with the BDE. You'll note that it is a
third party software developer who is providing the solutions... not Inland. Once
again, gains made in coding efficiencies are lost to to poor doc on the part of
INprise.

Quote

Brian Bushay TeamB wrote:
> >So basically, what we are saying here is that the BDE provides only partial
> >support for Access 97... without the BDE installed, I can't deploy an app with
> >aliases and which uses idda3532.dll?

> You need BDE or one of the 3rd party database alternatives to use Access tables.

> --
> Brian Bushay (TeamB)
> Bbus...@NMPLS.com

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@keymaps.com

"How can we POSSIBLY use sex to get what we want? Sex IS what we want!"
--Dr. Frasier Crane

Stefan Paetow - InstallShield Software Corporati

Delphi Developer

Sat, 06 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

On Mon, 19 Apr 1999 17:26:04 -0400, Jeff Overcash <overc...@onramp.net>
wrote:

Quote

>Database Name=<PATHTODB>\dbname.mdb (i.e.
>Database=<INSTALLDIR>\mydb.mdb)

You're right Jeff :)

Database Name= it is :)

Stefan Paetow
-
InstallShield Software Corporation

Express Newsgroups: news://news.installshield.com/
InstallShield Support: http://support.installshield.com/

Brian Bushay Tea

Delphi Developer

Sun, 07 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

Quote

>What is completely lacking in Borprise doc is the manner in
>which one deploys Access 97 in conjunction with the BDE.

Since DAO is a Microsoft licensed product my guess is the assumption that it is
already installed on the computers you want to use it or you have one of the
microsoft products that allows you to redistribute it and comes with the tools
to do that distribution

Quote

>You'll note that it is a
>third party software developer who is providing the solutions... not Inland.

To me this seems like the appropriate place for a 3rd party developer to provide
a product.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Wayne Herber

Delphi Developer

Sun, 07 Oct 2001 03:00:00 GMT

Re:Deploying Delphi Applications Which Use Access 97

That still does not solve the problem of having correct parameters for BDE
deployment to use those Access files. This ought to be part of the docs (online or
otherwise)... as usual, it is not.

Quote

Brian Bushay TeamB wrote:
> Since DAO is a Microsoft licensed product my guess is the assumption that it is
> already installed on the computers you want to use it or you have one of the
> microsoft products that allows you to redistribute it and comes with the tools
> to do that distribution

--
Wayne Herbert
Manager, Computer Products
Key Maps, Inc.
1411 West Alabama
Houston, TX 77006

Vox: 713.522.7949
Fax: 713.521.3202
Email: wherb...@keymaps.com

"How can we POSSIBLY use sex to get what we want? Sex IS what we want!"
--Dr. Frasier Crane

Other Threads

1. Deploying a D4 pro/Access 97 application

2. Accessing Delphi (Paradox?) data using Microsoft Access 97

3. locking records in Access 97 using Delphi 3.0

4. Using Access 97 DB's in Delphi 2

5. Royalities using Delphi 3 and Access 97 tables

6. Royalities using Delphi 3 and Access 97 tables

7. Connect delphi 5 with access 97 (idda3235.dll) used

8. Using Access 97 with Delphi 4.0

9. locking records in Access 97 using Delphi 3.0

10. Using Access 97 and Delphi