![]() $Command.CommandText = "SELECT last_name, first_name FROM contact ORDER BY 1, 2" $Connection.ConnectionString = $ConnectionString # Define a MySQL Command Object for a non-query. $Connection.ConnectionString = $ConnectionString # Attempt connection. $ConnectionString = 'DSN=MySQLODBC' # Define a MySQL Command Object for a non-query. You should enter the following two lines in the hosts file: ![]() ![]() If you opt for localhost as the server value and you have a DCHP IP address, make sure you’ve configured your hosts file in the C:\Windows\System32\drivers\etc directory. The MySQL Unicode ODBC Driver Setup dialog should complete the prompts as follows below.The Create New Data Source dialog requires you select the MySQL ODBC Driver(UNICODE) option from the list and click the Finish button to proceed.Click the Add button to start the workflow. Click the SystemDSN tab to see he view which is exactly like the User DSN tab.You can click on the images on the right to launch them in a more readable format or simply read the instructions. There are four steps to setup, test, and save your ODBC Data Source Name (DSN) for MySQL. After you’ve installed the MySQL ODBC library, use Windows search field to find the ODBC Data Sources dialog and run it as administrator. This post explains and demonstrates how to install, configure, and use the MySQL’s ODBC libraries and a DSN (Data Source Name) to connect your Microsoft PowerShell programs to a locally or remotely installed MySQL database.
0 Comments
Leave a Reply. |