March 27, 2017 at 8:54 am
Hi Team,
I am trying to retrieve sql data using powershell code - invoke-sqlcmd. Invoke-sqlcmd is failing with not recongnized error , as there are no client components installed on the machine where powershell code is running.
Please suggest alternative to invoke-sqlcmd which can retrieve data to powershell arrays.
Thanks.
March 27, 2017 at 9:57 am
Remote call to PowerShell hosted on a box with the necessary components installed.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
March 28, 2017 at 11:47 am
Install the necessary components - they are provided as separate downloads. If you don't want to do that - then you need to implement the same ADO.NET code that you would use for a C# or VB.Net application.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
March 29, 2017 at 3:58 am
Thanks for the comments.
with .net connections can we achieve everything as like with invoke-sqlcmd ? I want to import the SQL Data into an array and insert the same back into SQL table after new database restore activity.
Thanks.
March 29, 2017 at 5:51 am
chinna.sp3025 - Wednesday, March 29, 2017 3:58 AM...with .net connections can we achieve everything as like with invoke-sqlcmd ?...
Yes. Pretty much. Not sure that is the ideal way though. It depends what you are trying to do under what circumstances.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy