Media Server + SQL

Forum|Forum|19 years ago
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.

J

jrm213

Participant

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.

A

Anonymous

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

A

Anonymous

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded