Powershell connect to database

Connecting to database

Run 32-bit powershell ISE, setup paths, users, ..etc, run.

#Set-ExecutionPolicy RemoteSigned

$DSN = "FIELDPRO_DEMO_SQL_V8"
$USER = "Administrator"
$PASS = ""
$dir = "C:\Program Files (x86)\FIELDPRO\V8e\System"
$fileAssembly = "$($dir)\FieldproWrappers.DLL"
$filePromain = "$($dir)\ProMainDLL.DLL"
$filemnUtils = "$($dir)\ManagedUtils.DLL"

Set-Location $dir

Add-Type -Path $fileAssembly
Add-Type -Path $filemnUtils

$parameters = @{
    TypeName = 'FieldproWrappers.CProMain'
    ArgumentList = ($dir, $filePromain)
}

$promain = New-Object @parameters
$bConnected = $promain.ConnectToDatabase("FLEXlm", "FIELDPRO_DEMO_SQL_V8", "sa", "prosuite", "", "");
write-host $bConnected

$valDSN = New-Object -TypeName FieldproWrappers.COleVariantExt
$valUserName = New-Object -TypeName FieldproWrappers.COleVariantExt
$valUserPass = New-Object -TypeName FieldproWrappers.COleVariantExt
$valDSN.SetAsString($DSN)
$valUserName.SetAsString($USER)
$valUserPass.SetAsString($PASS)

$parameters = @{
    TypeName = 'FieldproWrappers.CPROTicket' 
    ArgumentList = ($promain)
}

$proTicket = New-Object @parameters
$proTicket.InitTicket($valDSN, $valUserName, $valUserPass);
$lRes = [int]0
$promain.Login($proTicket, [ref]$lRes)
Write-Host $lRes