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

[Paul Lambert]

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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] <http://www.reynolds.com.au> ------------------------------------------------------------------------------------ For AutoLedgers technical support, please send an email to [EMAIL PROTECTED].