Strange behaviour with IE

[GoogleCodeExporter]

What steps will reproduce the problem?
1. I can receive the returned records in Firefox. But, there is nothing
returned in Internet Explorer. I tried clearing the cache/temp files, but
still the same. Any reasons/clues ??
2.
3.

What is the expected output? What do you see instead?
Expecting my grid to be filled with records. Firefox working fine.

What version of the product are you using? On what operating system?
2.4

Please provide any additional information below.

Original issue reported on code.google.com by manuraj....@gmail.com on 27 May 2008 at 12:20

[GoogleCodeExporter]

Could you enable logging and post the results?

Logger.level = Logger.ALL

Original comment by macl...@gmail.com on 27 May 2008 at 4:14

[GoogleCodeExporter]

Hi there, I am not sure how to enable logging.
I am sending you the code and built in the attached zip file. Simply dump it in 
you
webapps[for tomcat]/htdocs[for apache] and run it as: 
http://localhost:8080/flats/flats/

The responding time from mysql is noticeable.
Wait for a while before you get a few Alert windows. There will be initial 
errors, so
just continue to those.

Try it both in Firefox & IE. In Firefox, you can see two rows(data returned), 
whereas
IE will always remains blank.

[If possible, point me to a location on how to use logger]

Thanks.

Original comment by manuraj....@gmail.com on 27 May 2008 at 5:01

Attachments:

• flats.rar
• flatsdb.sql

[GoogleCodeExporter]

to enable logging in creationComplete, or preInitialize just use this line:

Logger.level = Logger.ALL

It will trace out a bunch of information.

I currently can't test on IE, my windows laptop is at work and I am currently 
on my
macbook.

Original comment by macl...@gmail.com on 27 May 2008 at 5:20

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

Are you using MySqlService with autoConnect="true"? If so I think I may know the
problem. Internet explorer has an issue with making some kind of connections 
before
the entire flex application is initialized.

If you are using autoConnect, try setting it to false, then in your 
creationComplete
handler call sqlService.connect().

Let me know if that works. If it fixes the issue I will put in a patch to fix 
the
problem.

Thanks

Original comment by macl...@gmail.com on 27 May 2008 at 5:25

[GoogleCodeExporter]

No, am not using autoConnect().
And, I think in your release asSql 2.4, autoConnect() is no more there.

Am generating couple of events in onCreationComplete(), which in turn calling 
the
connection.

Btw, Have you tried to run the application that I sent you? Just drop the app in
container and it is ready to run. Alongwith there is a sql script as well, just 
to
create a db. 

Original comment by manuraj....@gmail.com on 27 May 2008 at 5:56

[GoogleCodeExporter]

Hi, I tested the attached files on Vista in IE7 and everything worked ok.

Original comment by macl...@gmail.com on 28 May 2008 at 6:40

[GoogleCodeExporter]

Was it returning the two rows of data in the datagrid ??

It does return that(2 rows of data) in Firefox, but not in IE.

Please confirm that.

Original comment by manuraj....@gmail.com on 28 May 2008 at 6:43

[GoogleCodeExporter]

Yes, it was returning the two rows. In both FF and IE.

Original comment by macl...@gmail.com on 2 Jun 2008 at 12:45

[GoogleCodeExporter]

Hi,
I have this strange thing too. I have apache server on Windows XP Prof. The 
Firefox
does not receive data from mySql via asSQL, but IE 6 runs perfectly. 
If I run the application like 
"file:///D:/_work/Develop/wiMS/bin-debug/index.html" it
receives the data from mySQL. But when I use "http://localhost/wiMS/", then not.
In IE it works perfectly in both way. I have not found yet the solution. Maybe
something with MIME types?

httpd.conf
...
<Directory "d:/_work/Develop/wiMS/bin-debug">
    Options Indexes FollowSymLinks
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>
...
    Alias /wiMS d:/_work/Develop/wiMS/bin-debug

Original comment by wap...@hotmail.com on 6 Jun 2008 at 9:12

Attachments:

• asssql_ff_apache.jpg
• asssql_ff_file.jpg
• asssql_ie_apache.jpg
• asssql_ie_file.jpg

[GoogleCodeExporter]

Some notes to this behaviour...
mySQL does not receive any ask from FF when it runs under Apache. In mySql log 
file
there is no activity in this case...
It seems, that either Apache or FF has a wrong setting. Opera works just like 
FF. So
via Apache it does not do anything too.

Original comment by wap...@hotmail.com on 6 Jun 2008 at 9:52

[GoogleCodeExporter]

If I use the following method for connection:
...
con = new Connection("localhost", 3306, "root", "pass", "db");
con.addEventListener(Event.CONNECT, handleConnect);
con.addEventListener(MySqlErrorEvent.SQL_ERROR, handleConnectionError);
con.connect();
...
private function handleConnectionError(e:MySqlErrorEvent):void {
       Alert.show("Connection Error: " + e.text, "Error");
}
...

I get error message: Connection Error: SQL Error #0: Error #2048 .
It is a flash player security error I guess. It comes when on developer machine 
I run
the application via Apache with Firefox. It does not come runing with IE6.
When I run it from a remote machine this error message comes in both browser.

I wanna use asSQL to replace the PHP scripts to connect to mySQL. Both in local
machine and remotely in a LAN, or over the Internet. Is that possible?

Original comment by wap...@hotmail.com on 7 Jun 2008 at 7:14

[GoogleCodeExporter]

"I wanna use asSQL to replace the PHP scripts to connect to mySQL. Both in local
machine and remotely in a LAN, or over the Internet. Is that possible?"

Yes you can!

As for the other security related errors, currently I am not focusing to much 
time
looking into them. This driver is mainly aimed towards AIR applications which 
run in
the application security sandbox.

I do however plan to look into the security errors at some point so I can 
provide
documentation on getting the driver to work correctly in flex applications as 
well.

If anyone finds out more information please do let me know!

Thanks,

Matt

Original comment by macl...@gmail.com on 9 Jun 2008 at 1:51

• Added labels: Priority-Low
• Removed labels: Priority-Medium

[GoogleCodeExporter]

Original comment by macl...@gmail.com on 14 Jun 2008 at 11:22

• Changed state: Accepted

[GoogleCodeExporter]

Original comment by macl...@gmail.com on 15 Jul 2008 at 5:10

• Changed state: WontFix