Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 14:58:27 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Danae,

The error message that you were seeing "Requested Access Module not found" indicates that FastLoad cannot locate the OLEDB_AXSMOD.dll file. It searches the folders listed in the value of the PATH environment variable.

When you start the Microsoft Windows 2000 command interface from Windows (for examples, by clicking Start / Programs / Accessores / Command Prompt, or Start / Run / "cmd" / OK), Windows adds folders listed in the Path registry value located under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\AppPaths\cmd.exe key. The name of the folder containing the OLEDB_AXSMOD.dll file should be put there during installation.

Also, if you started FastLoad directly from Windows, then the folder containing the OLEDB_AXSMOD.dll file would be added to the PATH because of the Path registry values under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\AppPaths\fastload.exe key.

See www.codeguru.com/dll/AppPath.shtml or the "Application Registration" section of www.msdn.microsoft.com/library/en- us/shellcc/platform/shell/programmersguide/shell_basics/shell_basics_extending/fileassociations/fa_perceived_types . asp for more information on the "App Paths" mechanism.

When you create your own application (which is essentially what you're doing by creating a batch file, albeit an extremely simple application) and launch it directly from Windows or via some other mechanism other than from the Microsoft Windows 2000 command interface, you (a) assume the responsibility for setting the PATH properly for your application, and (b) bypass the above mechanisms for setting the PATH.

I hope that this explains why you are seeing the error only when you use a batch job vs. from the command prompt.

I hope this helps!

-shawn :-)

	<Prev	Next>		<<First	<Prev	Next>	Last>>