Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2006
    Posts
    3

    Unanswered: Extracting Data from Pervasive Table via ODBC

    hi together,

    i'm trying to extract data from a couple of Pervasive dta files through odbc with an Delphi application. because my customer don't wont touched his database system i had to copy the dta files in a temporary directory to extract data. i have psql 9 installed, the dta files are from the version 7.
    when i try to open the tables i always get the error -19.

    is it possible to open pervasive tables version 7 with psql 9?
    to delete the static path i used updttabl.exe, but i can't open the tables.
    is there any way to solve this problem, maybe importing or converting dta files?

    hoping for your help

    klaus

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Can you open the tables through the PCC?
    Are you using TTable, TQuery, PvTable, PvQuery, or something else to access the table?
    What's the entire error message?
    You don't need to import or convert the data.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Jan 2006
    Posts
    3
    Quote Originally Posted by mirtheil
    Can you open the tables through the PCC?
    Are you using TTable, TQuery, PvTable, PvQuery, or something else to access the table?
    What's the entire error message?
    You don't need to import or convert the data.
    yes i can open some of the tables through pcc, but not all tables i want to open. i always get the error -19 in pcc without discription. the tables i can open, are opened first with version 8 of pcc. after installing pcc 9 i tried to open other tables, but this does't work.

    i'm using tdatabase and ttable in delphi.

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Sounds like you've got paths (either relative or absolute) in the DDFs. Issue the following statement:
    SELECT * FROM X$FILE
    and look at each table that's giving you an error. Specifically, you'll want to look at the XF$LOC field. Ideally, it will only have the file name. If it's got a path, you need to remove them or put the files into the proper path.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  5. #5
    Join Date
    Jan 2006
    Posts
    3
    Quote Originally Posted by mirtheil
    Sounds like you've got paths (either relative or absolute) in the DDFs. Issue the following statement:
    SELECT * FROM X$FILE
    and look at each table that's giving you an error. Specifically, you'll want to look at the XF$LOC field. Ideally, it will only have the file name. If it's got a path, you need to remove them or put the files into the proper path.
    thanks mirtheil, now it works.

  6. #6
    Join Date
    Jan 2006
    Posts
    3

    The invitation to participation in work.

    Attention!
    I am a founder of system of fast earnings of money, I want to inform you good news. Our business begins a new coil in system. Now the system is protected from swindlers on 100 % so - as we have entered into the agreement on the control of purses of our participants with bank. Namely, before reception of translation with a control mark " has earned - receive ", each purse of the participant is checked for performance of the main condition (to put 6 $ on the purse and to dispatch 1 $ on each of six purses) Otherwise a purse - the infringer will receive one translation with a mark has earned - receive , and translations will be automatically returned to the sender. Thus, we have achieved 100 % of work of system.

    Reading it, you can change the life!
    The invitation to participation in work.
    Let's make three steps and we shall help to earn good money each other!

    4 steps to success:
    1. You need to be registered in system Web Money which is to the address http://www.webmoney.ru you should familiarize with the given system as she(it) works, choose optimum for itself a variant of updating of a purse from a pagehttp://www.webmoney.ru and bring 6 $ on the purse. If you do not have those 6 WMZ you need to buy card Web Money (cards a minimum 10 WMZ are sold in usual stalls) and bring 6 $ on yours WMZ in a purse (it(he) begins with letter Z).
    2. Take first number of a purse from the below-mentioned list, send on him(it) 1 $. Important: in line "Note" write [Please, enter into me the list of purses] ". All that you do are legally. Remember! All transfers do with a mark " has earned - receive "!!!
    Send 6 $ on the following purses (in everyone on 1 $):
    1) Z818906725428
    2) Z999774989414
    3) Z23809414162
    4) Z238094141625
    5) Z191738072015
    6) Z383227602759
    Now delete from this list the first purse, having moved thus the list for one line is higher (6-th becomes 5-th, 5-th becomes 4-th...) Also enter in a 6-th line your purse.
    3. As soon as on your account there came the first money delete from the list 1 number. 4, 5, 6 leave on a place, and 2 and 3 displace on 1 a position upwards. Also enter on 3 which was released(exempted), a position number of a purse with which to you has come translation with the note Please, enter into me the list of purses !
    4. Do any changes, but keep the main idea. Place this clause(article) at not less than 200 forums and news lines (News Groups). Remember! Than more you place, - that your income will be higher, and this income will depend directly on you. So, when you will reach(achieve) the first position, you will have thousand dollars!
    It costs(stands) 6 $ and absolutely trifling work!!!!!!!!
    Engage in it now, not putting off! Since today YOU " money can already get to another . Time - money!
    And now I to you shall tell, why you in any case lose nothing, but only win!
    Important
    Let's tell, from 200 accommodations I shall receive only 5 answers (very low figure). Means, I shall make 5 $, being on 6-th position in the list. Now these 5 people do besides the MINIMUM 200 accommodations with my purse on 5-th position, and only 5 people answer those to the first 5 is already 25 $. Further 25 people do(make) these on 200 accommodations with my purse on 4-th line and only 5 answer - my income 125 $. Now these 125 people having placed and having received only on 5 answers, give me 625 $ the profit (I on 3 positions).
    Further is more ridiculous: these 625 do on a minimum of 200 accommodations with me on 2-nd line and only 5 people answer are 3125 $. Most interesting it that 3125 people will make these even on 200 accommodations, well and if they(he,it) will be answered only with 5 people I already receive 15625 $. Whether not so, impressive figure? And all this for the initial contribution in 6 $. And not considering the profit which you receive it when you will be added in the list with people which you have sent money! When you in the list already are not present, you simply send 6 $ to same people from the list and put the purse on 6 position and again place. You can present yourselves, that thousand people from all world join the Internet and read these clauses(articles) every day. As well as you now read this!!!
    Well and the last: It is really great axiom to receive something it is necessary to give something and what to receive it would be necessary to give even more.
    Good luck!!!

    The information about WebMoney:<http://www.owebmoney.ru/kurs.shtml>
    How to distribute the information in forums:
    1. We open rambler.ru, yandex.ru, google.com, aport.ru, yahoo.com (or any another).
    2. We write in a line of search a phrase: a forum to begin a new theme (without inverted commas).
    3. You will find thousand forums on which you can place the announcement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •