PDA

View Full Version : LiveText 2 - MS SQL



alexw1983
01-19-2011, 07: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.


<sql_databases>
<!-- <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;"
<query>
command = "SELECT VideoType FROM VideoTypes;"
key = "Videotypes"
timeout = "10000"
multiple_keys = "true"
</query>

</database>
</sql_databases>

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!

Thanks,
Alex.

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

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