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.