« Return to the main article
How about creating the iqy text file on the fly with an agent - and get them to save it to local machine..
then prompt the user for their password (username is already available).
I already build my view on the fly with an agent. So for me the url line would be ...
http://<host>/<DB>/<agent>?openagent&username=<username>&password=<pass>
you then prompt them that the file should be deleted after use blah blah own responsability...
then you can get them to use excel to open the iqy file locally....
(hack on top of a hack on top... ) not very clean I agree - but excel mac and excel 2000 doesnt like my SSO setup.
How about creating the iqy text file on the fly with an agent - and get them to save it to local machine..
then prompt the user for their password (username is already available).
I already build my view on the fly with an agent. So for me the url line would be ...
http://<host>/<DB>/<agent>?openagent&username=<username>&password=<pass>
you then prompt them that the file should be deleted after use blah blah own responsability...
then you can get them to use excel to open the iqy file locally....
(hack on top of a hack on top... ) not very clean I agree - but excel mac and excel 2000 doesnt like my SSO setup.