Versions Compared

Key

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

Create & Test System DSN Connection

Section

In this section:

Column
width70%

Users can access TweetOut content from a Flow database using an ODBC connection and TweetOut Views. Setting up an ODBC connection consists of three steps:

  1. Install a MySQL ODBC Connector Driver on a local system.
  2. Create and test a System DSN Connection to your TweetOut instance.
  3. Use the System DSN Connection to connect to TweetOut content Views provided by Bannister Lake Support upon request.
Note

A Bannister Lake Support Database Administrator will need to assist you in setting up TweetOut content Views for your TweetOut instance. Contact Bannister Lake Support for assistance.

Install MySQL ODBC Connector Driver

Anchor
InstallMySQLODBCDriver
InstallMySQLODBCDriver
You need to install a MySQL ODBC connector driver on a local system in order to connect to your TweetOut content Views using an ODBC connection. The MySQL ODBC driver comes in both a 64-bit and 32-bit OS version, so be sure to install the correct driver for your local Microsoft® Windows® operating system.

Download the correct driver from Bannister Lake as follows:

Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1
Table of Contents
indent15px

Include Page
DAS:Promos TopDAS:Promos Top
Anchor
CreateSystemDSN
CreateSystemDSN
Once the

...

correct MySQL ODBC connector driver is installed on a local system, you need to set up

...

System DSN

...

 connection through Microsoft Windows on that same local system.

  1. From

...

  1. the Windows Start Menu, select

...

  1.  Control Panel > System & Security > Administration Tools > Data Sources (ODBC).
  2. On

...

  1. the System DNS

...

  1.  tab,

...

  1. click Add.
     Image Modified
     
  2. When prompted to select a driver, select

...

  1. the MySQL ODBC Driver

...

  1.  option and

...

  1. click Finish. If you don't see the MySQL ODBC Driver option, you need to cancel out of creating a new data source

...

  1. and install the MySQL ODBC Connector Driver

...

  1.  first.
    Image Modified
  2. Specify MySQL Connection/ODBC parameters as described in the following table. If you need any help with these values, contact Bannister Lake Support

...

  1.  for assistance.

    ParameterDetails
    Data Source NameEnter a name for this data source. You will need to know this name when you establish a connection to TweetOut content Views using ODBC.
    DescriptionDescribe this data source connection.
    TCP/IP ServerEnter the name of the MySQL server host which is the server name of your TweetOut Flow data server.
    UserEnter the user name for the connection to your TweetOut database.
    PasswordEnter the password for the connection to your TweetOut database.
    DatabaseSelect your TweetOut database.

    Image Modified

...

  1. Click Test

...

  1.  to test your connection to your TweetOut database.

...

  1. Click OK

...

  1.  to save your changes.
Column
width30%
Panel
borderColor#0070b1
bgColor#FFFFFF
borderWidth1

In this section:

Table of Contents
indent15px

Include Page
DAS:Promos Top
DAS:Promos Top

 

Include Page
DAS:Promos Bottom
DAS:Promos Bottom