| Section | |||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Create System DSN Connection
- Once the MySQL ODBC connection driver is installed on a local system, you need to set up a System DSN connection through Microsoft Windows on that same local system.
- From the Windows Start Menu, select Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
Once installed, need to set up a System DSN (data source name) connection through Microsoft Windows.
Windows Start Menu > Control Panel > System & Security > Administration Tools > Data Sources (ODBC)
- On the System
...
- DNS tab, click Add.
- When prompted to select a driver, select the MySQL ODBC Driver option and click Finish.
- Specify MySQL connection parameters as described in the following table
...
...
In the Data Source Name box, enter the name of the data source to access. It can be any valid name that you choose.
...
In the Description box, enter some text to help identify the connection.
...
- . If you need any help with these values, contact Bannister Lake Support for assistance.
- Click Test to test your connection to your TweetOut database.
- Click OK to save your changes.
| Parameter | Details |
|---|---|
| Data Source Name | Enter a name for this data source. You will need to know this name when you establish a connection to TweetOut content using ODBC. |
| Description | Describe this data source connection. |
| TCP/IP Server | Enter the name of the MySQL server host |
...
| which is the server name of your cloud instance database. | |
| User | Enter the user name |
...
| for |
...
| the connection to your cloud instance database. |
...
| Password | Enter the password for |
...
| the connection to your cloud instance database. |
...
| Database |
...
To communicate over a different TCP/IP port than the default (3306), change the value of the Port.
...
Click to save the DSN.
...
| Select your cloud instance database. |