Hello,
I've the following problem. I've to read out the data of a custom
application. I think (I'm not sure) this application is using a
Paradox DB to store it's information. I don't know it exactly cause
I'm not familar with paradox at all, but I've found files like *.db,
*.mb, *.px, *.xg*, *.yg* !!!
I need the infomation from this files to combine it with other data
stored in SQL 2000. I'm tried DTS to import the Data but I've got an
"Microsoft JET Database" Error telling me that the table could not be
found or that the table has not the asumed format. It depends on which
*.db File i try to open. Description: Error calling the OPENROWSET
method on the provider.
My Questions, are there some special drivers i need, not included in
MS MDAC Components or must I use a complete Databaseserver in the
Backgroud hosting the DB Files. My developer station has the custom
application NOT installed. The db files seems to have no password set.
I've got the same error when using MS Access to import the data. I
only set the path to the dictionary where the files are in but leave
username and password blank.
HOW TO GET THIS DATA OUT ???
Thank you
Tony 4 11333
Tony,
Before wasting a lot more time, get a copy of Paradox and see if
you can open these files. If not, they probably aren't Paradox files.
The only evidence you give that these are unprotected Paradox files
is that they have Paradox extensions and "seem to have no password
set", whatever that means.
The evidence that they are not unprotected Paradox files seems
stronger - dts doesn't understand them.
I've used the Import/Export Data wizard with the Microsoft Driver
for Paradox successfully, but if you still think these may be Paradox
files, see if Paradox agrees with you.
-- Steve Kass
-- Drew University
-- Ref: 5F4FF6F4-815B-4EE8-AE48-5C556CF24104
TonyMontana wrote: Hello,
I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it exactly cause I'm not familar with paradox at all, but I've found files like *.db, *.mb, *.px, *.xg*, *.yg* !!! I need the infomation from this files to combine it with other data stored in SQL 2000. I'm tried DTS to import the Data but I've got an "Microsoft JET Database" Error telling me that the table could not be found or that the table has not the asumed format. It depends on which *.db File i try to open. Description: Error calling the OPENROWSET method on the provider.
My Questions, are there some special drivers i need, not included in MS MDAC Components or must I use a complete Databaseserver in the Backgroud hosting the DB Files. My developer station has the custom application NOT installed. The db files seems to have no password set. I've got the same error when using MS Access to import the data. I only set the path to the dictionary where the files are in but leave username and password blank.
HOW TO GET THIS DATA OUT ???
Thank you
Tony
Hello Steve,
thanks for your help. I've found a bde installation and now i can
access the tables via the SQL Tool for BDE by Stefan Bodingh www.bodingh.se
so I can assume that the data is not encrypted and not currupt.
Nevertheless i can't
access them via ODBC or the MS PAradox driver. I've tried it on 2 machines.
Is the a command line tool out there which i can use to export the tables to
text [csv] Files? Pherhaps a special one for bde without so much
incompability as the ODBC connection seems to have.
regards
Tony
"Steve Kass" <sk***@drew.edu> schrieb im Newsbeitrag
news:yG*******************@newsread2.news.atl.eart hlink.net... Tony,
Before wasting a lot more time, get a copy of Paradox and see if you can open these files. If not, they probably aren't Paradox files. The only evidence you give that these are unprotected Paradox files is that they have Paradox extensions and "seem to have no password set", whatever that means.
The evidence that they are not unprotected Paradox files seems stronger - dts doesn't understand them.
I've used the Import/Export Data wizard with the Microsoft Driver for Paradox successfully, but if you still think these may be Paradox files, see if Paradox agrees with you.
-- Steve Kass -- Drew University -- Ref: 5F4FF6F4-815B-4EE8-AE48-5C556CF24104
TonyMontana wrote: Hello,
I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it exactly cause I'm not familar with paradox at all, but I've found files like *.db, *.mb, *.px, *.xg*, *.yg* !!! I need the infomation from this files to combine it with other data stored in SQL 2000. I'm tried DTS to import the Data but I've got an "Microsoft JET Database" Error telling me that the table could not be found or that the table has not the asumed format. It depends on which *.db File i try to open. Description: Error calling the OPENROWSET method on the provider.
My Questions, are there some special drivers i need, not included in MS MDAC Components or must I use a complete Databaseserver in the Backgroud hosting the DB Files. My developer station has the custom application NOT installed. The db files seems to have no password set. I've got the same error when using MS Access to import the data. I only set the path to the dictionary where the files are in but leave username and password blank.
HOW TO GET THIS DATA OUT ???
Thank you
Tony
Tony,
I think you might find some people who know in a Paradox
newsgroup. I'm not sure why the MS driver doesn't work.
It only lists Paradox versions up to 5.0, though, so perhaps
can't handle recent versions.
SK
Tony.Montana wrote: Hello Steve,
thanks for your help. I've found a bde installation and now i can access the tables via the SQL Tool for BDE by Stefan Bodingh www.bodingh.se so I can assume that the data is not encrypted and not currupt. Nevertheless i can't access them via ODBC or the MS PAradox driver. I've tried it on 2 machines. Is the a command line tool out there which i can use to export the tables to text [csv] Files? Pherhaps a special one for bde without so much incompability as the ODBC connection seems to have.
regards
Tony
"Steve Kass" <sk***@drew.edu> schrieb im Newsbeitrag news:yG*******************@newsread2.news.atl.eart hlink.net...
Tony,
Before wasting a lot more time, get a copy of Paradox and see if you can open these files. If not, they probably aren't Paradox files. The only evidence you give that these are unprotected Paradox files is that they have Paradox extensions and "seem to have no password set", whatever that means.
The evidence that they are not unprotected Paradox files seems stronger - dts doesn't understand them.
I've used the Import/Export Data wizard with the Microsoft Driver for Paradox successfully, but if you still think these may be Paradox files, see if Paradox agrees with you.
-- Steve Kass -- Drew University -- Ref: 5F4FF6F4-815B-4EE8-AE48-5C556CF24104
TonyMontana wrote:
Hello,
I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it exactly cause I'm not familar with paradox at all, but I've found files like *.db, *.mb, *.px, *.xg*, *.yg* !!! I need the infomation from this files to combine it with other data stored in SQL 2000. I'm tried DTS to import the Data but I've got an "Microsoft JET Database" Error telling me that the table could not be found or that the table has not the asumed format. It depends on which *.db File i try to open. Description: Error calling the OPENROWSET method on the provider.
My Questions, are there some special drivers i need, not included in MS MDAC Components or must I use a complete Databaseserver in the Backgroud hosting the DB Files. My developer station has the custom application NOT installed. The db files seems to have no password set. I've got the same error when using MS Access to import the data. I only set the path to the dictionary where the files are in but leave username and password blank.
HOW TO GET THIS DATA OUT ???
Thank you
Tony
Steve,
I am almost sure the Microsoft stuff read only to what are called LEVEL 5
databases (basically Paradox Version 5 and below). There was Paradox 7, 9,
and 10. Which I think are LEVEL 7 databases. Probably what happend was
that the developer put some field types that are only supported in LEVEL 7
and up.
Oscar....
"Steve Kass" <sk***@drew.edu> wrote in message
news:mp******************@newsread2.news.atl.earth link.net... Tony,
I think you might find some people who know in a Paradox newsgroup. I'm not sure why the MS driver doesn't work. It only lists Paradox versions up to 5.0, though, so perhaps can't handle recent versions.
SK
Tony.Montana wrote: Hello Steve,
thanks for your help. I've found a bde installation and now i can access the tables via the SQL Tool for BDE by Stefan Bodingh
www.bodingh.se so I can assume that the data is not encrypted and not currupt. Nevertheless i can't access them via ODBC or the MS PAradox driver. I've tried it on 2
machines. Is the a command line tool out there which i can use to export the
tables to text [csv] Files? Pherhaps a special one for bde without so much incompability as the ODBC connection seems to have.
regards
Tony
"Steve Kass" <sk***@drew.edu> schrieb im Newsbeitrag news:yG*******************@newsread2.news.atl.eart hlink.net...
Tony,
Before wasting a lot more time, get a copy of Paradox and see if you can open these files. If not, they probably aren't Paradox files. The only evidence you give that these are unprotected Paradox files is that they have Paradox extensions and "seem to have no password set", whatever that means.
The evidence that they are not unprotected Paradox files seems stronger - dts doesn't understand them.
I've used the Import/Export Data wizard with the Microsoft Driver for Paradox successfully, but if you still think these may be Paradox files, see if Paradox agrees with you.
-- Steve Kass -- Drew University -- Ref: 5F4FF6F4-815B-4EE8-AE48-5C556CF24104
TonyMontana wrote:
Hello,
I've the following problem. I've to read out the data of a custom application. I think (I'm not sure) this application is using a Paradox DB to store it's information. I don't know it exactly cause I'm not familar with paradox at all, but I've found files like *.db, *.mb, *.px, *.xg*, *.yg* !!! I need the infomation from this files to combine it with other data stored in SQL 2000. I'm tried DTS to import the Data but I've got an "Microsoft JET Database" Error telling me that the table could not be found or that the table has not the asumed format. It depends on which *.db File i try to open. Description: Error calling the OPENROWSET method on the provider.
My Questions, are there some special drivers i need, not included in MS MDAC Components or must I use a complete Databaseserver in the Backgroud hosting the DB Files. My developer station has the custom application NOT installed. The db files seems to have no password set. I've got the same error when using MS Access to import the data. I only set the path to the dictionary where the files are in but leave username and password blank.
HOW TO GET THIS DATA OUT ???
Thank you
Tony
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Vilmar Brazão de Oliveira |
last post by:
Hi all,
What can be wrong in the database connection bellow to connect paradox?
What is missing??
----------------------------------------------------------------------------...
|
by: Steve Barker |
last post by:
I am trying to access Paradox through a .NET Windows application I am
writing. I have added a Data Connection to the Paradox table in the Server
Explorer of Visual Studio .NET. I have used the...
|
by: Noozer |
last post by:
We've created a new database and need to import the data from our old
database. Both are MS Access databases and each have multiple tables. The
table structure of each table is completely different...
|
by: Jill Elaine |
last post by:
I want to automate the import of 5 encrypted .db (Paradox) tables into
a MS Access 2002 database every time the Access database is opened. I
think I could use the TransferDatabase method to import...
|
by: Eugen Walcher |
last post by:
Hello all, I've tried posting this same question on other newsgroups
with no luck. This group seems to have a lot more activity so I
apologize if you have seen it before.
I'm trying to...
|
by: Roger |
last post by:
Has anyone done this yet? I know it is easily done in Paradox, but I would
like to do it in VB.Net.
Can anyone point me in the right direction?
Thanks,
Rog
|
by: Zamjenska |
last post by:
Hi,
I need to convert Paradox 7 database to any format that user can consume
(xls, mdb...).
I think that I have a Paradox 7 database (files in folder: .db, .px, .x02,
y02 if that is telling you a...
|
by: eselk |
last post by:
I've got an old DOS Paradox database that I can't get rid of. We have
way to many scripts and forms to convert everything at once. Instead
we would like to be able to access the Paradox data from...
|
by: eselk |
last post by:
I've never really setup or used MS SQL Server (just a couple hours, one
day, several months ago). I think MS SQL Server has the ability to use
"linked tables", like MS Access does. Is this...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |