Randem Systems Support Board

Yes, you are correct. It will work as planned with the Auto OS Updater because it installs everything you might possibly need to get your application running.

Ok, thanks a lot Randem !
here is how I use msjro.dll in my application code:
 
Dim JRO As JRO.JetEngine
Set JRO = New JRO.JetEngine
         
JRO.CompactDatabase Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Donnees.dll ;Jet OLEDB:Database Password=test, _
      Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DonneesTmp.dll ;Jet OLEDB:Database Password=test
 
works well.  
Actually, as I use VB_DCOM_MDAC_JET_AutoSetup.exe in my installation package, following your explanations, the right Mdac and Jet support would be installed on the machine depending on his OS, so if I dont change anything it should work without including the msjrodll. Am I wrong ?  
I tried It on few friends pc and it worked well
 
Best regards and happy new year's Eve party ;-))

You could also use JetComp.exe to do the compacting. InnoScript includes this support when it adds JET support to the script.
 

msjro.dll is included with MDAC 2.6 i believe but will not be in MDAC 2.8 because they dropped JET support. There is in the JET deployment modules the support for JET Replication Objects which is what you want to use. So if you follow InnoScript's lead in the deployment you will have everything you need for your application to work on all platforms.
 
How did you use msjro.dll in your application code? and the script?

The link was cut, the entire link is (all the ligne):
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q230501&  
Well I do use ADO and not DAO, but as I wanted to add my programme a way to compact my database I found the first code using DAO, it is why I asked you information about distributing dao360 dll.
But now I changed to use msjro, it works nice but when wanting to distribute it I got the message :
 
C:Windows\System32\msjro.dll
impossible d'enregistrer la bibliotheque DLL/OCX
RegSvr32 a echoue :erreur :0x3
(I tried on a xP machine and a Vista one, same message !)
 
Well, I first tried to run my programme without distributing the dll and it worked on XP and Vista machine. So I wonder if it is really necessary !?
 
Thanks for your help

There is nothing but a search page with that link, but if you use msjro.dll you do need to do the same thing you had to do with dao360.dll if required. I think perhaps you mean to use ADO instead of DAO. DAO is outdated and ADO is the current way of accessing data. You do have to change your code to use ADO instead of DAO. Just changing the file will not do it.

Well, well apparently this dll is no more suported, I found this => http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q230501&
 
So, I will now use msjro.dll instead. Do I have to 'declare' it as well ?

You may need to update your Inno Setup also CopyMode is antiquated... Your line should look something like this:
 
Source: C:\Program Files (x86)\Common Files\microsoft shared\DAO\dao360.dll; DestDir: {cf}\microsoft shared\DAO\; Flags:  regserver restartreplace sharedfile;
 
Also with InnoScript if you DON'T add the Auto OS Updater the JET and MDAC additions will be taken care of automatically. However you will need to download the needed files from the website or the Download menu in InnoScript.

Thanks a lot.
To distribute it, is there special recommandations ?
I simply code it like that, is that all right ?
 
Source: dao360.dll; DestDir: {sys}; CopyMode: alwaysskipifsameorolder; Flags: restartreplace sharedfile
 
Or
 
Source: dao360.dll; DestDir: {sys}; Flags: promptifolder regserver sharedfile
 
I will see to update my installation package with the latest of Innoscript  

Yes, the file is on Vista and Windows 7 but you made no indication on what OS you were supporting. So to be sure your application works on all CLEAN OS's you should include it in your installation and deploy when needed. The file is not included on OS's below Vista and if you don't distribute it properly your applications will not work properly.
 
What version of InnoScript are you using? In the current versions the proper JET engines and MDAC will be deployed instead of the whole Auto OS Updater making your install much smaller and you would not really need to be concerned over distributing that one file (DAO360.dll).

Ok, thanks you.  
One more question, isn't that file automaticaly registered in operating system as Vista or seven ?  
 
And,if so, in that case could we avoid distribute it. I tried my application using this file on computers without distribute it and it worked well.

Yes, you need to re-distribute DAO360.dll and register it. The automatic OS Updater will not do either for that file.

Hi!
Is dao360.dll registered when using the VB_DCOM_MDAC_JET_AutoSetup.exe ? or do i have to include it 'manually' in my installation package ?  
I have just added this reference in my projet and i wonder whether i have to distribuate it or not.  
Thanks for your reply