DAO Installation Problem

[gpayne]

I just updated from Hoster version 3.303 to 3.310. The first time I tried, I just ran the update program and did not download it.

Upon start up:

1. It did not find my Plextor 760-A drive on the intital startup of the program.
2. When the program started, I went to the Tools-CD/DVD Drives defaults menu and the drive was listed. I selected it and Hoster then tried to install and configure Windows DAO. It failed saying it could not find the file "C:\docume~1\George\Locals\~1\_temp\is294\DAO.msi.". I have searched "my computer" for this file and it is not there. I have re-tried the installation a couple of times. The second time I tried to install, I downloaded the whole setup file and ran it from my computer selecting the upgrade option. This time it:

1. Tried to configure DAO after the reboot when I started Hoster. The results were the same. It looked for the DAO.mis configuration file and could not find it. Hoster seems to work allright but each time I close it and start it again it tries to configure DAO. It of course, fails because it can not find the file.

It ran fine on version 3.3003.

I am running Windows XP Pro with all the updates including sp2

Any thoughts?

gpayne

[ddouglass]

You should always download the programs and install from your local computer. Just an FYI.

A DAO error has to do with database access. Hoster's database files are in Access 97 format.

A couple of question come to mind as far as the installation goes. You state you are running Windows XP SP2. Do you have all the updates since then?

Do you have NetFrame installed? This is required as well but does need to be installed first before installing Hoster.

Are you running any version of MS Office or Works on this computer? If so again you need to make sure you have all the updates for it.

If you have Restore turned on, I would recommend you try that to get back to your Hoster version 3.303. Make sure it is working ok. Then:

1. Update your Windows XP
2. Install NetFrame if not already installed (should be listed as part of the updates for XP)
3. Then run the Hoster install using the "Upgrade"

Be sure you reboot after each step so XP can finish the install of that item.

[gpayne]

Originally Posted by ddouglass

You should always download the programs and install from your local computer. Just an FYI.

A DAO error has to do with database access. Hoster's database files are in Access 97 format.

A couple of question come to mind as far as the installation goes. You state you are running Windows XP SP2. Do you have all the updates since then?

Do you have NetFrame installed? This is required as well but does need to be installed first before installing Hoster.

Are you running any version of MS Office or Works on this computer? If so again you need to make sure you have all the updates for it.

If you have Restore turned on, I would recommend you try that to get back to your Hoster version 3.303. Make sure it is working ok. Then:

1. Update your Windows XP
2. Install NetFrame if not already installed (should be listed as part of the updates for XP)
3. Then run the Hoster install using the "Upgrade"

Be sure you reboot after each step so XP can finish the install of that item.

Thanks for your reply!

1. I have Microsoft Office for XP pro installed. It is the 2002 version. I have not gotten any updates for it that I know of.
2. I do have netframe version 2 installed
3. The version of XP Pro I have installed is not the xp2 version. I installed the regular verision and then installed every update that was available at the time. This included sp2 and sp2 updates. This was done not more than 3 weeks ago.
4. Hoster version 3.303 was the first version of Hoster installed on this machine as it is a new machine that I built and dedicated to KJ. I have done 2 shows from this machine, the last one being last night.
5. I can and have restored to a restore point just prior to the Hoster Version 3.310 version install.
6. I have Hoster version 3.310 installed on my other machine and it works fine. I also have NetFrame and Office XP pro installed on that machine. The biggest difference between the two machines is that I have not updated the XP Pro SP2 updates on the machine that works properly with Hoster Version 3.310.
7. The last install I did of Hoster Version 3.310 on the new machine was done with the update exe file placed in the my documents folder on my C:\drive and I did the upgrade install. I have never had this problem on my older machine.
I can and will go back to Version 3.303 until I find out what is going on. It is not critical because I have my backup machine(Original) but I would like to be able to use the newer version of hoster on the new machine. I will get all the updates for Office XP pro and double check for sp2 service pack updates. If there is anything else you can think of please let me know.

Thanks again
gpayne

[gpayne]

Originally Posted by gpayne

Thanks for your reply!

1. I have Microsoft Office for XP pro installed. It is the 2002 version. I have not gotten any updates for it that I know of.
2. I do have netframe version 2 installed
3. The version of XP Pro I have installed is not the xp2 version. I installed the regular verision and then installed every update that was available at the time. This included sp2 and sp2 updates. This was done not more than 3 weeks ago.
4. Hoster version 3.303 was the first version of Hoster installed on this machine as it is a new machine that I built and dedicated to KJ. I have done 2 shows from this machine, the last one being last night.
5. I can and have restored to a restore point just prior to the Hoster Version 3.310 version install.
6. I have Hoster version 3.310 installed on my other machine and it works fine. I also have NetFrame and Office XP pro installed on that machine. The biggest difference between the two machines is that I have not updated the XP Pro SP2 updates on the machine that works properly with Hoster Version 3.310.
7. The last install I did of Hoster Version 3.310 on the new machine was done with the update exe file placed in the my documents folder on my C:\drive and I did the upgrade install. I have never had this problem on my older machine.
I can and will go back to Version 3.303 until I find out what is going on. It is not critical because I have my backup machine(Original) but I would like to be able to use the newer version of hoster on the new machine. I will get all the updates for Office XP pro and double check for sp2 service pack updates. If there is anything else you can think of please let me know.

Thanks again
gpayne

I finished everything you thought might work.

1. Restored to Version 3.303
2. Got the rest of the windows updates I did not have ( 2 ) one of them was an access database security update.
3. Got all of the Microsoft Office updates
4. Reinstalled Hoster Version 3.310 using the update installation choice.

None of this worked. Can you think of anything else?

Your suggestions are appreciated!!!

Thanks

gpayne

[ddouglass]

George, did you get the same error the second time? Did it give you a number?

I seem to remember that when we were Beta testing this version, several of us had a problem with the song.mdb file being corrupt. This could be the case here since DAO is an Access problem. Try deleting your song.mdb file. Then open Hoster. If this was the problem then it should rebuild the song.mdb file and all will be well.

For your problem with the Plextor drive the only thing I can think of is firmware update for the drive. I know there is one on Plextor site as I saw it listed today. I have a 760 also, so I need to update mine as well.

Hope this works.

[gpayne]

Originally Posted by ddouglass

George, did you get the same error the second time? Did it give you a number?

I seem to remember that when we were Beta testing this version, several of us had a problem with the song.mdb file being corrupt. This could be the case here since DAO is an Access problem. Try deleting your song.mdb file. Then open Hoster. If this was the problem then it should rebuild the song.mdb file and all will be well.

For your problem with the Plextor drive the only thing I can think of is firmware update for the drive. I know there is one on Plextor site as I saw it listed today. I have a 760 also, so I need to update mine as well.

Hope this works.

I did get the same error #. It is 1706 (No valid source could be found for product DAO. Windows Installer cannot continue). However, I only get this error code after Windows repeatedly trys to find the DAO installation package and I finally hit the cancel key.
I did delete the song.mdb and songbackup.mdb files. When I started Hoster, this is what happened:

1. I start Hoster.
2. The next screen says Please wait while Windows configures DAO(Gathering Information).
3. The progress bar starts across its box but stops.
4. Another popup box comes up and says. "The feature you are trying to use is on a network resource that is unavailable. In the middle of the popup box there is a line that says "Click OK to try again or enter an alternate path to a folder containing the installation package DAO.msi in the box below." The box below contains the folder where Windows is looking for the installation package. This location is c:\Docume~1\Locals~1\temp\_is2 something.
5. I click ok several times with the same results.
6. I click cancel
7. I get the 1706 error.
8. I click ok.
9. Hoster starts and automatically rebuilds the database.
It appears to me that the new installation or upgrade installation of Hoster triggers the DAO installation. The installation of Hoster must delete the prior DAO installation and so it must be installed again. It also appears to me that if I could point Windows to the location of the DAO installation package, it might be able to install it and everything would be fine.
After Hoster starts, I can search for songs etc. and it finds them, they will play and everything seems fine but I have not tested everything I might do during a show.

I am able to import a cdg disk into the playlist. I have not tried to import anything into the database as of yet.

Do you know if Hoster deletes files and rebuilds them or what Hoster does when you select upgrade installation option?

As for my Plextor, I believe I have the latest firmware upgrade because that is the first thing I do after I get a new drive is to check for firmware updates but I will check their website. The drive seems to working fine though.

Thanks
gpayne

[gpayne]

Originally Posted by gpayne

I did get the same error #. It is 1706 (No valid source could be found for product DAO. Windows Installer cannot continue). However, I only get this error code after Windows repeatedly trys to find the DAO installation package and I finally hit the cancel key.
I did delete the song.mdb and songbackup.mdb files. When I started Hoster, this is what happened:

1. I start Hoster.
2. The next screen says Please wait while Windows configures DAO(Gathering Information).
3. The progress bar starts across its box but stops.
4. Another popup box comes up and says. "The feature you are trying to use is on a network resource that is unavailable. In the middle of the popup box there is a line that says "Click OK to try again or enter an alternate path to a folder containing the installation package DAO.msi in the box below." The box below contains the folder where Windows is looking for the installation package. This location is c:\Docume~1\Locals~1\temp\_is2 something.
5. I click ok several times with the same results.
6. I click cancel
7. I get the 1706 error.
8. I click ok.
9. Hoster starts and automatically rebuilds the database.
It appears to me that the new installation or upgrade installation of Hoster triggers the DAO installation. The installation of Hoster must delete the prior DAO installation and so it must be installed again. It also appears to me that if I could point Windows to the location of the DAO installation package, it might be able to install it and everything would be fine.
After Hoster starts, I can search for songs etc. and it finds them, they will play and everything seems fine but I have not tested everything I might do during a show.

I am able to import a cdg disk into the playlist. I have not tried to import anything into the database as of yet.

Do you know if Hoster deletes files and rebuilds them or what Hoster does when you select upgrade installation option?

As for my Plextor, I believe I have the latest firmware upgrade because that is the first thing I do after I get a new drive is to check for firmware updates but I will check their website. The drive seems to working fine though.

Thanks
gpayne

I still need some help with this!

Would MTU like to jump in sometime???

gpayne

[admin]

Bryan is on vacation this week, but I will email him to take a look at this. If he can't answer, he will be back on Monday.

I would NOT do an upgrade when you are having problems. Run the Hoster 3.310 Installation program and select REMOVE. This will remove Hoster and related installed components.

Then, run the Installation program again, and it will want to install from scratch. Do this and post back here what happens.

Hoster includes the Access 97 Jet Engine install package. This should add Access 97 to your computer. I don't remember anyone having a DAO error, which as Dale said is related to the database, after doing a REMOVE and INSTALL.

[gpayne]

Originally Posted by admin

Bryan is on vacation this week, but I will email him to take a look at this. If he can't answer, he will be back on Monday.

I would NOT do an upgrade when you are having problems. Run the Hoster 3.310 Installation program and select REMOVE. This will remove Hoster and related installed components.

Then, run the Installation program again, and it will want to install from scratch. Do this and post back here what happens.

Hoster includes the Access 97 Jet Engine install package. This should add Access 97 to your computer. I don't remember anyone having a DAO error, which as Dale said is related to the database, after doing a REMOVE and INSTALL.

Thanks!

I was going to try to do the remove option but I thought I would wait to get some feedback. I will do an install with the delete option and let you know.

[gpayne]

Originally Posted by gpayne

Thanks!

I was going to try to do the remove option but I thought I would wait to get some feedback. I will do an install with the delete option and let you know.

I just did a new install with the delete option. I got the same results. No need to bother Bryan on his vacation. It's not that big a deal. When he gets back you might ask him if the following scenario would or could cause the DAO problem.
1. I have Hoster 3.310 on my non-show compueter.
2. I have been importing bin files on that computer.
3. I then transferred them to the hard drive on my show computer which had Hoster 3.303 on it.
4. I deleted the songs.mdb and songs backup.mdb on the show computer.
5. I then started the show computer and Hoster 3.303 automatically rebuilt the database.
6. After doing this and playing two shows on the show computer, I tried to upgrade the show computer to Hoster Version 3.310.

This is when I started having the DAO installation problem.

This might be someting that effects it or not. I do have all!!!! windows xp and Office xp updates. They are current as of yesterday!

Thanks

gpayne

[admin]

Excellent facts for us to go on. We all want to get to the bottom of this. We are studying the Plextor drive models you have to see if there may be a wrong definition structure for them that might cause this.

The code we are using is new to us from a reputable vendor. All drives that are "claimed" to be supported have been "assumed" to already be proven. However, I'm beginning to question that.

The question yet to be determined is what is causing this and how to fix it.

[barrp]

Was there ever a solution for this? I'm having the same problem and running the same 760A drive, but this drive has not worked for a few months and I'm using an external drive to load cdg's. chemas-microsoft-com:office:office" />

Hoster 3.310 is also locking up while trying to read cdg's from my external drive that had worked with the old version.

This is the same computer that has been running Hoster for over a year with a new hard drive. I tried the 3.310 upgrade on the old drive before adding the new drive, and did not get the error message but Hoster did lock up trying to load cdg's.

[barrp]

I removed 3.310 and installed 3.303 and everything appears to work again. I still like to see a solution for 3.310 so I can upgrade in the future.

[ddouglass]

Admin - I think I have found the problem. This is from a MS Knowledge Base Article #916903

Symptom:
You receive the following error message on the client computer when the package is installing:
Error 1706. No valid source could be found for product Product Name. The Windows installer cannot continue.

Cause:
These problems occur because the Windows Installer packages do not have the ALLUSERS property value preset when the packages are created. This causes Windows Installer to set the value to "NULL." When you deploy a package by using SMS 2003, the installation runs under the SYSTEM context. The ALLUSERS property value must be defined if Windows Installer is trying to install as a user who differs from the locally logged-on user. Additionally, when the ALLUSERS property value is set to "NULL," the package performs a "per user installation," and no registry key entry is written to following registry subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall

Resolution:
To resolve this problem, type Name.msi /SwitchesALLUSERS=2 in the Command line box. For example, you can type the following command: install_flash_player_active_x.msi ALLUSERS=2
This transfers the ALLUSERS property to the Setup phase, and the correct data is written to the registry entry key.

Note You cannot use the ALLUSERS property together with the /passive command-line switch.

What this is saying, I believe is that when you scripted for the Jet Engine install the ALLUSERS property was not set......maybe?

GPayne and barrp, when you are installing Hoster are you doing it as an administrator of the computer? If not then try that.

Otherwise, I hope I have found the lead we need to get this one fixed. It is very baffling.

[barrp]

Originally Posted by ddouglass

GPayne and barrp, when you are installing Hoster are you doing it as an administrator of the computer? If not then try that.

Yes, the administrator account is the only one I set up on my system. This is a new hard drive and every thing has been loaded from scratch. One thing I just noticed is that there is another account that does not show on the main start up screen, but under user accounts there is this account:

ASP.N Machine A...
Limited Account
Password Protected

What the heck is it that?

[ddouglass]

ASP.Net - Account used for running the ASP.NET worker process (aspnet_wp.exe) This so you can use those webpages that use ASP (interactive script processing) such as your Store Account for MTU.

You should have a Guest account (disabled) and a Support account (disabled) too.

"I'm having the same problem and running the same 760A drive, but this drive has not worked for a few months" Are sure it is a 760A because they just came out with that model about amonth or so ago?

[barrp]

Originally Posted by ddouglass

ASP.Net - Account used for running the ASP.NET worker process (aspnet_wp.exe) This so you can use those webpages that use ASP (interactive script processing) such as your Store Account for MTU.

You should have a Guest account (disabled) and a Support account (disabled) too.

"I'm having the same problem and running the same 760A drive, but this drive has not worked for a few months" Are sure it is a 760A because they just came out with that model about amonth or so ago?

You are correct it's the 716.

Can I delete the asp.net account? I don't have a support account. I'd like it to just open up, bypassing the main screen.

[gpayne]

Originally Posted by ddouglass

Admin - I think I have found the problem. This is from a MS Knowledge Base Article #916903

Symptom:
You receive the following error message on the client computer when the package is installing:
Error 1706. No valid source could be found for product Product Name. The Windows installer cannot continue.

Cause:
These problems occur because the Windows Installer packages do not have the ALLUSERS property value preset when the packages are created. This causes Windows Installer to set the value to "NULL." When you deploy a package by using SMS 2003, the installation runs under the SYSTEM context. The ALLUSERS property value must be defined if Windows Installer is trying to install as a user who differs from the locally logged-on user. Additionally, when the ALLUSERS property value is set to "NULL," the package performs a "per user installation," and no registry key entry is written to following registry subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\CurrentVersion\Uninstall

Resolution:
To resolve this problem, type Name.msi /SwitchesALLUSERS=2 in the Command line box. For example, you can type the following command: install_flash_player_active_x.msi ALLUSERS=2
This transfers the ALLUSERS property to the Setup phase, and the correct data is written to the registry entry key.

Note You cannot use the ALLUSERS property together with the /passive command-line switch.

What this is saying, I believe is that when you scripted for the Jet Engine install the ALLUSERS property was not set......maybe?

GPayne and barrp, when you are installing Hoster are you doing it as an administrator of the computer? If not then try that.

Otherwise, I hope I have found the lead we need to get this one fixed. It is very baffling.

Dale, my DAO promblem got fixed when I re-installed XP pro.

gpayne

[Beavis]

Originally Posted by gpayne

Dale, my DAO promblem got fixed when I re-installed XP pro.

gpayne

i always say that, when you cant figure out how to fix a problem with hoster, reformat ! its a lot quicker than waiting weeks for a glimmer of hope

[ddouglass]

Originally Posted by Beavis

i always say that, when you cant figure out how to fix a problem with hoster, reformat ! its a lot quicker than waiting weeks for a glimmer of hope

That depends on how much you have on the computer. Starting over can be a real pain if you have a lot of older programs and don't remeber where you put the @#$%^ disks!

Gary glad you got your problem solved and sorry it had to come to a reload.