Is it possible to query_posts using post__in and then Loop through them in the ordered they were queried?

Yes, using this plugin:

http://wordpress.org/extend/plugins/sort-query-by-post-in/

Also see http://core.trac.wordpress.org/ticket/13729

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)