newhk
BANNED | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Недопустимое имя столбца "s10002".
строка:31 знак:5
+ $connection.Execute("insert into Region_Backups (Server) Values ( ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: ( [], COMException
+ FullyQualifiedErrorId : System.Runtime.InteropServices.COMException
Неправильный синтаксис около конструкции ".2022".
строка:32 знак:5
+ $connection.Execute($SQL_DB_Time)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: ( [], COMException
+ FullyQualifiedErrorId : System.Runtime.InteropServices.COMException
Недопустимое имя столбца "OK".
строка:33 знак:5
+ $connection.Execute($SQL_DB_Check)
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : OperationStopped: ( [], COMException
+ FullyQualifiedErrorId : System.Runtime.InteropServices.COMException
...
скрипт, которым пытаюсь добавить данные в таблицу
Код:
function insData ($ID, $server, $DB_Time, $DB_Check, $Data_Time, $Data_Check, $PST_Time, $PST_Check, $System_Time, $System_Check){
$SQL_ID = "insert into Region_Backups (ID) Values ($ID)"
$SQL_Server = "insert into Region_Backups (Server) Values ($Server)"
$SQL_DB_Time = "insert into Region_Backups (DB_Time) Values ($DB_Time)"
$SQL_DB_Check = "insert into Region_Backups (DB_Check) Values ($DB_Check)"
$SQL_Data_Time = "insert into Region_Backups (Data_Time) Values ($Data_Time)"
$SQL_Data_Check = "insert into Region_Backups (Data_Check) Values ($Data_Check)"
$SQL_PST_Time = "insert into Region_Backups (PST_Time) Values ($PST_Time)"
$SQL_PST_Check = "insert into Region_Backups (PST_Check) Values ($PST_Check)"
$SQL_System_Time = "insert into Region_Backups (System_Time) Values ($System_Time)"
$SQL_System_Check = "insert into Region_Backups (System_Check) Values ($System_Check)"
$dataSource = "172.17.0.16"
$database = "Regions_Report_Backup"
$login = 'sa'
$pass = "12345678"
$connection = New-Object -com "ADODB.Connection"
$ConnectionString = "Provider=SQLOLEDB.1;
Data Source=$dataSource;
Initial Catalog=$database;
User ID=$login;
Password=$pass;"
$connection.Open($ConnectionString)
$connection.Execute("insert into Region_Backups (ID) Values ($ID)")
$connection.Execute("insert into Region_Backups (Server) Values ($Server)")
$connection.Execute($SQL_DB_Time)
$connection.Execute($SQL_DB_Check)
$connection.Execute($SQL_Data_Time)
$connection.Execute($SQL_Data_Check)
$connection.Execute($SQL_PST_Time)
$connection.Execute($SQL_PST_Check)
$connection.Execute($SQL_System_Time)
$connection.Execute($SQL_System_Check)
$connection.Close()
}
$id = 1
$srv = 's10002'
$db_t = '03.09.2022 14:43:42'
$db_c = 'OK'
$data_t = '03.09.2022 16:48:22'
$data_c = 'OK'
$pst_t = $null
$pst_c = 'fail'
$system_t = '03.09.2022 18:13:32'
$system_c = 'OK'
insData -ID $id -server $srv -DB_Time $db_t -DB_Check $db_c -Data_Time $data_t -Data_Check $data_c -PST_Time $pst_t -PST_Check $pst_c -System_Time $system_t -System_Check $system_c
|
|
