Re: BIG ROOKIE QUESTION #2

On Wed, 26 Nov 1997, Ed Bragg wrote: } How do I tell what version of Informix we are running? You run Informix programs with the -V option, as in: isql -V fglpc -V $INFORMIXDIR/lib/sqlexec -V Similarly for c4gl, esql, tbinit, sqlturbo, etc. } I've been looking around and seen some products that support Informix 5 } and Informix 7 ODBC. Though, I've scoured every directory on your HP-UX } system (The /usr/informix ones) and cannot find anything that gives me a } definite Version number. Additionally, you can look at the *-cr files in $INFORMIXDIR/etc. } BTW, we don't have the manuals .. our Software Developer kept those for } some reason. Hmmm. I don't approve. If you bought the products legitimately, you should get the manuals as they are a part of the product. If he fobbed you off with second hand software, you could have legal problems. } ... guess they didn't want us to figure out how simple their database } is afterall. Maybe. } I'm pretty sure we have several products of informix. You do. You should have ISQL 4.1x (where x is probably 2 or less) and I4GL-RDS 4.1x (the same x) and SE 5.0y (I'd guess y is 1 because you have the trigger documentation, but could be wrong). } Here is a paste of my /usr/informix/release directory: } } -rw-r--r-- 1 informix informix 838 Apr 3 1995 DBACCESDOC_5.0 } -rw-r--r-- 1 informix informix 88717 Apr 3 1995 ENGREL_5.0 } -rw-r--r-- 1 informix informix 1279 Apr 3 1995 ERRDOC_5.0 } -rw-r--r-- 1 informix informix 2275 Apr 3 1995 INSTALLDOC_5.0 } -rw-r--r-- 1 informix informix 10342 Nov 8 1994 ISQLDOC_4.1 } -rw-r--r-- 1 informix informix 1588 Nov 8 1994 ISQL_4.1 } -rw-r--r-- 1 informix informix 14445 Nov 8 1994 RDSDOC_4.1 } -rw-r--r-- 1 informix informix 975 Nov 8 1994 RDS_4.1 } -rw-r--r-- 1 informix informix 860 Apr 3 1995 SEDOC_5.0 } -rw-r--r-- 1 informix informix 454 Apr 3 1995 SE_5.0 } -rw-r--r-- 1 informix informix 5221 Apr 3 1995 SQLRDOC_5.0 } -rw-r--r-- 1 informix informix 2091 Apr 3 1995 SQLTDOC_5.0 } -rw-r--r-- 1 informix informix 152173 Nov 8 1994 TOOLREL_4.1 } -rw-r--r-- 1 informix informix 799 Apr 3 1995 TRIGGERDOC_5.0 } } Okay, from this I can tell we have a mixture of 4.1 and 5.0 versions of } something .. but I have no idea as to what the actual Informix Version we } are using. Which of these installed release documents would be the } "CORE" informix database engine? SE_5.0 is the primary SE release notes. } Am I going to need I-net and I-Connect to set-up ODBC drivers on a } Windows95 System and connect Access97 or Visual FoxPro to our Informix } Database? I would expect you to need just I-Net; you don't need I-Connect on any of several grounds -- your software predates I-Connect, and you already have a runtime licence with the ISQL and I4GL-RDS products. Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>