View Full Version : LiveText 2 - MS SQL

01-19-2011, 08:14 AM
Hi All,

New to the world of Tricaster but have to say love it already!

Hopefully someone might be able to help, I've searched your forums and read the manual but haven't found the answer so far.

I'm trying to connect LiveText 2 to our MS SQL server using the xml file below.

<!-- <database connection_string = "Driver={SQL Server};Server=decimus;Database=MediaManagement; Uid=XXXX;Pwd=XXXX;"> -->
<database connection_string="Provider=SQLNCLI10;Server=decimus;Database=mediama nagement;Uid=XXXX; Pwd=XXXX;"
command = "SELECT VideoType FROM VideoTypes;"
key = "Videotypes"
timeout = "10000"
multiple_keys = "true"


I've tried a number of different connection strings which I've tested with QueryExpress which was recommended on a previous post.

In LiveText I've used the %Videotypes.1% etc. but nothing is being pulled from the database..

Any pointers would be great!


06-06-2011, 04:11 AM
Works perfect with version 2.1 thanks guys!!

06-06-2011, 06:21 AM
Good to hear, thanks for the update.