Re: need SCO Unix help please

Thanks. Initially, none of them worked. I was able to crank up dbschema and dbexport. dbschema showed v7.23. Then I tried these commands again. The first two worked, the second two did not. (The two that worked showed the same version as dbschema.) The fact that any worked at all, I guess had to do with my having added "/usr/informix/bin" to the PATH. Until I did that, I couldn't get dbschema or dbexport to work either. Even when I was in the /bin directory itself. Appreciate the help, Tom On 3 Apr 2004 13:28:42 -0800, dryburghj@yahoo.com (scottishpoet) wrote: >I'll assume you ar enot running cloudscape, redbrick or illustra.... > >If its SE 4 or 5 then > bcheck -V >If its SE 7 the > secheck -V > >If its OnLine 4 or 5 then > tbstat -V > >If its Online 6,7,8 or 9 then > onstat -V> >Alternatively log in as root, and in $INFORMIXDIR/etc there should be >a hidden file, .crfile > >That should tell you wnat products were installed in what arder, >oldest product at the top of the file > > > > > >Tom <tcsmith@mindspring.com> wrote in message news:<tp3s60t6d0k7rkfq8c99gbeibik75nh83i@4ax.com>... >> I have inherited a server which runs SCO Unix Open Server Release 5. >> I know the server that it replaced (it was a year 2k upgrade) ran an >> Informix db engine. (I don't know what version.) I'm assuming that >> the current version is 7, but I don't know. (This server is only >> occasionally used for reference, and there has been no one to watch >> over it.) The last time I worked with SCO was about 5 years ago... >> >> How would I go about finding out what the db engine is, and what >> version? How can I find out the db name(s)? >> >> I'd like to use an ODBC connection from my XP Pro client to suck out >> what data I can, and I'm hoping that it has what this scenario would >> require, on the server end. I have an Informix v7 driver on my >> client, but I need to know what the db name(s) is/are, etc. >> >> Any help/guidance you can impart would be most appreciated. >> >> Thanks in advance, >> >> Tom

Tom, Here is the ODBC setup from an actual similar installation of Informix Standard Engine (which you have) on SCO 5.0.5 (host name "scosysv"): # uname -a SCO_SV scosysv 3.2 5.0.5 i386 # dbaccess -V DB-Access Version 7.23.UC13 # grep sqlexecd /etc/services sqlexecd 10002/tcp Informix Standard Engine # grep sqlexecd $INFORMIXDIR/etc/sqlhosts sqlexecd setlitcp scosysv sqlexecd Command to start the host network connection module (make sure DBPATH is set): $INFORMIXDIR/lib/sqlexecd sqlexecd ODBC driver settings: Server name: sqlexecd Host name: scosysv Service: 10002 Protocol: sesoctcp Regards, Doug Lawry www.douglawry.webhop.org "Tom" <tcsmith@mindspring.com> wrote in message news:pf24701f8c2ivbqub73mhc9u808gbb4lba@4ax.com... > Thanks. Initially, none of them worked. I was able to crank up > dbschema and dbexport. dbschema showed v7.23. Then I tried these > commands again. The first two worked, the second two did not. (The > two that worked showed the same version as dbschema.) The fact that > any worked at all, I guess had to do with my having added > "/usr/informix/bin" to the PATH. Until I did that, I couldn't get > dbschema or dbexport to work either. Even when I was in the /bin > directory itself. > > Appreciate the help, > > Tom > > > On 3 Apr 2004 13:28:42 -0800, dryburghj@yahoo.com (scottishpoet) > wrote: > > >I'll assume you ar enot running cloudscape, redbrick or illustra.... > > > >If its SE 4 or 5 then > > bcheck -V > >If its SE 7 the > > secheck -V > > > >If its OnLine 4 or 5 then > > tbstat -V > > > >If its Online 6,7,8 or 9 then > > onstat -V> > > >Alternatively log in as root, and in $INFORMIXDIR/etc there should be > >a hidden file, .crfile > > > >That should tell you wnat products were installed in what arder, > >oldest product at the top of the file > > > > > >Tom <tcsmith@mindspring.com> wrote in message news:<tp3s60t6d0k7rkfq8c99gbeibik75nh83i@4ax.com>... > >> I have inherited a server which runs SCO Unix Open Server Release 5. > >> I know the server that it replaced (it was a year 2k upgrade) ran an > >> Informix db engine. (I don't know what version.) I'm assuming that > >> the current version is 7, but I don't know. (This server is only > >> occasionally used for reference, and there has been no one to watch > >> over it.) The last time I worked with SCO was about 5 years ago... > >> > >> How would I go about finding out what the db engine is, and what > >> version? How can I find out the db name(s)? > >> > >> I'd like to use an ODBC connection from my XP Pro client to suck out > >> what data I can, and I'm hoping that it has what this scenario would > >> require, on the server end. I have an Informix v7 driver on my > >> client, but I need to know what the db name(s) is/are, etc. > >> > >> Any help/guidance you can impart would be most appreciated. > >> > >> Thanks in advance, > >> > >> Tom

Thanks. On Tue, 6 Apr 2004 12:07:20 +0100, "Doug Lawry" <lawry@nildram.co.uk> wrote: >Tom, > >Here is the ODBC setup from an actual similar installation of Informix >Standard Engine (which you have) on SCO 5.0.5 (host name "scosysv"): > > # uname -a > SCO_SV scosysv 3.2 5.0.5 i386 > # dbaccess -V > DB-Access Version 7.23.UC13 > # grep sqlexecd /etc/services> sqlexecd 10002/tcp Informix Standard Engine > # grep sqlexecd $INFORMIXDIR/etc/sqlhosts > sqlexecd setlitcp scosysv sqlexecd> >Command to start the host network connection module (make sure DBPATH is >set): > > $INFORMIXDIR/lib/sqlexecd sqlexecd > >ODBC driver settings: > > Server name: sqlexecd > Host name: scosysv > Service: 10002 > Protocol: sesoctcp > >Regards, >Doug Lawry >www.douglawry.webhop.org > > >"Tom" <tcsmith@mindspring.com> wrote in message >news:pf24701f8c2ivbqub73mhc9u808gbb4lba@4ax.com... >> Thanks. Initially, none of them worked. I was able to crank up >> dbschema and dbexport. dbschema showed v7.23. Then I tried these >> commands again. The first two worked, the second two did not. (The >> two that worked showed the same version as dbschema.) The fact that >> any worked at all, I guess had to do with my having added >> "/usr/informix/bin" to the PATH. Until I did that, I couldn't get >> dbschema or dbexport to work either. Even when I was in the /bin >> directory itself. >> >> Appreciate the help, >> >> Tom >> >> >> On 3 Apr 2004 13:28:42 -0800, dryburghj@yahoo.com (scottishpoet) >> wrote: >> >> >I'll assume you ar enot running cloudscape, redbrick or illustra.... >> > >> >If its SE 4 or 5 then >> > bcheck -V >> >If its SE 7 the >> > secheck -V >> > >> >If its OnLine 4 or 5 then >> > tbstat -V >> > >> >If its Online 6,7,8 or 9 then >> > onstat -V>> > >> >Alternatively log in as root, and in $INFORMIXDIR/etc there should be >> >a hidden file, .crfile >> > >> >That should tell you wnat products were installed in what arder, >> >oldest product at the top of the file >> > >> > >> >Tom <tcsmith@mindspring.com> wrote in message >news:<tp3s60t6d0k7rkfq8c99gbeibik75nh83i@4ax.com>... >> >> I have inherited a server which runs SCO Unix Open Server Release 5. >> >> I know the server that it replaced (it was a year 2k upgrade) ran an >> >> Informix db engine. (I don't know what version.) I'm assuming that >> >> the current version is 7, but I don't know. (This server is only >> >> occasionally used for reference, and there has been no one to watch >> >> over it.) The last time I worked with SCO was about 5 years ago... >> >> >> >> How would I go about finding out what the db engine is, and what >> >> version? How can I find out the db name(s)? >> >> >> >> I'd like to use an ODBC connection from my XP Pro client to suck out >> >> what data I can, and I'm hoping that it has what this scenario would >> >> require, on the server end. I have an Informix v7 driver on my >> >> client, but I need to know what the db name(s) is/are, etc. >> >> >> >> Any help/guidance you can impart would be most appreciated. >> >> >> >> Thanks in advance, >> >> >> >> Tom >