I'm new to powershell script and windows server and trying to add MySQL ODBC unicocde 5.2 driver 32 bit configuration in Windows Server 2019. I can able to add data source name in MySQL connector.
$rds="rds.xxxxxxxxx.ap-south-1.rds.amazonaws.com"
Add-OdbcDsn -Name "DemoModel" -DriverName "MySQL ODBC 5.2 Unicode Driver" -DsnType "System"
-Platform '32-bit' -SetPropertyValue @("Server=rds", "Trusted_Connection=Yes",
"Database=demo-v4")
When I run above powershell script, it add Data Source name in MySQL Connector and it doesn't added rds enpoint.
However I failed to add AWS RDS end-point and its credentials with database name. I need to select parameters such as Allow big result sets, Enable automatic reconnect and Allow mutliple statements in Connections section and Return matched rows instead of affected rows in Cursors/Results section.
How to configure data base credentials in ODBC MySQL connector in Windows Server 2019 using powershell script? Can any one please help me to achieve?