Re: Run ADO/OLE DB from a CD-R
From: Christoph Basedau (e_tonne_at_hotmail.com)
Date: 01/20/05
- Next message: R Benak: "Integrated Security=SSPI"
- Previous message: Frank Hickman [MVP]: "Re: What technology to use?"
- In reply to: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Next in thread: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Reply: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 13:11:20 +0100
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: R Benak: "Integrated Security=SSPI"
- Previous message: Frank Hickman [MVP]: "Re: What technology to use?"
- In reply to: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Next in thread: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Reply: Hugh Smith: "Re: Run ADO/OLE DB from a CD-R"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
