Re: BIG ROOKIE QUESTION #2

Ed Bragg wrote: > > How do I tell what version of Informix we are running? 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. BTW, > we don't have the manuals .. our Software Developer kept those for some > reason .. guess they didn't want us to figure out how simple their database > is afterall. I'm pretty sure we have several products of informix. 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? > > 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? > > Regards, > Ed Ed, Sorry but the prior message caontains an error, I looked at your 'ls' output again and saw you are using Standard Engine (SE) so the tbstat command does not work on your version. the command you can use is: dbschema -V (this works on all versions) SORRY, SORRY, SORRY !!!! Regards, Rob Prop -- =============================================================== Rob Prop Tel. : +31-164-255300 Consultant Fax. : +31-164-246162 Informa Automatisering bv Email: rprop@concepts.nl Bergen op Zoom informa@pi.net The Netherlands Web : http://www.informa.nl ===============================================================