需要使用PowerShell连接到DB2数据库

qybjjes1 于 2022-11-07 发布在 DB2

关注(0)|答案(1)|浏览(247)

我无法获取我的查询的输出，我正尝试通过PowerShell运行该查询。

$connection = New-Object System.Data.OleDb.OleDbConnection("Provider=IBMDADB2;DSN=;User Id=;Password=");
$ds = New-Object "System.Data.DataSet"
$QuerySQL = "select * from omaa.status"
$da = New-Object System.Data.OleDb.OleDbDataAdapter($QuerySQL, $connection)
$da.Fill($ds)

我收到这个例外状况

Exception calling "Fill" with "1" argument(s): "Unspecified error"
At line:6 char:9
+ $da.Fill <<<< ($ds)
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : DotNetMethodException

db2

来源：https://stackoverflow.com/questions/56418244/need-to-connect-to-db2-database-with-powershell

1条答案

按热度按时间

n3ipq98p1#

我知道这是一个老化的线程，但也许这会帮助一些人。我正在使用这个，它适用于Oracle和DB2连接。（虽然不适用于DB2加速）。导出CSV，但可以修改它以在以后转换为xlsx。

function Get-OLEDBData ($connectstring, $sql) {            
   $OLEDBConn = New-Object System.Data.OleDb.OleDbConnection($connectstring)            
   $OLEDBConn.open()            
   $readcmd = New-Object system.Data.OleDb.OleDbCommand($sql,$OLEDBConn)            
   $readcmd.CommandTimeout = '300'            
   $da = New-Object system.Data.OleDb.OleDbDataAdapter($readcmd)            
   $dt = New-Object system.Data.datatable            
   [void]$da.fill($dt)            
   $OLEDBConn.close()            
   return $dt            
}

# For Oracle

$connString = "password=yourPassword;User ID=YourID;Data Source=YourServer;Provider=OraOLEDB.Oracle"            

# For DB2

$connString = "Provider=DB2OLEDB.1;Network Transport Library=TCPIP;Network Address=YourIPHere;Network Port=YourPortHere;Initial Catalog=YourDatabaseHere;Package Collection=NULLID;Default Schema=SameAsYourDatabaseHere;User ID=YourID;Password=YourPassword;"            

$qry= "select something from somewhere"

Get-OLEDBData $connString $qry | Export-Csv -Path C:\TargetFolder\Results.csv -Delimiter ";" -NoTypeInformation

赞(0）回复(0）举报 2022-11-07

我来回答

需要使用PowerShell连接到DB2数据库

1条答案

相关问题

热门标签

最新问答