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 Help !!! Expand / Collapse
Author
Message
Posted Monday, April 10, 2006 5:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

Hi Guys,

I've got a collection of paradox tables that I need to connect to SQL server 2000.  I've been using DTS (with paradox 5.x), but as soon as I try to import/access the Data I get the following error :

 

Error Source: Microsoft JET database Engine

Error Des : Table is not in the expected format

Contex: Error calling OpenRowset on the provider

 

Any idea how I can around this, I don't have Paradox, just the tables .

 

Thanks in advance

Dave

LSF Systems Developer

 

 

 

 

 

 

 

 

Post #272168
Posted Tuesday, April 11, 2006 3:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 18, 2013 8:39 AM
Points: 6, Visits: 29

Hello,

we had the same problem, when we have been importing a customer's data from _1992_ from an old PDX application to a new SQL Server based web app. We ended up by using a very good and cheap (almost free) tool (http://www.scalabium.com/pdx/index.htm; Paradox Viewer) to do a dump to Access first ...

No problems encountered afterwards

Good luck,

Hendrik




Post #272398
Posted Tuesday, April 11, 2006 4:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 3:34 AM
Points: 139, Visits: 4,614

I'm using DTS and Paradox (version 9) and Microsoft driver to work with Paradox has some problems, for example you cannot work with password encrypted tables. I'm trying to use now the ODBC driver delivered with Paradox (created by Intersolv) and it seems to work quite fine, although I've the problem that it's asking me the password when I want to pass it by code. May be you should try it.

Another thing it to check if the tables are corrupted.


Josep.
Post #272413
Posted Tuesday, April 11, 2006 5:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

HI

this seem to be working really well.(http://www.scalabium.com/pdx/index.htm;

 

Thanks

dave

Post #272416
Posted Tuesday, April 11, 2006 8:21 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 10, 2007 9:50 AM
Points: 461, Visits: 1
I'll agree with you that Paradox9 and SQL do not get along well! Not building in a mechanism to access passworded tables into the ODBC driver caused me some major headaches in the past!
Post #272477
Posted Wednesday, April 12, 2006 1:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 3:34 AM
Points: 139, Visits: 4,614

Then the question is... How did you solve the password problem?? Because what I've done is unprotect the tables I want to use in DTS. So it could be nice to do it in a better way.

And Dave, this link seems cool. Maybe I will use in the future the ActiveX control for Paradox. Hopping it works fine. Thanks.


Josep.
Post #272600
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse