Paradox Help !!!

• DAve Broomhead

  Old Hand

  Points: 301

  More actions

  April 10, 2006 at 5:45 am

  #167807

  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

   

   

   

   

   

   

   

   

• hendrik@kreax.com

  Valued Member

  Points: 63

  More actions

  April 11, 2006 at 3:54 am

  #631868

  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

• Josep

  SSCommitted

  Points: 1518

  More actions

  April 11, 2006 at 4:55 am

  #631881

  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.

• DAve Broomhead

  Old Hand

  Points: 301

  More actions

  April 11, 2006 at 5:15 am

  #631884

  HI

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

   

  Thanks

  dave

• Ryan Hathaway

  SSC Eights!

  Points: 827

  More actions

  April 11, 2006 at 8:21 am

  #631933

  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!

• Josep

  SSCommitted

  Points: 1518

  More actions

  April 12, 2006 at 1:41 am

  #632022

  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.