Ron Johnson wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/22/07 14:01, Paul Lambert wrote:
  
Ron Johnson wrote: On 01/22/07 07:09, Paul Lambert wrote:

    
Alban Hertroys wrote:

          
Paul Lambert wrote:


            
[snip]

    
[snip]

  
We've got pretty new hardware - DS15's, DS25's, Itaniums and so
forth. But we don't run any DB app on it, most of our data sits
in RMS files or flat binary files - even text files in a few
instances, thus making standard DB queries nigh on impossible
with the exception of a report generator we've built into the
app, but that has nowhere near the capabilities of something like
crystal reports or M$ Access, thus the need for a 'replica'
standard db model. We looked at Mimer on VMS for a while but
    

CONNX & Easysoft appear to offer ODBC drivers for (probably only
indexed) RMS files, if that helps you.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFtSFwS9HxQb37XmcRArreAJ0Y7hxAGemjhMnukvyHGLWDwWy1/QCdHx4t
jJoVFkzeucdDivL9QEJXm5k=
=uxvA
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly


  
Probably wouldn't - as I said we use a mix of binary, rms (some indexed, some not) and text files - so an
odbc driver into RMS files would only give us a portion of the database. A lot of what I replicate to SQL
server at the moment comes from flat binary files and a couple of the tables from text files, the rest from
RMS files. Having this mix of types would mean we need to manage things ourselves, thus having our main
in-house faux-database engine forward messages directly to the Weendoze box which then uses ODBC to
pump the data into the database of my choice. It would make things a lot easier to manage if I could forward
it to an ODBC database on the VMS machine - oracle is just way out of our reach though.

Thanks for the suggestion though, that may come in handy down the track for another project I'm looking at.

P.
-- 
Paul Lambert
Database Administrator
AutoLedgers
Level 3, 823 Wellington Street, West Perth, W.A. 6005
Postal: P.O. Box 106, West Perth, W.A. 6872
Ph: 08 9217 5086 Fax: 08 9217 5055
AutoLedgers Technical Support Desk: 1800 649 987 (Free call) 08 9217 5050 (Perth local and mobile)
Email: paul.lambert@autoledgers.com.au <http://www.reynolds.com.au>
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to helpdesk@autoledgers.com.au.