Re: Using Crystal Reports for Informix Database

Melvyn Lai wrote in message <6om0t6$s4$1@news.bctel.net>... >Hi, any help on using Crystal Reports on Informix Database. > >I am using Informix Online database (Version 5.05) on HP-UX (9.04) and all >our desktops are all Windows (either 3.1 or 95). At present, we access the >database by logging into the unix server first through a terminal emulation >software, so we don't have a direct client/server setup between the desktop >& the database server yet. So what do I need? How can Crystal Reports >access the Informix Database? What is the difference between ODBC & Native >access? Besides Crystal Reports, what software do I need to run on the >users desktops and the database server side? > >As I am not experienced in SQL server, though I phoned both Informix & >Seagate software, I am still not thoroughly understand what I should have. >They gave me a bunch of new names, I-NET, I-Connect, I-CLI, I-Client SDK, >I-STAR,.. What we have done is install Informix-CLI on the client machines and configure is using SetNet (for of I-CLI) and ODBC to require the user to provide a password at execution time. We use IDS 7.x and configured in to accept ontlitcp/onsoctcp connection, You would probably use I-STAR on your server? They when Crystal wants access to the DB a window pops up to allow the user authentification. With Crystal 6, we discovered that for us it was more stable to install CLI, then Crystal, and make sure we were using CLI's ODBC drivers instead of whan Crystal provided. I believe it was more stable and gave better support. > >Any suggestion will be valuable to me. Thanks a bunch. > >Melvyn. S.W.