Re: Run ADO/OLE DB from a CD-R
From: Hugh Smith (HughSmith_at_discussions.microsoft.com)
Date: 01/20/05
- Next message: cyourch: "Design question on DataGrid, DataTable, JOIN and Update()"
- Previous message: Ian: "Re: What technology to use?"
- In reply to: Christoph Basedau: "Re: Run ADO/OLE DB from a CD-R"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 07:37:10 -0800
Thanks - you were very helpful
"Christoph Basedau" wrote:
> 19.01.2005 20:47, Hugh Smith schrieb:
> > 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.
>
> Do you mean the bound-control 'ADODC' when you say 'ADO control'?
> This control doesn't belong to MDAC, but is rather a VB control. So it
> must have been installed at least once on the client machine. There
> is no way to detour registration of ActiveX-controls.
> They won't work even if they're present on file level but unregistered.
>
> > 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.
>
> Same thing. Each control your app depends on, must have been installed
> on the client machine at least once. you don't need to build a new installer
> every time you change your code. But if you add a new component/reference,
> dependencies change, so the new component has to be installed.
> Either by a setup-routine (recommended) or manually by copy and regsvr32.
>
> As I said: "As long as these components are installed on the target machine
> ....I can see no problem running an App from CD."
> If they're not installed, I can see a problem running an App from CD (or HD) :-(
>
> > 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
>
> Yep.
>
> > and Jet Replication Objects.
>
> ADO 2.8 and Jet4.0.
>
> > 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........???
>
> JRO is only for replication a/o DatabaseCompression, it's not a DataProvider.
> You don't need JRO for working ADO and Jet.
> Afaik the Jet-Engine has to be installed separately from MDAC (since 2.6 or 2.7
> iirc), since it s no longer part of the latest MDAC-distris (JRO (->msjro.dll)
> in contrast ships with MDAC, confusing ..)
> The latest JET-distri is afair Jet-SP8.
>
> > 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.
>
> Hhm. If you can not interfere with the host machine, there is probably no way
> to execute an app, whose dependencies are not supplied by the host.
>
> --
> Gruesse, Christoph
>
> Rio Riay Riayo - Gordon Sumner, 1979
>
- Next message: cyourch: "Design question on DataGrid, DataTable, JOIN and Update()"
- Previous message: Ian: "Re: What technology to use?"
- In reply to: Christoph Basedau: "Re: Run ADO/OLE DB from a CD-R"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
