Re: Informix / Excel connectivity

"Carlson@WHSmith" wrote: > > IDS 7.30.uc7 > > One of my users' upcoming requests is to be able to create user-defined > Excel reports using info from our Informix database. I have a few > questions and issues that someone out there may have answers for: > > 1. Is there such a product? I'm aware of Office Connect . . . . it > appears to be the answer, but I haven't heard any practical > applications. I'm also aware of the Lawson financials aoftware suite, > but I'm also looking for a product that we could use enterprise-wide > with all of our Informix data, not just the Lawson section. O-Connect seems to be OK, I think it's a bit clunky but it does what it says on the tin. > > 2. Now that we're talking ODBC, I'm aware that there are various > security issues using a product such as this. Again, this is new ground > for me, as we have kept a relatively closed system using shared memory > connections. Is there any relatively easy way to create a read-only > connection with an ODBC product? Hmmm, surely with a ipc connection then you can easily right code to get to the shm and isn't that a similar security risk > > Thanks in advance! > > -- > John Carlson > Informix DBA > WHSmith USA > > #include std_disclaimer.h /* These are my opinions, not my company's > opinion */ -- Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # for ever www.wfsoftware.com #