Digital Workshop

Hi,

Had posted for some help with post web data using ASP, thinking I couldn't use PHP. Updated my web site and got PHP functionality working. So, was able to set up the post web data using PHP with help from the excellent tutorials on the forum. The Flex Flash swf db connections work fine when running the SWF in a desktop standalone Flash 10 player. But when I upload the swf to my site, can't get it to insert/query. I wonder if the Flash/PHP/mysql connections on the server side are too slow?

So, I'm back to trying to figure out other solutions, using PHP and MS Access or MSSQL or same using ASP. Hopefully if I can figure out a script and test the swf when run on the server, it will connect and work.

Any suggestions appreciated.

Kind Regards,

Is the SWF hosted on the same server as the PHP? Otherwise Flash's security will not allow posting data.

Hi Dave,

Yes, I'm using Robin's old tutorials (Part's I and II) and have created a sample Flex IMP precisely following the tutorials.

The 2 PHP files "insert.php" and "select.php" are both up on the same server as the uploaded SWF (I used one Flex SWF with 2 pages-one for inserting, one for selecting).

While they all communicate perfectly if I run the SWF on my desktop in the latest standalone Flash 10 player, they don't seem to communicate when all are on the same server.

Kind Regards,

I seem to remember some issue with addresses when uploaded i.e. try simply 'insert.php' (or 'folder/insert.php' etc) rather than 'http://www...'. I think I set up 'if' statements so that it would use the full address when testing but local ones when uploaded. Also, I remember some limitation with working down folders (ie '../insert.php') although this may have been when playing with the html file. Sorry to be vague but I haven't got time to investigate this now. Perhaps just have a go.
Cheers
Dan

Hi Dan,

Yes! That worked! Thank you very much.

I was already placing these PHP files in the site's root, so no folders. But after removing the http://www......, and just leaving /insert.php, it worked. Tested in FF and IE.

Again, thank you.

Kind Regards,

Hi, again.

I also need to try to get data back from an MS SQL Server DB. While writing the PHP, using mssql functions instead of mysql functions, is fairly straightforward (they're about the same), making the connection with the SQL Server has been challenging. Have tried every combination, with and without a port number, etc. So far, nothing has worked. Cannot connect and get the data back into the Opus Flex using a SQL Server DB. (Doing this for MySQL works.)

The eLearning lesson LMS standard DB is SQL Server, not MySQL. And re-doing the LMS's data storage to MySQL has also failed.

So, if anyone has any tips, tricks, experience getting data back into Flex from a SQL Server DB, please help.

Kind Regards,

Don't have MSSQL server but this should work:



PHP Manual is a good place to start: http://www.php.net/manual/en/ref.mssql.php

Mack

Hi Mack,

Thanks for these suggestions. Unfortunately, I've used precisely the PHP script suggested (and read the PHP manual's relevant sections). And, I agree, it should work. The SQL Server DB is up and running (it it used by the LMS regularly, and works OK). But for whatever reason, the PHP configuration to connect doesn't seem to connect. I believe that the problem is connecting. I've also checked all the permissions, etc.

The LMS connects via a pre-cofigured ASP template that uses a connection string (works every time):

connectionstring="Provider=sqloledb; Data Source=xyz.db.11111.abc.com; Initial Catalog=name1; User ID=name1; Password=zzzzz;"

So, I tried another strategy: trying to write an ASP script to access the DB and return data back to the Flex SWF.

So, far, using a connection test ASP script, and the above connectionstring (http://kb.deru.net/?View=entry&EntryID=53), I have been able to get a correct data item back from the SQL Server DB that displays on the ASP page which I've uploaded to my site. So, the ASP connection and accessing of data works.

But, trying to get the data back into the Flex SWF using the post web data (destination) action, so far does not work. So, the ASP script which uses response.write.recordset is not sending back the data into the SWF.

Not sure how to script this in ASP to get the data back.

Challenging issue!

Regards,

Is MSSQL enabled in the PHP settings?

Create a script that checks phpinfo() and look for the MSSQL section. If it's not there, then see if you host will change it for you.

Mack

Hi mack,

Yes, I uploaded a new phpinfo.php, and it has a section for mssql. So, I think PHP 5.2.17 is enabled.

So, a little dilemma. I can connect with the SQL Server DB using a test ASP script, but cannot get anything back into the Flex SWF. Or, I can write a capable PHP script that is likely going to work in the Flex SWF (same script but written for mysql instead of mssql gets back data into the Flex SWF), but will not connect with the SQL Server DB.

What to do?

Regards,

Morning Stephen,

If I were a gambling man, I go the PHP route.

Mack

Hi Mack,

Yes, I would use the PHP route, since Opus Flex works well with it, if only I could connect to the SQL Server DB (where the LMS likes to store its data).

An ASP test script using the following connect string, connects to the SQL Server DB:


I wish there was a way to "translate" this ASP-formatted connection string into PHP to facilitate connecting. (PHP connect function parameters don't seem to allow for replicating this connection string data in a way that successfully connects.)

Kind Regards,

Have you tried running the PHP script from your host to see what the error message is?

Mack

Hi Mack,

Using a similar PHP script to the one you posted above, I got the following errors:



Not too sure what they mean.

Google is a friend.

http://www.phpbuilder.com/board/showthr ... t=10345581

I would also ensure that you are testing in small bits. IE just having a logon script to check that you can at least connect to the database. Keep it simple and build up.

Mack