Versions Compared

Old Version 1

changes.mady.by.user Aryn Wiebe

Saved on

compared with

New Version 2

changes.mady.by.user Aryn Wiebe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSTEP 2: Use the 64 bit ODBC Administrator to create the ODBC data source

  1. On your Windows machine, search “ODBC” to find ODBC Data Sources (64 bit). Right Click and choose Run as Administrator to open the ODBC Data Source Administrator.

  1. Open the System DSN tab and click Add.

  1. Choose the latest MySQL Server ODBC driver and click Finish.

  1. Enter the ODBC credentials:

    • Use any Data Source Name and Description you prefer.

    • Enter the Network Name (or IP) of the MySQL Server in the TCP/IP Server field.

    • Enter the User name and Password:

    • Choose your default Database (optional)

Before creating the data source, click Test to test the connection with your database.

You should receive a Connection Successful test result. If unnsuccessful, speak to your DBA (database administrator) about how to login to the database (user authentication) and try the tips below.

...