Directly Executing an MS SQL SP from Flash

[tantrum]

Hello everybody,

I am a .NET developer and I have to develop some flash components in my .NET application. I have looked at Flash and it is pretty fantastic. I was wondering if you guys can help on my problem. What I would like to do is pretty simple. I have a SQL Server stored procedure (SP) that return a select statement. I would like to execute this SP and get the result in Flash as a dataset. In other words, I do not want to use a middle tier like ASP, ASPX or PHP. I want to get data directly into my SWF from SQL. Is it possible?

Thanks much

Serkan

[madgett]

This isn't possible with just Flash and any database, that's out of the scope of the Flash Player. You can tell flash to call a dynamic script and get the data from the script (asp,php,cf,jsp...etc). This most likely has to do with security reasons, and is probably why they are not building that much capability into Flash.