Re: Connect to IDS from Open Office 2.3.1

This is now working on another machine. Something hinky is definitely happening on this box. The only remaining problem is that it refuses to allow certain SQL standards. It doesn't like SQL80/Informix syntax queries and it won't allow EXECUTE FUNCTION/PROCEDURE statements. <sigh> I've devolved to using RazorSQL to export the data to a CSV files and importing those into the spreadsheets where I need them. Low tech but it's working. Thanks all. Art S. Kagel Oninit

Have you thought about using either Python or Groovy/Java? I haven't had time to play with it, but there are some Python mods that can handle some of the spreadsheet formats. (Granted its not the same to be able to call the database directly from the spreadsheet. but Its a "better" way for dealing with pulling data into the .csv format.) > From: art.kagel@gmail.com > This is now working on another machine. Something hinky is definitely > happening on this box. The only remaining problem is that it refuses > to allow certain SQL standards. It doesn't like SQL80/Informix syntax > queries and it won't allow EXECUTE FUNCTION/PROCEDURE statements. > <sigh> > > I've devolved to using RazorSQL to export the data to a CSV files and > importing those into the spreadsheets where I need them. Low tech but > it's working. Thanks all. > > Art S. Kagel > Oninit > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ Share life as it happens with the new Windows Live. http://www.windowslive.com/share.html?ocid=TXT_TAGHM_Wave2_sharelife_122007