DDavolt
Jun 5th, 2001, 11:30 AM
I am using objects sqldmo.sqlserver and sqldmo.job and scripting.filesystemobject in a standard.exe.
SQLDMO is used to connect to server, start job, and check status of job. FSO is used to check directory on server.
Made .exe and works on NT4.0sp6a workstation(has vb and sqlsrv intalled)
Made Dependancy File Pkg and then Standard Setup Pkg. Installed on W98(not 2nd Ed.) that also had vb and sqlsrv installed and it works fine.
Installed on W98(not 2nd Ed.) that has Off2000 installed. Install completed successfully, however, get the following 3 errors when program opens....
1- Err #429 = Active X component can't create object
2- Err #429 = Active x component can't create object
3- Runtime error '91' Object variable or With block variable not set.
Did some research on error 429 above on MSDN and this site. Most of it talks about installing Server part and Client part on applicable machine. It also discusses checking DCOM setting. Someone on this site had a link to an .exe on MSDN that checks the DCOM ver on w98. The DCOM ver on the 2 w98 machines I tried to run the app on was 4.71.0.3328 and 4.71.0.1719.
I didn't think that sqldmo required setting anything up on the server, and that all applicable references would be in the setup package.
The only references I used where MS SQLDMO object library (sqldmo.rll), MS scripting runtime (scrrun.dll), VB objects and procedures (vb6.olb), vb runtime obj/proc (msvbvm60.dll\3) and vb for app (msvbfm60.dll).
Am I missing installing something on the clients? That's my guess, because the other w98 machine that had vb and sqlsvr installed ran and connected fine.
Below is a list of entries from the setup.lst file...
Any help would be greatly appreciated.
Thanks,
Dave Davolt
ddavolt@nucorar.com
nucordavolt@hotmail.com
[Bootstrap]
SetupTitle=Install
SetupText=Copying Files, please stand by.
CabFile=UpdateChemistries98.CAB
Spawn=Setup1.exe
Uninstal=st6unst.exe
TmpDir=msftqws.pdw
Cabs=1
[Bootstrap Files]
File1=@VB6STKIT.DLL,$(WinSysPathSysFile),,,3/26/99 12:00:00 AM,101888,6.0.84.50
File2=@COMCAT.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,5/31/98 12:00:00 AM,22288,4.71.1460.1
File3=@STDOLE2.TLB,$(WinSysPathSysFile),$(TLBRegister),,6/3/99 12:00:00 AM,17920,2.40.4275.1
File4=@ASYCFILT.DLL,$(WinSysPathSysFile),,,3/8/99 12:00:00 AM,147728,2.40.4275.1
File5=@OLEPRO32.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,3/8/99 12:00:00 AM,164112,5.0.4275.1
File6=@OLEAUT32.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,4/12/00 12:00:00 AM,598288,2.40.4275.1
File7=@MSVBVM60.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,8/21/00 12:00:00 AM,1388544,6.0.89.64
[IconGroups]
Group0=UpdateChemistries W98
PrivateGroup0=-1
Parent0=$(Programs)
[UpdateChemistries W98]
Icon1="UpdateChemistries98.exe"
Title1=UpdateChemistries W98
StartIn1=$(AppPath)
[Setup]
Title=UpdateChemistries W98
DefaultDir=$(ProgramFiles)\prjUpdateChemistries
AppExe=UpdateChemistries98.exe
AppToUninstall=UpdateChemistries98.exe
[Setup1 Files]
File1=@sqldmo.rll,$(AppPath),,,4/12/99 3:24:28 AM,507904,1999.4.12.0
File2=@MSVCRT.DLL,$(WinSysPathSysFile),,,7/15/00 12:00:00 AM,278581,6.0.8797.0
File3=@scrrun.dll,$(WinSysPath),$(DLLSelfRegister),$(Shared),10/17/00 11:57:46 AM,147512,5.1.0.5010
File4=@UpdateChemistries98.exe,$(AppPath),,,6/1/01 2:47:32 PM,40960,1.0.0.9
SQLDMO is used to connect to server, start job, and check status of job. FSO is used to check directory on server.
Made .exe and works on NT4.0sp6a workstation(has vb and sqlsrv intalled)
Made Dependancy File Pkg and then Standard Setup Pkg. Installed on W98(not 2nd Ed.) that also had vb and sqlsrv installed and it works fine.
Installed on W98(not 2nd Ed.) that has Off2000 installed. Install completed successfully, however, get the following 3 errors when program opens....
1- Err #429 = Active X component can't create object
2- Err #429 = Active x component can't create object
3- Runtime error '91' Object variable or With block variable not set.
Did some research on error 429 above on MSDN and this site. Most of it talks about installing Server part and Client part on applicable machine. It also discusses checking DCOM setting. Someone on this site had a link to an .exe on MSDN that checks the DCOM ver on w98. The DCOM ver on the 2 w98 machines I tried to run the app on was 4.71.0.3328 and 4.71.0.1719.
I didn't think that sqldmo required setting anything up on the server, and that all applicable references would be in the setup package.
The only references I used where MS SQLDMO object library (sqldmo.rll), MS scripting runtime (scrrun.dll), VB objects and procedures (vb6.olb), vb runtime obj/proc (msvbvm60.dll\3) and vb for app (msvbfm60.dll).
Am I missing installing something on the clients? That's my guess, because the other w98 machine that had vb and sqlsvr installed ran and connected fine.
Below is a list of entries from the setup.lst file...
Any help would be greatly appreciated.
Thanks,
Dave Davolt
ddavolt@nucorar.com
nucordavolt@hotmail.com
[Bootstrap]
SetupTitle=Install
SetupText=Copying Files, please stand by.
CabFile=UpdateChemistries98.CAB
Spawn=Setup1.exe
Uninstal=st6unst.exe
TmpDir=msftqws.pdw
Cabs=1
[Bootstrap Files]
File1=@VB6STKIT.DLL,$(WinSysPathSysFile),,,3/26/99 12:00:00 AM,101888,6.0.84.50
File2=@COMCAT.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,5/31/98 12:00:00 AM,22288,4.71.1460.1
File3=@STDOLE2.TLB,$(WinSysPathSysFile),$(TLBRegister),,6/3/99 12:00:00 AM,17920,2.40.4275.1
File4=@ASYCFILT.DLL,$(WinSysPathSysFile),,,3/8/99 12:00:00 AM,147728,2.40.4275.1
File5=@OLEPRO32.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,3/8/99 12:00:00 AM,164112,5.0.4275.1
File6=@OLEAUT32.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,4/12/00 12:00:00 AM,598288,2.40.4275.1
File7=@MSVBVM60.DLL,$(WinSysPathSysFile),$(DLLSelfRegister),,8/21/00 12:00:00 AM,1388544,6.0.89.64
[IconGroups]
Group0=UpdateChemistries W98
PrivateGroup0=-1
Parent0=$(Programs)
[UpdateChemistries W98]
Icon1="UpdateChemistries98.exe"
Title1=UpdateChemistries W98
StartIn1=$(AppPath)
[Setup]
Title=UpdateChemistries W98
DefaultDir=$(ProgramFiles)\prjUpdateChemistries
AppExe=UpdateChemistries98.exe
AppToUninstall=UpdateChemistries98.exe
[Setup1 Files]
File1=@sqldmo.rll,$(AppPath),,,4/12/99 3:24:28 AM,507904,1999.4.12.0
File2=@MSVCRT.DLL,$(WinSysPathSysFile),,,7/15/00 12:00:00 AM,278581,6.0.8797.0
File3=@scrrun.dll,$(WinSysPath),$(DLLSelfRegister),$(Shared),10/17/00 11:57:46 AM,147512,5.1.0.5010
File4=@UpdateChemistries98.exe,$(AppPath),,,6/1/01 2:47:32 PM,40960,1.0.0.9