• Thanks for that - it has added a bit of confusion for me though - I haven't got the 32 bit drivers installed let alone configured although the ODBC connection does exist in 32 and 64 ODBC as suggested

    I am trying to connect 64 bit to 64 bit on the assumption that I'm running 64 bit database (SQL) on 64 bit O/S connecting to 64 bit database (Oracle) on 64 bit O/S (Linux) - so surely I need to consider 64 configuration?

    Please excuse me for maybe looking at this over simplistically - only worked with Microsoft products before.

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx