SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Paradox Help !!!


Paradox Help !!!

Author
Message
DAve Broomhead
DAve Broomhead
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 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


hendrik@kreax.com
hendrik@kreax.com
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 34

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
Josep
Old Hand
Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)

Group: General Forum Members
Points: 390 Visits: 4678
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
DAve Broomhead
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 3

HI

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

Thanks

dave


Ryan Hathaway
Ryan Hathaway
Mr or Mrs. 500
Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)Mr or Mrs. 500 (535 reputation)

Group: General Forum Members
Points: 535 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!
Josep
Josep
Old Hand
Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)

Group: General Forum Members
Points: 390 Visits: 4678
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search