Old Informix Database connectivity???
BJDOBS
3.30.12 ... this version has .dat files with .idx index files. I have
linked to the informix data directory using the latest version of Samba and
was wondering if anyone knows of a way to just read these .dat files
directly into Access 2000 much the way it can read .dbf files? Being able to
also write would be great however at this point reading is all that is
necessary.
I can dump all the tables manually and then import back into Access but I
was hoping someone would have a way to read the data directly
Thanx
Terry
Rob Vorbroker
Obviously if there are tablename.dat and tablename.idx files this
Informix database is a version of SE or Standard Engine. Since this
has recently (last few years) been ported to Linux at least a NEW version
of the SE and the current version of the Client SDK talk to each other.
The Client SDK would contain the ODBC drivers necessary to communicate
a new/current version of SE with Access. Given you are on v3.30.12 your
mileage may vary. If you go to www.ibm.com/informix then look for the
Evaluate
web page (or just search on Client SDK) you may find what you are looking
for.
NOTE: You may also be just totally out of luck - if the new Client SDK
doesn't work - contact your local informix representative. (I can't believe
I said that with a straight face - LOMAROTF)
Rob Vorbroker
Malcolm Weallans
Warning- warning
Informix 3.3 alert.
I think the requester is really out of luck. Version 3.30 never existed
for ISQL, or 4GL, or even C-ISAM. But Informix 3.3 existed before ISQL.
And in that case there is no way even with client SDK of any version.
regards
Malcolm
Thanx
Terry
DISCLAIMER
This message contains confidential information and is intended only for
the individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. E-mail transmission cannot be
guaranteed to be secure or error-free as information could be
intercepted, corrupted, lost, destroyed, arrive late or incomplete, or
contain viruses. The sender therefore does not accept liability for any
errors or omissions in the contents of this message, which arise as a
result of e-mail transmission. If verification is required please
request a hard-copy version.
Rob Vorbroker
Good Catch Malcolm - my brain didn't fire on the 3.3 that it was
that 3.3...I just assumed it was a pre-Turbo version of SE.
You are right the requestor is out of luck or as the younger set
says over here truly 'HOSED'.
Assuming you want to CONVERT out of pre-1986 version of the DB
you may want to contact Informix for tools to do table unloads
to flat files (ASCII) which can be pipe delimited so that you can
load it into something else (whatever is your preference).
If you need professional help (and you may) then contact me directly
and we can work out some sort of arrangement. If you are someplace
warm than that might just be covering travel expenses and golf course
fees - eh Malcolm.
Rob
Jonathan Leffler
Amazing! It isn't even the most recent version of the software. It
pre-dates the SQL system (probably a 1985 or 1986 release). The data
dictionary is stored in the xyz.dbd file; the .dat files contain the data,
and the .idx files contain the indexes.
It isn't officially Y2K-safe (it wasn't even reviewed for Y2K-safety, being
officially dead as a product), though since it has a nebulous concept of
century, it might be OK as long as you don't do date-range comparisons
across the turn of the century.
I don't know of a particular way to access the data - read-only access is
probably readily provided, but write access would require something built
with the correct version of C-ISAM. I think that unload and import is the
'simplest' solution, using lots of reasonably well-known technology, but
not very efficient or pleasant.
----- Message from "BJDOBS" <bjdob...@yahoo.ca> on Thu, 26 Sep 2002
18:27:48 GMT -----
>I have a client who is really attached to his SCO INFORMIX database ver
>3.30.12 ... this version has .dat files with .idx index files. I have
>linked to the informix data directory using the latest version of Samba
and
>was wondering if anyone knows of a way to just read these .dat files
>directly into Access 2000 much the way it can read .dbf files? Being able
to
>also write would be great however at this point reading is all that is
>necessary.
>
>I can dump all the tables manually and then import back into Access but I
>was hoping someone would have a way to read the data directly
>
>Thanx
>Terry
It will be interesting to see how this message is formatted after having
been subjected to Lotus Notes...
--
Jonathan Leffler (jlef...@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management Solutions
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"
JJ
was called "Informix" back then - it was probably when they were Relational
Database Systems, Inc.
I dealt with a conversion from the pre-SQL RDS a long time ago. From what I
recall, it had ACE Reports and Perform Screens. You could use ACE to write
out delimited files from a query. I am pretty sure there was also the
equivalent of an UNLOAD command in the query language.
Another option would be to perhaps look at Data Junction
(www.datajunction.com) - it can extract data from C-ISAM files (which I'm
pretty sure is what your .dat and .idx files are).
"BJDOBS" <bjdob...@yahoo.ca> wrote in message
news:EkIk9.401002$v53.18...@news3.calgary.shaw.ca...
Malcolm Weallans
If people will pay the expenses and golf course fees we maybe could
arrange an IIUG-Ryder Cup. Not that I'm rubbing it in or anything! I'm
sure I could find 12 Informix users who play golf from the UK, if Rob
finds 12 from the USA, the only challenge left is the expenses. And of
course the sponsorship, the television deals, etc. I guess the IIUG
budget won't stretch to that!
regards
Malcolm
Rob
Warning- warning
Informix 3.3 alert.
regards
Malcolm
I have a client who is really attached to his SCO INFORMIX database ver
3.30.12 ... this version has .dat files with .idx index files. I have
linked to the informix data directory using the latest version of Samba
and
was wondering if anyone knows of a way to just read these .dat files
directly into Access 2000 much the way it can read .dbf files? Being
able to
also write would be great however at this point reading is all that is
necessary.
I can dump all the tables manually and then import back into Access but
I
was hoping someone would have a way to read the data directly
Thanx
Terry
DISCLAIMER
Dawn Walker
Have you tried importing it into Access using one of the other database
formats? I recently imported some ancient FoxPro data into Access by
selecting the dBase III option. There's a good chance it won't work,
but it'll only take a second to try!