Re: Run ADO/OLE DB from a CD-R

From: Hugh Smith (HughSmith_at_discussions.microsoft.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 11:47:03 -0800

Christoph,
Thanks for posting your reply on the Microsoft ADO forum to my cry for help
about running an app. using ADO/OLE Db from a CD. If you have the time I
would like to follow up and ask a few more in-depth questions.
Firstly, let me set the stage:
I need to get my VB6 app. using ADO/OLE DB to run directly from a CD without
installing any files onto the host machine, or making any registry entries of
changes in the host machine. The database file will be at a location that the
user points the app. towards, and will be at a location that is both readable
and writable (since the CD is read only). The database file will be an ACCESS
2000 .MDB file.
Now I can get this to work using DAO inside the app. and as long as I'm
using Jet 4.0, I can get to the ACCESS file.
The newer ADO/OLE DB combination in the app. also works when the CD is on my
development machine (i.e. Visual Studio installed) or on other machines that
also have had Visual Studio installed, however on all other machines, the ADO
control does not even become active on the VB form when it runs.
I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc)
I even, in desperation tried including my entire set of DLLs from the
System32 folder...still no joy.
Now, your reply said that I "......need AD0 2.8., Jet Replication-Objects,
MSChart, Common Controls and SSTab. As long as these components are installed
on the target machine and as long there is no need write into the App-Dir, I
can see no problem running an App from CD."
As I understand it the MSChart, Common Controls and SSTab files will be for
some function of a VB form, the data access items being ADO 2.8 and Jet
Replication Objects.
Now I'm using ADO SDK 2.8 and Jet 4.0....are you saying that the JRO is what
I should use instead of Jet 4.0 or........???
Any further ideas would be appreciated.....but I cannot interfere with the
host machine, it must run from the CD with the MBD file elsewhere in a
location that can be read from and written to.

Thanks...I owe you,
Hugh Smith

"Christoph Basedau" wrote:

> 18.01.2005 20:43, Hugh Smith schrieb:
> > Bill,
> > thanks for the response...we're trying to get a VB6/ADO/OLE DB application
> > to run from a CD without installation on the machine. The ACCESS 2000 (Jet
> > 4.0) database is available at a location that the user has read and write
> > privileges. We can get this to work very well using 'older' technology (i.e.
> > DAO) together with Jet 4.0, however we would prefer to use ADO/OLE DB if that
> > is possible.
>
> My VB-6 App works if I start it from CD.
> It needs AD0 2.8., Jet.Replication-Objects, MSChart, Common Controls and SSTab.
> As long as these components are installed on the target machine and as long
> there is no need write into the the App-Dir, I can see no problem running
> an App from CD.
>
> --
> Gruesse, Christoph
>
> Rio Riay Riayo - Gordon Sumner, 1979
>

Relevant Pages

  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • Re: DataGrid, DataBinding, ... help!
    ... I'm not using ADO. ... ADO is not the backend database engine, it is a data access layer that ... interprets between your app and that backend. ...
    (microsoft.public.vb.general.discussion)
  • XP SP2 vs. Jet/ADO - Error in simple query?
    ... I have an app that has been installed successfully on dozens of machines. ... The app is written in VB6, and used ADO 2.5 to connect to a local ... by installing Jet 4.0 SP8, but the install procedure told him that his Jet ...
    (microsoft.public.vb.database.ado)
  • "Optional feature not implenented"
    ... I'm trying to insert a record into a table using Jet 4.0 with ADO (from a ... C++ app) and I keep getting the error ... "Optional feature not implemented" ...
    (microsoft.public.access.queries)
  • install/deploy c# app
    ... My app includes CDO and ADO. ... name ADODB, or one of its dependencies, was not found. ... I also tried adding a setup project but it failed due to FxMdac Pugin ...
    (microsoft.public.dotnet.framework.setup)