About this tag
Discussions tagged with sqlclient on WindowsForum.com cover issues related to the SQL Client library used in PowerShell and Windows HPC environments. Topics include datetime conversion failures when using Invoke-Sqlcmd in PowerShell scripts, where CAST and CONVERT functions work in SSMS but fail via SqlClient. Another thread addresses a SqlClient exception in Windows HPC on Server 2019 after an update, specifically a datediff overflow error. These posts highlight troubleshooting scenarios involving SqlClient in Windows-based systems, focusing on error resolution and compatibility.
-
J
Windows 10 Convert DateTime is failing with following in Power Shell using SQLSERVER
It tried to convert following time in Power Shell Script '2022-01-02T11:43:23.100Z' using Convert Function, and Cast. The tried same in SSMS and passed. Both SSMS and Power shell were connect to same instance of SQL Server 14.0.1000. Error message indicates in Power shell it is failing in...- jdweng
- Thread
- powershell sql server sqlclient
- Replies: 1
- Forum: Windows Help and Support
-
H
Windows HPC fails to start after update (Server 2019)
Hi all, When looking at the logs after the HPC console add-in fails to start I get the following (HPC scheduler): Exception: System.Data.SqlClient.SqlException (0x80131904): The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large...- hob63
- Thread
- availability connection datediff error exception hpc logs monitoring server 2019 sqlclient stack trace task scheduler update windows
- Replies: 1
- Forum: Windows Server Forums