Test ODBC with powershell

[RamPc]

Hello,

Does anyone knows the proper way to test Advantage ODBC from windows powershell???

I tried below:

$connection = New-Object System.Data.Odbc.OdbcConnection("DSN=TestConnection") $connection.Open()

But Im getting this error:

Exception calling "Open" with "0" argument(s): "ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and
Application"
At line:2 char:1
+ $connection.Open()
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : OdbcException

Any advice will be great.

Thanks!