Perform Server-Side Execute SQL Script

[nutso]

Hiya guys,

Is it possible to perform a script with the "Execute SQL" command to update records in another database (such as Oracle) from a client machine but use the ODBC drivers and Data Sources from the server??

The reason I ask is in the past when I want users to perform an "Execute SQL" script I have to set up ODBC drivers and Data sources for each machine that will use the script.

It would be easier for me if this script was ran server-side where the ODBC Drivers and Data Sources would only need to be set up once. But still make it so that users could run the script from thier own client machine.

Does this even make sense and is this even possible?

Thanks

nut