Is it possible to Execute SQL on server via a FM client?

[Guillermo Dewey]

I need my FM users to "EXECUTE SQL" script step on the FM server with out having each client to have the SSH and Driver to a PosgreDB. That is to have only one centralize connection (on the server).

I installed the Actualtech server driver on my server, the server loads and connects to the posgresql server thinking that hosted fm files would use that dsn. but NO :S the clients try to connect via their own odbc resources not the server..

is the execute sql for client execution only?

is ther a way someone can think as a better way so I dont have to set up each client? some of my users are FM Go where there is no driver for external dbs :S

any advice is apreciate it

Guillermo Dewey

OFIK SA DE CV

http://www.ofik.com

[bcooney]

Yes.