Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Development » Paradox
Add to briefcase

Paradox Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
DAve Broomhead
Posted Wednesday, April 12, 2006 4:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 16, 2008 6:15 AM
Points: 19, Visits: 3

Hi Folks

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

Any thoughts ?

 Thanks

 

Dave
Post #272634
rudy - Doctor "X"
Posted Thursday, April 13, 2006 1:32 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:11 PM
Points: 3,108, Visits: 2,114

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.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #273224
TimS
Posted Thursday, April 13, 2006 6:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, March 31, 2008 10:03 AM
Points: 79, Visits: 2
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


Post #273275
andrea pepe
Posted Friday, April 23, 2010 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 14, 2012 7:13 AM
Points: 2, Visits: 9
Very good.

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

Thank you
Andrea
Post #909654
andrea pepe
Posted Monday, May 17, 2010 5:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 14, 2012 7:13 AM
Points: 2, Visits: 9
I've resolved but I need to install also BDEInfoSetup.EXE.

Thank you,

Andrea Pepe.
Post #922810
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.