当我尝试从Windows Server 2008 R2中的PowerShell连接数据库时。我遇到错误:
无法加载文件或程序集ODP.NET或其依赖项之一。该程序集是由比当前加载的运行时新的运行时构建的,无法加载。
命令:
Add-Type -Path "D:\SelfAnalysisKit\odp.net\ODP.NET_Managed_ODAC122cR1\odp.net\managed\common\Oracle.ManagedDataaccess.dll"
$DBName = $db_name
$DBusername = $user_id
$DBPassword = $password
$DBTable = "$name"
$hostname=$db_name
$SID=$sid
$search=$jobid
$data_source = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=$hostname)(PORT=1521))(CONNECT_DATA = (SERVER=dedicated)(SERVICE_NAME=$SID)))"
# -----------------Connect to Oracle------------------------
$connectionString = 'User Id=' + $DBusername + ';Password=' + $DBPassword + ';Data Source=' + $data_source
$connection = New-Object Oracle.ManagedDataaccess.Client.OracleConnection($connectionString)