Debugging steps for Citrix XenApp running PowerShell Scripts

Ensure you are invoking appropriate version of PowerShell to run your PS script Use C:Windowssyswow64Windowspowershellv1.0powershell.exe for 32-bit Use C:Windowssystem32Windowspowershellv1.0powershell.exe for 64-bit When you are invoking 32-bit/64-bit script for the first time on the system, ensure that appropriate ExecutionPolicy is set for the environment. If ExecutionPolicy is set to restricted PS shell just exits after launch. In case if your script making any ADO connections, ensure that proper driver names are used for example: You’ll see “Driver={Microsoft Access Driver (*.mdb, *.accdb)}” on systems running Access application whereas on systems that don’t have Access installed the driver will be named as “Driver={Microsoft […]

Read more

Microsoft.Jet.OLEDB.4.0 Provider Is No Longer a Supported Data Access Method

I’ve read through a great bunch of articles where users reported issues with accessing Access DB files using the Microsoft.Jet.OLEDB.4.0 provider.  This is predominantly reported on latest Windows platforms essentially x64 versions those most probably running the latest version of Access 2007 or beyond.   As on Access 2007, Microsoft confirmed that Microsoft.Jet.OLEDB.4.0 is a Deprecated Data Access Method.  For more details refer to MSFT article Deprecated Data Access Methods.

Read more