Breaking News: Grepper is joining You.com. Read the official announcement!

use odbc from powershell

Muddy Moose answered on February 22, 2022 Popularity 5/10 Helpfulness 6/10

answer use odbc from powershell

use odbc from powershell

Comment

$conn = new-object System.Data.Odbc.OdbcConnection
$conn.connectionstring = "DSN=DSNNAME" # Find "DSNNAME" (i.e. connection name) in ODBC Data Source Admin > User DSN
$sqlCommand="SELECT VERSION();"
$conn.open()

$cmd = New-object System.Data.Odbc.OdbcCommand($sqlCommand,$conn)
$dataset = New-Object System.Data.DataSet
(New-Object System.Data.Odbc.OdbcDataAdapter($cmd)).Fill($dataSet)
$conn.Close()

$dataSet
$dataSet.Tables

Popularity 5/10 Helpfulness 6/10 Language shell

Source: stackoverflow.com

Tags: odbc powershell shell

Link to this answer
Share Copy Link