PDA

View Full Version : LiveText and Database



CTV
03-23-2016, 07:51 PM
Hi All,

I'm trying to get LiveText to read from a mySQL database running on MacOS X server.

I can setup and test the connection successfully in the Windows 7 Pro "ODBC Data Source Administrator" control panel, and can connect using the MySql Workbench Application (Which doesn't use ODBC), however I cannot get LiveText 3.0 to connect.

Following is the text of my xml file. "/Program Files (x86)/NewTek/LiveText/Stats Plugins/Database Input/ctv2.xml"


<sql_databases>
<database connection_string = "Driver={MySQL ODBC 3.51 Driver};Server=192.168.1.20;user=ctv;password=#### ;database=data">
<query command = "SELECT player FROM livetext_test;" key = "player" timeout = "10000" multiple_keys = "true" />
</database>
</sql_databases>

When I create a text field in LiveText with %player% nothing happens, and it dosn't show up with a right click, while the Text
Link data does.

Ideally I would like the TriCaster to do this, but currently I'm just trying to get LiveText on a client Windows 7Pro computer to work.

Any ideas as to what I might be missing?

Thanks,
Stephen