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, It looks that you have the 5.0x Online version with 4.1x tools (4GL), you can tell the exact version number when you give the command: tbstat -V, this should give you the version number back. I think you need to buy Connection software for the server and the client, just call Informix and they can tell you exactly what you need. I didn't realize it in the first mail but maybe you can use the ODBC driver from windows (check out 16 or 32-bit version ?). I hope this helped you. 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 ===============================================================