Hi there

I'm attempting to get Flash MX and SQL to converse - I've never done it before with Flash - can anyone help me - I need to create an odbc connection to the db and then request some records within Flash.

Many thanks

Adam

I know Flash makes Data connection kit for this purpose http://www.macromedia.com/software/dataconnection. The new Flash MX 2004 profressional is suppose to include this.

I have made the connection outside of Flash and imported it in through the source link, I'm not sure how dynamic you need it to be.
VALUE="Flashfile.swf?Counter=1111">
src="Flashfile.swf?Counter=1111"

loadVariablesNum ("counter.asp", 0);
start_Count = int(Counter)
cur_Count = (start_Count + 1)

Hi Harpua

Well, I need to be able to read data from a SQL database - How do I make the connection? Do I write the SQL SELECT statement in flash for the data that I want to retrieve?

Thanks, Adam

Sorry I'm not always clear sometimes. I use ASP and create a connection string outside of Flash on my page, from there it will pull the Data in. The only problem with this is that it isn't dynamic. Once the page is loaded you would have to refresh the page to get new data, which kind of defeats the purpose of Flash. For the more dynamic content I would check into the data connection kit.

<%
Set objConn = Server.CreateObject("ADODB.Connection")
        strConnect = "Provider=SQLOLEDB;Data Source=00.000.000.00;User Id=XXXXX;Password=XXXXX;Initial Catalog=XXXXXX;"
objConn.Open strConnect

    strSQL = "SELECT LastCount FROM TableName;"

    Set objCmd = Server.CreateObject("ADODB.Command")
    objCmd.ActiveConnection = objConn

    objCmd.CommandText = strSQL
    objCmd.CommandType = adCmdText

    Set objSelect = objCmd.Execute
    Set objCmd = Nothing

%>

VALUE="Flashfile.swf?Counter=<%= objSelect("LastCount") %>">
src="Flashfile.swf?Counter=<%= objSelect("LastCount") %>"

Inside Flash___
loadVariablesNum ("counter.asp", 0);
start_Count = int(Counter)
cur_Count = (start_Count + 1)

Your flash (running on a web client) needs to talk to your web server and your web server talks to the SQL server. For this to work you need to code in flash, a web scripting language like php/asp/cold fusion/jsp, and then the web server talks sql to your database.