根据服务端的版本下载安装对应的版本,查询代码如下:
$AuthString = "User Id=$USER;Password=$PASSWD;Data Source=$SERVER/$DB"$QuerySQl = "Select runstatus,hisstatus from collectreport where oc_date="$OracleConncetion = New-Object System.Data.OracleClient.OracleConnection$ResultTable= New-Object System.Data.DataTable$OracleConncetion.ConnectionString = $AuthString$ConnCmd = $OracleConncetion.CreateCommand()$ConnCmd.CommandText = $QuerySQl$OracleAdapter = New-Object System.Data.OracleClient.OrcalDaTaAdapter($ConnCmd)$tmp.fill($ResultTable)