Flash :: Connecting Flash To SQL

Connecting Flash To Asp
Hi,
I'm trying to connect a flash frontend to a database using and .asp page but I'm running into a strange problem that I've never had before when trying to these kinds of things. The problem is that the .asp page never seems to be called by the flash. This is my AS code

Code:
class Saljare extends MovieClip{
private var intervalId:Number;
private var lvOut:LoadVars;
private var lvIn:LoadVars;

//Konstruktorn
function Saljare(){
intervalId = setInterval(this,"skickaSvar",500);

}

function skickaSvar(){
hamtaSvarFranGUI();
lvOut.send("sendData.asp", "_blank", "POST");

}
}

My asp page looks like this:

Code:
<%@Language="VBScript"%>
<%

Response.Write("&var0=1")
%>

When I try to just run the script it works fine so I'm guessing there is something wrong with AS code but for the life of me I can't find it.

Hope somebody has an answer!

Sincerely,
Anders

Connecting Flash And JSP
I am new to the action script, i have a form which read a e-mail address and pass to a jsp page,from there it will store to a db and check ,if if it exits in the db, if so it pass aflag value back to flash.
i Used sendAndLoad(), but the problem is, it is not working in IE, but well in firefox...
Now i thought to change the code , and implement flash remoting

board_mc.btn_submit.onRelease = function() {
reset_button();
this.enabled = true;
this.gotoAndStop(_down);
my_lv = new LoadVars();
recv_var = new LoadVars();
my_lv.email = board_mc.email_txt.text;
my_lv.sendAndLoad("

Connecting To Sql Using Flash
Connecting to sql threw flash?

What is with this i have looked about and seams if i where to rebuild my 404 page in flash i would have to pass all info out to an xml file and then pass it back in to flash.

Really the only thing i want to do now is be able to add to the database and also make the question marks float about.

How possible is this?

http://namit.org/404_page/index.php

Connecting Flash With Access
Is it possible to connect flash with access?
If so can any one post a sample file on how to connect flash with access.

for eg. storing user name and password in access and checking it if he is a new user.

Thanks for your replies.

Connecting Flash To Html
I am trying to create a website in GoLive that has an opening splash page that is created in flash. I made the page in flash, made an idex page for my site and brought in the SWF file, but I can not get the button that is within the SWF to link to the next html page. Can anyone give me the script that I should be using on the button to make it link? The one that I am using right now is

on (release) {
getURL ("begin.html");
}

Thanks for your help.

Deanne

Connecting To Java From Flash
Hi,

I need to be able to connect and run HTTP requests in flash, the backend is in Java.

Now I can connect to the server easily enough, but how would I be able to run http requests like so in flash:

Code:
GET /<username>,<partner_id> HTTP/1.1

Host: <host ip>

Connection: keep-alive

Code:
GET /G<data_grade><comma-seperated list of csis> HTTP/1.1

Host: 82.***.***.**

Connection: keep-alive

The last piece of code returns data, but I'm not sure how I can run these requests in flash.

Cheers,
Chris

[F8] Connecting Flash To Mysql
I want to connect Mysql and flash, as I know it's impossible without additional programs, could somebody tell me, if there is any way to make it?

Need A Little Help Connecting Javascript & Flash
ok here is the code I have.

<html><head>

<script type="text/javascript" language="JavaScript">

</script>

</head><body>

<form name="loginform" id="loginform" method="post"><p class="submit"><b><font color="green">Already have an account?</b></font><br>

<label>Username: </label><input type="text" name="log" id="log" value="" size="20" tabindex="1" />

<label>Password: </label><input type="password" name="pwd" id="pwd" value="" size="20" tabindex="2" />
<br>
<input type="hidden" name="redirect_to" value="wp-admin/" />
<input type="submit" name="submit" id="submit" value="Login »" tabindex="4" onClick="return ActionURL();"/>

</form>

</body></html>

if you use this code on an HTML page it works the way it is suppose to. but I need the form in flash to peform the function ActionURL().

Any help would be greatly appreciaet

Thanks

Connecting Flash 8 With MySQL
Hi friends,
I am making a web site for a customer and i need to import data from MySQL Database but i don't know how to do it.
I would appreciate it if somebody could give me an idea or tell me where to find a tutorial.
Also i heard that there is a .dll file that Macromedia made, in order to make it easier to connect Flash with Databases, is that true ?

Flash Interface Connecting To .NET, SQL?
hi
I am an actionscript newbie but have been given the task of designing a navigation menu in flash that has to connect to a database - the menu items have to be marked - unread, mandatory etc. and have to pull back database information to display then be marked as read.

Please can anyone advise in general terms how to go about this?
(Would it be using the Data Connections Wizard and Datagrid Colum Editor?)

Many thanks
Em

Connecting Flash CS3 (AS3) With Dbase (ASP)
Hi,

Can anyone help with connecting Flash CS3 using AS3 to a MSAccess Database using ASP? I see alot of demos/tutorials with MySQL and PHP and I am really interested in connecting using ASP to MS Access and then populating a datagrid component. Any help or examples would be greatly appreciated.

Thanks in advance,
-mike

Connecting An XML File To Flash
I have a news section in Flash in a website. I am allowing someone to input the news stories through a content management system, which would create an XML page dynamically. Here's what I put in my HTML to grab the XML page and put it into Flash:

<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','498','height','250','title','News','src','NewsBulletinAS3','quality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movie','NewsBulletinAS3' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="

Flash Connecting To A Database
hi,
I have a movieclip with instance name dummy.This movieclip has a button myMovie with instance name myMovie.

what i have is something like this for the movieclip:
onClipEvent (enterFrame) {
myColor = new Color(dummy.myMovie);
myColor.setRGB(0x993366);
}
& for button:
on (release) {
myColor = new Color(myMovie);
myColor.setRGB(0x336699);
}
This script works for button but does'nt work with the movieclip on load.
What i want is the functionality for button to be applicable for the movieclip on load.
I want the color of the movieclip to change to the hexRGB value set(0x336699) on load of the movie.

Can you please tell me what's the problem with my script?

U can have a look at my .fla file even from the following location:
http://www.geocities.com/shuklahetal/script.fla
http://www.geocities.com/shuklahetal/script.swf

Thanks & Regards
Hetal

Connecting To A Web Service In Flash
There were several unanswered threads from a long time ago that dealt with accessing a web service using Flash. The following takes a web service I created in my ASP.NET web service tutorial and displays the information in Flash:

Code:
import mx.services.WebService;
import mx.services.PendingCall;
function WebServiceCall(input:Number) {
var returnedValue:String;
var wsURL:String = "http://www.kirupafx.com/WebService/TopMovies.asmx?WSDL";
var ws:WebService = new WebService(wsURL);
var re:PendingCall = ws.GetMovieAtNumber(input);
re.onResult = function(result):Void {
returnedValue = result;
trace("Value returned: "+returnedValue);
};
re.onFault = function(fault) {
returnedValue = fault.faultCode+","+fault.faultstring;
trace(returnedValue);
};
}
// 5 corresponds to "Schindler's List"
WebServiceCall(5);
Hopefully this is helpful. This will definitely be expanded into a tutorial at a later time

Cheers!
Kirupa

Connecting Database To Flash Mx
hiya, anybody know any shortcut connection by just using microsoft access to retrieve database..currently trying out apache,,php... javascript s.... can ayone help on this?

Connecting Flash To A Port
Is it possible to have Flash connect to a port besides 80 (http)?

The reason being is that I'm creating a Shoutcast player in Flash/Actionscript.

It works fine when using a Live365 URL which is on port 80. But when I try to use it with a URL to a shoutcast server with a port like 8000 or 8020, it won't work.

Any way around this?

[Edit] Also, the player functions inside Flash MX with Shoutcast. But when played in a browser such as Mozilla, it won't function.

Connecting Flash To Mssql
is this done with flash remoting?..

cant seem to get it to work

The database is setup and values are entered into it through a coldfusion interface...

but just wont read the db...

Connecting Flash MX To A Database
I have a movie clip , that I want to show data that is loaded from a database. I would like to use MS Access, but Coldfusion is an option. Is this possible in Flash MX? And can you direct me to any tutorials or info?

Flash CS3-Connecting To A Database
Hi,

I am relatively new to Flash and I have been searching all over the web for any kind of tutorial for connecting Flash CS3 and Flex 3 to a database. I don't want to use XML as I have a large amount of data. Most of the tutorials have been with XML or mySQL and PHP... Is there a way to connect to a SQL server (or even MS Access)? I am not a programmer, but i am tyring to learn this to automate some of my current web reports for work...Any help would be greatly appreciated. Thanks.

msc31

Connecting To A Database In Flash...
Well... I've found a few tutorials and thing about using ASP to connect to a database, but the server I'm on doesn't have ASP (And it's on a Host, so I don't have root server access to add it.) iS there any way to use PHP to connect to a database?

Flash Connecting To Database
I'm primarily a designer, but recent events force me to learn how to connect flash to a database, something I've never done...

Here is what I'm trying to accomplish.
Flash menu with non flash content.

Click on a product in the flash menu which
loads an Image, description, price, link for spec sheet, and link for zip file which need to be loaded into a table or frame.

I have an access table with data in it right now, but have no idea how to have flash get the data from the table or database to the web page it sits in.

Can someone please point me in the right direction? I've been searching, but have not found what i'm looking for. I'm not trying to load the data into flash, but into a table in html, php, asp, or whatever it needs to load into...

Connecting A Database To Flash
hi.. is there any way i can connect a database with flash?
say access ?

if anyone knew the answer i would really appreciate your help

Connecting To Java From Flash
Hi,

I need to be able to connect and run HTTP requests in flash, the backend is in Java.

Now I can connect to the server easily enough, but how would I be able to run http requests like so in flash:

Code:

GET /<username>,<partner_id> HTTP/1.1

Host: <host ip>

Connection: keep-alive

Code:

GET /G<data_grade><comma-seperated list of csis> HTTP/1.1

Host: 82.***.***.**

Connection: keep-alive

The last piece of code returns data, but I'm not sure how I can run these requests in flash.

Cheers,
Chris

Connecting Flash Link To HTML
Hi,
The page that I created is made up of half flash and half html. I am still trying to link this flash link to another part of the html portion of the page. That is, click on the flash link but not changing to another html page through url and a http address. I want the page to stay still while html is controled through flash. I have seen it before on pages how is this done? Please help
thanks
Exit

LoadVars & Connecting MySQL To Flash...
Good morning!

I am currently trying to make a Starmap for a game which will load the coordinates of the stars when you enter the code for it (1-11800~). I have compiled a Database which has 5 variables per Star in it and when I use the PHP as seen below:

PHP Code:

<?
        $dbh = mysql_connect("aaa", "bbb", "ccc");
        $query = "use aaa";
        if (!mysql_query($query, $dbh)) die("Datenbank existiert nicht.
");
        $query = 'SELECT * FROM navigator WHERE system_name="'.$_GET["system_name"].'"';
              //if (!mysql_query($query, $dbh)) die("Fehler beim INSERT von Galaxen.
");
              $result = mysql_query($query, $dbh);
            echo mysql_error();
            $arr=mysql_fetch_row($result);
            echo "&system_name=".$arr[0]."&coordx=".$arr[1]."&coordy=".$arr[2]."&coorda=".$arr[3]."&coordb=".$arr[4]."&coordc=".$arr[5];
            mysql_close($dbh);
?>

I am handed the following response:

Quote:

&system_name=1234&coordx=537&coordy=178&coorda=118 &coordb=-7&coordc=299

What I am trying is to get Flash to understand these are variables it should be loading into the program because I have multiple functions that use exactly these variables. So I coded this into my Flash Application (This is in the Timeline and not on the button)

PHP Code:

Calc.onRelease = function ()
{
        var n = new LoadVars();
        n.onLoad = function(OK) {
                if(OK){
                        trace("getcoords.php?system_name="+SystemNr.text);
                        trace("coorda="+coorda);
                        trace("coordb="+coordb);
                        trace("coordc="+coordc);
                        trace("coordx="+coordx);
                        trace("coordy="+coordy);
                        /* The next 4 functions use the variables coming from the php file */
                        karte();
                        yline_mc.move(yline_mc._x, Number(coordy), 8);
                        xline_mc.move(Number(coordx), xline_mc._y, 8);
                        Flugzeit(coorda,coordb,coordc);
                } else {
                        trace("This script is broken.");
                }
        }
        n.load("getcoords.php?system_name="+SystemNr.text,"");
};

Since I couldn't find out what the problem was I placed some traces as seen above. I end up getting shown that the number I input (in this case 1234 as example) gets read in but I think I have a problem getting the variables actually loaded into the program.

Is it maybe because flash needs a bit more delay to make sure it has what it needs before proceeding ? I tried that with LoadVars as seen above but to no avail =/

The trace result:

getcoords.php?system_name=1234
coorda=
coordb=
coordc=
coordx=
coordy=

I think what I am missing is something minor but I can't seem to find where I am lacking =/ Any help would be extremely appreciated ! Thanks in advance.

Phelan

Does Flash Player 9 Has Problem Connecting PHP?
HI All,

I need help, its really urgent. I had created a mail form using Php. It does connect with the php whn I m testing it in flash 8. But when I upload it on server and test it, It does not seem to be connecting with the php. I am using send and load method. I always get error connecting with server as a response.

Does this has anything to do with the Adobe Flash player 9? Coz before installing the new flash player the same script was working fine.

Pls help me, its very urgent. I am not being able to send or recieve any mails thru my website. Please suggest a solution.

Thanks in advance.

[F8] Connecting Paypal To Flash Site- Help
I am presently designing a web site completely in flash - and I need to connect paypal to the site...
I ve tried doing this through action script onRelease = function.....getURL (URL ADDRESS) - when I test the movie in swf -click the button...it instantly connects and goes to the Url address- However if I publish the movie in html- through internet explorer it doesn t work - click the button and nothing happens...why?

if anyone knows what i m doing wrong or knows of a better way of connecting paypal to an all flash web page - please let me know

Thanks in advance

Connecting Flash To A Database Using A Variable
I have a news section in Flash in a website. I am allowing someone to input the news stories through a content management system, which would create an XML page dynamically. Here's what I put in my HTML to grab the XML page and put it into Flash:

<script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0','width','498','heigh t','250','title','News','src','NewsBulletinAS3','q uality','high','pluginspage','http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash','movi e','NewsBulletinAS3' ); //end AC code
</script><noscript><object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,28,0" width="498" height="250" title="News">
<param name="movie" value="NewsBulletinAS3.swf" />
<param name="quality" value="high" />
<param name=FlashVars value="xml/KBulletinAS3.xml" />
<embed src="NewsBulletinAS3.swf" quality="high" pluginspage="http://www.adobe.com/shockwave/download/download.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="498" height="250" FlashVars="xml/KBulletinAS3.xml"></embed>
</object></noscript>

What I need to know is how to refer to this dynamic page in Flash itself. Right now I can only get the Flash file to work referring to the XML file itself instead of a variable that stands for a dynamically created XML file. Any suggestions on how to do this?

Flash Client Connecting To WebService
Hi,

i'm working on a flash client that sends and receives data from a web service
(coded in J# if that matters).
we are a team of 3 and are currently working on a demo so we run tests on the company's network.

my machine - lets say Ronen.company.corp is holding a Windows IIS virtual directory with the swf and and html which embbed the swf.

my co-worker's machine - Lior.company.corp is also holding a Windows IIS virtual directory with the webservice.

when i run the flash client locally it works fine and i get the data from the WS, but when my co-workers get the flash client from Ronen.company.corp/app/index.htm - it doesnt work at all, they cannot access the WS.

i guess this is a security issue, how do i work around it?
thanks upfront.

Connecting Flash To Other Computers (engineering)
What is the best way to connect a computer running a swf to other computers? I'm working on flight simulators and I need a way to make menus that can update and receive information from a host computer (linux computer I believe) quickly. I know that actionscript can read a XML file repeatedly but I'm thinking that will have slow performance. Could I call a PHP, ASP file instead? I'll have to write and read information. Any ideas and advice would be much appreciated.

Connecting To Remote FMS From Local Flash
hello;

I am testing with 2 different servers, both are on internet webservers:
server A: Flash Communication Server ... rtmp://server_A.com
server B: Flash Media Server ... rtmp://server_B.com

I have a FlashCS3 application that attempts to netconnect;

test A - while in the FlashCS3 authoring environment I attemp to connect to server A; the netconnection is rejected ( however if I post the .swf to the webserver that hosts server A, the netconnection is successful );

test B - while in the FlashCS3 authoring environment I attemp to connect to server B ... netconnection is successful;

any thoughts as to what the rules are for connecting to a remote FCS/FMS from a local Flash environment??

thanks
dsdsdsdsd

[AS3] Connecting With Flash Media Server
I need to stream my video from my flash file to flash media server...can anybody help me out...............

Trouble With Flash Connecting To Internet
Hi!
I never had this trouble before and im really confused about it. Today I sat and designed my website when I was fixing my buttons for my website. Just like before I had added the flash menu to my site and the links have worked perfectly, but today when I was working with the last one and I was about to test it gave me a warning saying that the flash player was trying to connect to this internet website and it showed me the link to my site. It to allow it I was supposed to press settnings and change the settings via the adobe website, so I did. But it won't let it use the internet. I've added the site to the trusted zone on the settnings but it still gives me that warning and now it don't work at all.
I really appreciate some help!

Thanks in advance!

Error Connecting - Flash Remoting
Hi, wonder if the wisdom of crowds can help us
We have an issue with people connecting to our FMS app.

What weâ€™re using:
- Flash Remoting via an http gateway service

On clientâ€™s internal networks, the connection to the Flash Remoting gateway service on our server is not able to be established and times out.

Possible problems:
- Port being blocked
- Firewall preventing 2-way communication
- Windows firewall preventing communications
- Automatic routing for port 80 preventing the server response from reaching our app
- ??

Has anyone else run into this problem, any fixes or work arounds.
Thanks for your time and energy ;)

Flash Media Encoder Not Connecting
We have our own FMS and I have just installed the FME on a workstation. FME reads video perfect but when I try to connect to the server it won't accept my username and password. Where do I set this? I have installed the add-in for FMS and also upgraded to the latest 2.0.7 release. I'm green to the Flash Media Services so this may come as a dumb question. Please help!

Debugging With Flash Connecting To Database
When debugging from within Flash this doesn't work properly when my Flash movie connects to a database via PHP. How would I be able to debug from within Flash with my local webserver running? Or isn't this possible?

Thanks.

Flash Media Server 2 Is Not Connecting
Hi,
We made an Instant Messaging tool with FMS and it works for 20 min and then start giving the error and stops connecting to our XML.
httpStatus: 0
StatusType: flashError
could not load xml

It usually happens after # of users goes over 200 or after 20 min( either could happen)
Any idea why we getting errors ??
Thanks

How To Stop Flash From Connecting Lines?
whenever i have a line close to another, flash keeps adjusting them so that they connect. it's driving me nuts! i've clicked every option i could fine regarding lines...

Connecting Flash To .mdb Database File
Is there any way to do so with Flash MX?

Page 2 - Connecting To A Database In Flash...
I'm not sure I got that... But I might be able to do it now. (Sorry. I'm an OOP adept ^_^)

Connecting Flash MX2004 To An Access Database
Hi,

Im putting together a flash file that will form the basis of a promotional CD. As part of the CD I want to build in a database of our products that are searchable (already created using access), but i dont want the user to come out of the flash environment to do so.

I found somewhere that i would probably have to use an ASP page between the database and the Flash file, using the Load Variables function, but i still havent quite managed to get it to work.

Anyone done this before that can shed some light on the subject???

Cheers!!!

Connecting A Flash Form With An Access Database?
hi everybody

i have this simple question , which is , i want to make a small form in flash (for example enter your name), so when i fell this form and click send , the data will be send to the access database , ofcourse throw an asp file,

so how can i do this move?!?

i try to search for this in the movies section in the site , but i didnt find it

so if anybody have an opening file for thie problem i hope he can put it here , or at least tell me how it works (plz this is very important)

and thnx everybody

Flash Connecting To Database, Loading Pictures
I'd like to create a flash application that is connected to a database via PHP.

Table:
Filename Text
1.jpg This is John
2.jpg This is Kate
3.jpg This is XY

The Flash application should load the database, blend in file 1.jpg and how the corresponding text, then move on to the next picture etc. If anybody has any quick way of doing this it would be much appreciated.

Trouble Connecting To Flash Streaming Service
does anyone happen to use Playstream and have some advice? I'm trying to connect with the attached code and I'm getting the following error message:
Error opening URL 'rtmpe://fvss.playstream.com/fvssod/escstream/Irish_Dancing/Two-HandJig_56k'
Error #2044: Unhandled NetStatusEvent:. level=error, code=NetStream.Play.StreamNotFound
at testPlayer_fla::MainTimeline/frame1()

Connecting To A Flash File On Another Html Page
Scenario:
*all flash are completely independent files loaded in the page

Index -- flash navigation
Index2 -- flash navigation + flash component

I want to have the flash navigation determine what page it is on, and then either go to Index2 and then play a particular frame in the flash component, or if already on Index2 just play the particular frame in the flash component.

I have the localconnection set for the navigation and the flash component on the Index2 and it works. I want to know if it is possible to transfer a gotoAndPlay action from the Index to the Index2 flash component. I know it is possible if both pages are open at the same time, but not sure about the way I want to do it.

If anyone has anything that might help, I would really appreciate it!!

Connecting Flash To SQL

Please exist any link - tutorial where is described how is possilble to connect Flash to SQL database and work with them?Any experience? What is the simpliest way?thanks in advance jankratochvil

Please exist any link - tutorial where is described how is possilble to connect Flash to SQL database and work with them?

Any experience?

What is the simpliest way?

thanks in advance

jankratochvil