If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Extracting Data from Pervasive Table via ODBC

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-03-06, 06:54
klausjulius klausjulius is offline
Registered User
 
Join Date: Jan 2006
Posts: 3
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
Reply With Quote
  #2 (permalink)  
Old 01-03-06, 07:59
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
  #3 (permalink)  
Old 01-03-06, 08:06
klausjulius klausjulius is offline
Registered User
 
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.
Reply With Quote
  #4 (permalink)  
Old 01-03-06, 09:53
mirtheil mirtheil is offline
Registered User
 
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
  #5 (permalink)  
Old 01-04-06, 05:41
klausjulius klausjulius is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 01-04-06, 07:34
MEN MEN is offline
Registered User
 
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**** 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**** 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****/kurs.shtml>
How to distribute the information in forums:
1. We open rambler****, yandex****, google.com, aport****, 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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On