OK, that explains why I've never used the netConnection. I don't use the communication server. I do, however use Flash movies and games that utilize dynamic database driven content. For an example you can visit a dev. stage site that I have written a poker game for. The game logs you in based on the submitted user/password information. It pulls your saved score into the movie and updates your score in the database with each hand lost or won. While not exactly what you are looking for, it does offer a way to acheive your desired results, I think.
ispfriends.com is the domain if you would like to see the movie in action.
The way I communicate with the database is through a series of asp pages. These are script pages that are not displayed in the visitors browser. They are called from within the Flash movie by using the loadVariables function.
It can get tricky though, if your data needs to be pulled into a nested clip.
IE, if you have a routine running that is an instance named ' username' the call would look like
loadVariables("http://script.asp", _root.username, "POST");
I have had movies get even more particular, and I don't know the reason, but they require that same code to be written...
loadVariables("http://script.asp", _level0.username, "POST");
Below is the actual code from the game that makes an update to the database...
score = ( Number(score) + Addscore() );
points = score;
loadVariables("script.asp", _root.pokerX, "POST");
if(score == 0){
score = 100;
winner = "100 points added"
and this is the script.asp page that the movie is calling... (I am using a flatfile for point scoring, but DB connections work equally well)
<%@LANGUAGE="VBSCRIPT"%>
<%
WriteText=(Request.Form("points"))
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Dim fso, f, Msg
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.OpenTextFile("F:\*******\cgi-bin\gameUsers\"&(Session("thisUsername"))&".txt", ForWriting, True)
f.Write WriteText
%>
<%="points="&WriteText %>
The Flash movie passes the new score as a form value "points" then writes the points value to the page, the movie then picks up the points value string that '<%="points="&WriteText %>' writes and the movie updates the players points in the game.
Oh, and it is my old friend tellTarget, not loadVariables that is being depreciated. So no worries about having to recode the whole thing for the next version out.
I hope this is helpful. - Rich
Developing interactive Flash and ASP pages for 'Real World' application.
Referring URLs
www.ispfriends.com/games.asp