If you are using an Access DB, then to prevent problems you should be using the Access 2000 strConnString in your config.asp file.
Here is some examples of the Access97 strConnString:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/snitz_forums_2000.mdb") '## MS Access 97 using virtual path
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
If you use the Access97 strConnString, they you will more than likely run into problems when using the MOD Setup.
Here is some examples of the Access2000 strConnString:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000
Using the Access2000 strConnString, you should not encounter the problems with MOD SETUP that you have when using the Access97 strConnString.
Please make sure you have tried all of the above before making a new post about errors when using MOD Setup.
Also,
MOD Setup requires that the Scripting.FileSystemObject be installed and you need to have access to it. If you don't, then you'll either get an error, or the page will hang and not load.
if you get the following error: error 429|ActiveX component can't create object
it could be a problem with anti-virus software, try disabling script-blocking if you have anti-virus software installed.
Most of all
Please remember that the MOD Setup was created by Huw Reddick (HuwR) as a courtesy to those installing MODS. It may or may not work for you. If it doesn't, there are other ways to update the database.
Topic Locked
Posted - 11 April 2002 : 16:09:58
