Question

我的系统有这一数据链接,Interop.MSDASC.dll。我正试图从像这样的大国身上装上同样的东西——

[Reflection.Assembly]::LoadFile("C:Interop.MSDASC.dll") | out-null

但我有以下错误:

Exception calling "LoadFile" with "1" argument(s): "Could not load file or assembly  Interop.MSDASC.dll  or one of its dependencies.  is not a 
valid Win32 application. (Exception from HRESULT: 0x800700C1)"
At line:1 char:32
+ [Reflection.Assembly]::LoadFile <<<< ("C:Interop.MSDASC.dll") | out-null
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

我如何正确装载这件事?

Answer 1

This is a 32 bit COM object and therefore you must load it from a 32 bit instance of PowerShell. To do this on a 64 bit version of Windows you can execute powershell.exe or powershell_ISE.exe in this folder: %SYSTEMROOT%SysWow64windowspowershellv1.0

这是一部完整的法典:

[Reflection.Assembly]::LoadFile("C:Interop.MSDASC.dll") 
$dataLinkInstance = new-object MSDASC.DataLinksClass
$dataLinkInstance.WriteStringToStorage("C:\FrmPowershell.udl", "Provider=SQLOLEDB.1;", 2)

Answer 2

http://datadictionary.codeplex.com/“rel=“nofollow”http://datadictionary.codeplex.com/。以同样方式使用和装货组,没有问题:

 [System.Reflection.Assembly]::LoadFile( "c:Program FilesDataDictionaryCreatorInterop.MSDASC.dll")

GAC    Version        Location
---    -------        --------
False  v2.0.50727     c:Program FilesDataDictionaryCreatorInterop.MSDASC.dll

Are you maybe on a x64 operative system? if yes read here http://datadictionary.codeplex.com/workitem/28807

Answer 3

$comInterOp = "CTempInterop.YourAssembly.dll"
[System.Reflection.Assembly]::LoadFile($comInterOp)
$yourClassObj = new-object YourAssembly.YourClassNameClass
$yourResult = $yourClassObj.YourMethod()

友情链接