Write user data to external database.

Hello,
i tried and i tried but i couldnt succeed. the issue is simple and maybe i am just making a stupid mistake. Here's what i want to do...

use auto actions to write to an external database when a user registers at my site.
pass on the fields [username] [password] [cb_mobile] to the external database with conditional [cb_profession] is equal to LAWYER

here's the query i wrote (the query is just to check out if it passes any data, hence only username is used):
I am using a MySql Server, joomla 2.5 php 5.2.x on shared hosting and the xternal databse is MS SQL 2008 R2 on my virtual private server

i know there is no problem in my triggers & conditions ( as it is practically just selecting from drop downs) i think the problem might be that MySQL & MS SQL don't like each other! ;-P
Thanks,
Bhavin

You can't cross database driver query. The driver used when CB Auto Actions fires a trigger is based off the Joomla database, which in your case is MYSQL. So it's parsing your query and trying to execute it as if it was MYSQL.

Thanks for the reply krileon,
so just to make it clear it is because of two different TYPES of Databse! and not because of two DIFFERENT LOCATIONS of the database?

Correct, the two different types of databases can't communicate with one another as the query action will use the same database driver as your Joomla install (MYSQL).