How to open Paradox 7.x Database files in Sql Server

Posted on 2009-12-27
Last Modified: 2012-05-08
I want to open paradox database files (*.db) in sql server 2005 or 2008. The db files are in version paradox 7. Can anyone give me a solution to do that?
Question by:MickaelE
    LVL 57

    Expert Comment

    by:Raja Jegan R
    No, You can't open Paradox Database Files in SQL Server.
    Instead open your (*.db) database file in Paradox and then Import records into SQL Server if required..
    LVL 6

    Accepted Solution

    You can use OpenQuery and create a link to the Paradox database:
    --create the linked server
    exec sp_addlinkedserver @server = 'MyLinkedServerName',  
    @srvproduct = '',  
    @provider = 'Microsoft.Jet.OLEDB.4.0',
    @datasrc = '\\network share\Paradox directory where .db files are located',  -- Please specify only folder where your DB file(s) are located
    @location = '',  
    @provstr = 'Paradox 5.X;'
    select * from openquery(MyLinkedServerName, 'select * from city ')
    select * from openquery(MyLinkedServerName, 'select * from city where city="testCity"')
    insert into openquery(MyLinkedServerName,'select * from city')(city, county, taxjur)
    select * from openquery(MyLinkedServerName, 'select * from city where city="testCity"')
    update openquery(MyLinkedServerName,'select * from city where city = "testCity"')
    set county = 'test2County2'
    select * from openquery(MyLinkedServerName, 'select * from city where city="testCity"')
    delete openquery(MyLinkedServerName,'select * from city where city = "testCity"')
    select * from openquery(MyLinkedServerName, 'select * from city

    Please see:
    LVL 51

    Assisted Solution

    by:Mark Wills
    Now, Paradox 7 files can be a little bit "testy" as you can see from the above link...

    Think this one might be of more benefit :

    So, there are a few ways of achieving it, and yes it can be done...

    Best way I know how to do it is via a linked server. Make sure you have the ACE drivers (can get them from MS)  happily lives side by side any existing stuff...

    -- create a linked server - this (and the login) can be a one time step - or - on demand...
    EXEC master.dbo.sp_addlinkedserver @server = N'MyPDOX'
               , @srvproduct=N'Paradox7'
               , @provider=N'Microsoft.ACE.OLEDB.12.0'
               , @datasrc=N'C:\WHATEVER\WORKING'
               , @provstr=N'Paradox 7.x'

    --Set up login mappings (just ADMIN - wants something).
    EXEC sp_addlinkedsrvlogin MyPDOX, FALSE, NULL, Admin, NULL

    --List the tables in the linked server - normally do this just as a test to see what SQL can see...
    EXEC sp_tables_ex MyPDOX

    -- then use the four part identifier like any other table
    SELECT * FROM mypdox...debtorversion7

    -- at the end of it all, need to drop the server, or, keep it up (but then do not try to create it every time either)
    sp_dropserver 'MyPDOX', 'droplogins';

    LVL 51

    Expert Comment

    by:Mark Wills
    Oh, and with the linked server, most definitely can use the openquery() as if it were a table as per PJBX post...

    You will also note from my link above that the Jet engine did work in that other thread, and while it works fine for paradox 5 tables, it can run into problems for paradox 7 - so take the time to test and check which is the best solution for you.
    LVL 51

    Expert Comment

    by:Mark Wills
    Well I know that my post works. ID:26129607

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now