After watching/reading at least a dozen videos and articles about using PS to connect to a DB, this one finally made it stick. A really good, simple, thorough walkthrough of the process.
I received the error message: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." upon executing the statement: $conn.connectionstring = .... SWould appreciate any tips, advice or pointers to make it work. I have Office 2007 (Access 2007) installed and working fine on my PC.
Apologies for missing this one! Both provider 32/64 versions may need to be installed to clear the issue. Check the following blog post for more information: datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/
After watching/reading at least a dozen videos and articles about using PS to connect to a DB, this one finally made it stick. A really good, simple, thorough walkthrough of the process.
The Lab Guide for this video is available here: sapien.s3.amazonaws.com/video/Advanced_Lab_Guide.pdf
I received the error message:
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered
on the local machine."
upon executing the statement:
$conn.connectionstring = ....
SWould appreciate any tips, advice or pointers to make it work.
I have Office 2007 (Access 2007) installed and working fine on my PC.
Apologies for missing this one! Both provider 32/64 versions may need to be installed to clear the issue. Check the following blog post for more information: datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/
[reflection.assembly]::LoadWithPartialname("MySQL.Data") not work
use
Add-Type -Path 'Folder\MySQL.Data.dll'
.