Re: Installing Postegres side-by-side with M$ SQL server]]

Paul Lambert <paul.lambert@xxxxxxxxxxxxxxxxxx> · Tue, 23 Jan 2007 08:51:44 +0900

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@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxxxxxxx <http://www.reynolds.com.au>
------------------------------------------------------------------------------------
For AutoLedgers technical support, please send an email to helpdesk@xxxxxxxxxxxxxxxxxx.