Skip to main content
September 26, 2006
Question

Media Server + SQL

  • September 26, 2006
  • 2 replies
  • 569 views
Hi,

Just wondering, if any one know how to integrate flash media pieces with SQL with the help of Flash Media Server. Please give any examples or references you know.

Thanks in advance.
    This topic has been closed for replies.

    2 replies

    Participant
    September 28, 2006
    Using Actionscript you can load variables from any ASP page. Basically the ASP page can retrieve the data you want from SQL Server and outputs the data in a specific format that allows the LoadVariables function in ActionScript to read the output of the ASP page into ActionScript Variables.

    I hope that made sense, I will look for a sample for you.
    October 2, 2006
    Thanks for your reply jrm,

    So if I like to show that media piece to more then one end user, and I like to use Flash media server. Do you have any example for that. and which steps should I use to create data driven media piece which should be shareable to more then one person.

    Looking forward to some samples.

    Thanks

    September 27, 2006
    Hi,

    If you are reffering to connecting the Media Server to a MS SQL Server, you can allways enable the XML interfaceon the MSSQL and let the FMS control it through it's capability to send and load XML. Be aware though of the FMS' extremely crappy garbage collection. Be sure to erase all xml data after using it and call application.gc() regularely or the server will crash due to memory overflow.

    If you are running another db or don't want to use the XML interface, I suggest you expose the data you want to access through web services and call them from your FMS.

    Example and reference: we build a project with an FMS communicating with an application server through XML.load.