Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Paradox Expand / Collapse
Author
Message
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
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: Today @ 1:13 PM
Points: 3,219, Visits: 2,356

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
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
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, March 21, 2014 9:47 AM
Points: 2, Visits: 11
Very good.

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

Thank you
Andrea
Post #909654
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, March 21, 2014 9:47 AM
Points: 2, Visits: 11
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