ActionScript 2.0 :: Flash Connecting To Database (SQL Server)?
Nov 30, 2005
This is what we have... a new Actionscript developer (Me) and a seasoned Visual Basic/ASP developer. We've also got some SQL Servers... We need to write a web application (Flash) that checks user authentication (User Name and Password) against a SQL Server database before allowing the user to continue through the program. After the user completes various components of the eLearning program, a brief quiz will follow. At the end of the whole eLearning program, a lengthy quiz will be given and those results will be scored and stored in a database.
I need to know what is required to do this... this being the database connectivity? I've been seeing PHP/MySQL tutorials but is there some way to hook up into ASP/SQL Server? Furthermore, how exactly does this work? I've read that with PHP, flash will write and store variables in PHP which is then used to get results from the database. I'm not exactly sure tho. If any one can point me to a great tutorial that explains everything about ASP/SQL Server..
What I am after is to be able to connect to a SQL database directly or via a ASP Page (whichever is easier) to pull out some variables and display them as text in a text field. Basically we have a news section on our intranet (stored in an sql) and I want to be able to pull these out and put them into flash. I have looked on the internet for examples, but everything that I do don't seem to work.
I am trying to connect to a MySQL database using PHP in Flash CS3 using Actionscript 3.I have written the PHP file and some AS3 code and it displays the information but for some reason it also displays the tags.[code]The picture below shows what happens when I test the movie.I also need to add buttons to move to the next and previous record and to add or edit the database via the Flash interface?
I have a website in which the content on the index page is controlled by a PHPMyAdmin database. I want a a flash "movie" at the top, that can take the data from the site, and slide-show it until a user clicks on a specific link, in which the movie will direct itself to the clicked event.
The page is for a booking/promotion concert company. They want a "Featured Shows", "Calendar", and flash file that all are interconnected. One page. Does anyone know how to do this, where to find tutorials, or so on? Note, i'm not wanting to WRITE data to the database, I just want to GET data to post on the flash file.
I have a task to make simple game that deployed as a facebook app using Adobe Flex. Like most facebook game, I need to show high score, compare score with friends and some other similar functionalities, which I think need some sort of database thing.
The problem is a had only little experience about database, only have tried simple things with MySQL and I don't know where to start.
I am writing a large flex app that has to connect to a database many times. I currently am using asp pages to connect, but I would like to use the most efficient option. What do you think is the best way to connect to a database from a flex app?
I have inherited a custom application on Flash Media Interactive Server 3.0 that broadcasts audio in real time. The custom app is written using Adobe Flash Professional 8 and actionscript 2.0.
A little background of how the custom app works When a user connects to the media server to join a stream, our custom application calls out to a seperate application server (that is not Flash) to determine if the user is allowed to connect to a broadcast stream and which stream they should join. We use Xml.sendAndLoad() to do this. The application server we call sends back Xml to the custom App on the Flash Media Server.
I got the script to work perfectly, even got to register a few hundred members to the site. However, my old host had a bandwidth limit of 400gb so I had to move to a new provider. I transferred all the files with no problems, and even setup the database properly. My new problem is registering... I can login just fine using an existing account I had made. But I go to try and make a new account and I get an "undefined" error.[code]...
I'm developing a desktop application in Flash, but I can't seem to find any tutorials that aren't based on FLEX to connect my application to a database file.
Do I have to write my application in FLEX to use SQLite or can I create an AIR app in Flash and still use it?
I'm still learning AS3 and am trying to set up validating user (text box) input of 2 items (name and password) by checking with an SQL Server Database on my website.I have the ASP page set up using a standard request/response.write script. It works I've tested the ASP, and it works. The ASP receives the 2 variables, hopefully each in a name-value pair, and checks with the DB, then if the name and password received from the Flash SWF match a name and password in the DB, sends back a "YES" and, if not, sends back a "NO".I'm having difficulty getting the AS3 written and working correctly. Here's what I have so far that displays errors, causes a flickering when previewed and doesn't yet work.
I'm working on Flash project for which I have to conenct to Oracle database, retrieve data and display it.Is it possible to connect to Oracle database from Flash?
I'm trying to troubleshoot a Flash Media Server working with a little video playback application I wrote a few years ago that has suddenly stopped working.I'm using CS3/Actionscript 3.My app uses the FLVPlayback Component, and was working well last time I checked. I recevied a report that the videos stopped working, and have been looking into it.I figured I'd add a bunch of event listeners to the FLVPlayback's ncMgr.netConnection so I could get debug info on things like io errors, net status, etc.The problem I'm running into is that the netConnection is null when I set it to anything on my Flash Media Server, and adding any event listeners to this netConnection throws errors.Here's what I've tried so far:
Playback of a local FLV file works fine.In the FLVPlayback documentation, I found an example and stole the URL of the stream they were using in the example, and that works fine, although it is an HTTP protocol stream rather than RTMP.Any attempt to access FLV files on my Media Server, which has worked fine in the past, basically cause the FLVPlayback object to sit and hang in "buffering" mode and never progresses beyond this point.The netConnection object in this case is null.Here's my code:[code]........
Again the purpose of this is to troubleshoot the video streaming from the Flash Media Server, and it seems like there is no netconnection to the server being created.Does this mean that the server is not working, or is there a problem with the way I'm trying to access the content on the server?This was all working fine before, and I have set up the server-side application .ASC files and such to allow things to work fine on the server end.
I have a Flash client that I want to connect to a server. Both are using localhost and port 50000 so there shouldn't be any cross-domain problems. I also set Access Network Only in the publishing settings. When I call the XMLSocket connect, the server seems to get a new connection. But, the XMLSocket.onConnect callback is not called with success=true.[code]...
The ActionScript 3.0 Reference says the following about flash.net.NetConnection:
The NetConnection class creates a two-way connection between a client and a server. The client can be a Flash Player or AIR application. The server can be a web server, Flash Media Server, an application server running Flash Remoting, or the Adobe Stratus service. Call NetConnection.connect() to establish the connection.
Does this mean I make a regular HTTP connection to any web server using an NetConnection object? I am a little confused about this as further down the section on the connect() method says connect(): Creates a two-way connection to an application on Flash Media Server or to Flash Remoting, or creates a two-way network endpoint for RTMFP peer-to-peer group communication....Pass an "http" URL to connect to an application server running Flash Remoting.. So, the application server has to have Flash Remoting?
I have access to a flash media server on a CDN.I want to allow people to easily connect to this server. Currenty, they need to an additional software to connect to the FMS.It would be nicer if they could just connect to the server with their browser.So I assume I need to create a SWF file and connect from this file to the FMS (with Actionscript).The end result would look like the demo of the jquery webcam plugin, only that the SWF file would establish a connection to the FMS and stream the video to the FMS
I am trying to connect to an FMS application without flash (no SWF). To the best of my knowledge,the only way to accomplish this is thru the admin APIs, is that correct? If so, how do I return meaningful values from the admin API? I can call functions and stuff using the broadcastMsg API call but I can't seem to get back any values. All that is returned is a useless "Success" type message. I have tried using shared objects and the getSharedObjects API call, but the call doesn't return any info on the contents of the shared objects, just their names and some info on their persistance.
Is there another way of accomplishing my goal outside of the Admin API? If not how do I return meaningful variables from the Admin API? Is there a way to hack or extend the admin API?
I want to create a Flex 3 application running in Adobe Air that accesses an SQLite database and I need to keep this database in sync with an SQL server 2005 database running a website.Is this something that Flex supports or is it going to be a custom script? Also, has anybody done anything like this?
Edit: The synchronisation can be done on a daily basis rather than real time. The data will be read only from a front end perspective with a CMS to do updates on the website.
I am trying to set up DVR streaming using FLME. I'm following this tutorial: http:[url]........I'm up to Step 2,
I put in the following information into the FLME: FMS URL: rtmp://222.222.222.222/dvrcast_origin Stream: mp4:sample.f4v
Then click 'Connect' , but I get an error "Failure to connect to primary server verify that your server URL and application name are valid and that your internet connection is working and retry". My server is a 32-bit windows 2007 VPS , with FMS running.I don't know if I set up the DVR Cast application correct. All I did was copy the dvrcast_origin into the installationdirectory/applications, then I started a new instance of dvrcast_origin with _definst_...Also, I am running the trial version of FMS, and DVR needs FMIS. Is there a way I can just run FMIS?
I try to establich the connection with asc file from applications/videochat $connection_string="rtmp://videochat/"; And I'm getting the result from media server Connecting to the video server...>>The client does not have permission to connect to the application, or the application expected different parameters from those that were passed.>>The connection was closed successfully
I'm trying to connect to an FMS server with a Flex application. I can throw the rtmp URL straight in as the source for a VideoPlayer and it will work, but can't figure out how to get it to work with a NetStream. The pure Flash Video element works as in the FMS Flash demos, but is extremely laggy and lacks all the nice functionality of the built VideoPlayer. Is there any documentation on working with FMS with Flex? We're at a point where we need to decide quickly if FMS will do what we need to do or if we should purse other technologies.
i am self-taught and i have pretty good as3 and mxml skills and have worked with Flash Pro and Flex, but only for my own stuff at home. i have only done local AIR stuff that don't require sending and getting data from a server now someone has asked if i could build him a kiosks/server system, and i want to dive into that the kiosks would be deployed in stores and have touchscreens displaying pictures, movies, banners and accept user control and data.i plan to build his remote controlling software in Flex and the kiosk AIR apps in Flex or Flash pro.the kiosks should periodically connect to the server to see if updates are available and download swf, jpeg and movie (mp4? flv?) files to the local filesystem (no live streaming is needed)also, user created data (forms only) should be sent to the server - i guess xml.[code]can all this be in as3 alone or do i need stuff like php also?also, would i be able in the controlling flex app to determine if specific kiosks are offline?
i am working on creating a custom application for FMS 3.0 that calls a webservice to validate the user coming in. I have tested the following sample code from the Server-Side ActionScript Language Ref. (See below) The URL has been changed to protect the innocent.
This codes seems to work fine when going to an unsecured site but the innvocation of the service never seems to go out when attempting it over SSL. The Server documentation says that outgoing calls like this should work over SSL. Is this true? If so what do I need to do to get it to work?
I've been using FMS for a few weeks, and feel relatively comfortable with it, but am currently having some trouble connecting to a live stream in a a video conferencing-type application. I suspect I'm leaving some small step out, but am having trouble seeing what that step is.
I have one client application open the video camera, connect to the FMS, and publish it's live camera stream to the server. Something like this:
I installed FMS 4 on my notebook and I was able to access the console without trouble. I used localhost for the server address. When I installed it on a remote server (Windows 2008), I can't get in. I tried the same thing. I opened it from the file system [URL] and I tried localhost but it didn't work. I've tried other values
[URL]
One problem could be that I installed Apache but there is already a IIS server using the port 80. When I look in the service panel, FMSApache says it is starting but not started.
Suddenly mic not connecting to server. I have FP 10.1. 102.64 Windows XP 32 bit and explorer 8. See link which instructs me to "change" but no response.
