SimplySql
SimplySql copied to clipboard
mithrandyr
PowerShell module for querying various SQL databases
FIPS
When trying to connect to a Postgres DB I get the following error. "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms." The system I am...
I get the below error when I try to connect to a rds postgres server via aws rds proxy. It works directly, but the proxy errors on it. "Open" with...
Could not load type 'System.Security.Principal.WindowsImpersonationContext' from assembly 'mscorlib
Hi, PS version : 7.2x after - import the module - use Open_OracleConnection I receive this: An error has occurred that was not properly handled. Additional information is shown below....
$data = Invoke-SqlQuery -query "SELECT * FROM someTable WHERE someCol = @var" -Parameters @{var = '你好'} The above query statement cannot query the data
Hi Not an issue just some snippet of code I wanted to share. Sometime you get an error like `error at or near "."`. I have 100 "." in my...
Cannot Invoke-SQLBulkCopy from a PSObject instead of a source db.
Hi, regarding #1 - any thoughts about if powershell core and linux/macos will be supported?
**Summary** I'd like to report an issue encountered with SimplySql 1.8.0 and PowerShell Core 7.2.0 on Ubuntu that caused me quite a few hours of confusion until I found a...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html This supports bulk loading from a file. Consider Adding a Connection level attribute (use alternative-loading) and then in Invoke-SqlBulkCopy write out the information to disk, then process the file...
If there is an existing transaction (with the MSSQL provider) and invoke-sqlbulkcopy is used, an error is thrown because the bulkcopy class is not expecting this. Suggestion: modify the code...
Metadata
Owner
Metadata
PowerShell module for querying various SQL databases