Paradox

  • Hi Folks

    Is it possible to access a Paradox table through Query Analyzer, can OpenRowSource be used this way? 

    Any thoughts ?

     Thanks

     

    Dave

  • Check out this link: http://www.connectionstrings.com/

    It has a Paradox section and 'stuff' that relates to Access and .NET. So I'd guess you could convert that information into an Openquery. Unfortunately I do not have Paradox to test it with.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • Figured it out

    SELECT *

    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'paradox 5.x;database=C:\Trax\COM\private\scratch\', carriers)

    Where the paradox 9 file is at this path C:\Trax\COM\private\scratch\carriers.db

    NOTE: I always heard it was not safe to write using MS driver. No idea if its true.

    Only Tested under SQL 2000.

    Tim S

    This below also worked

    SELECT *

    FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

    'paradox 7.x;database=C:\Trax\COM\private\scratch\', carriers)

    This linked and above post helped

    http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-03/0044.html

  • Very good.

    I had some problems on paradox and with this post i've resolved.

    Thank you

    Andrea

  • I've resolved but I need to install also BDEInfoSetup.EXE.

    Thank you,

    Andrea Pepe.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply