I think is the problem is that I lost my mind the day I agreed to do this job <g>.
I just tried and had partial success. When I created a table in VFP with just one field, it worked, not every time I ran the test but most of times.
But when I have two or more fields in the table, I get errors. I think I already tried to use the COPY TO..(as you suggested), but I will do it again, just to be sure.
>It may be a problem because you're creatingg VFP table. You can convert it to Fox 2.6 format usint COPY TO ... TYPE FOX2X command.
>
>>Sergey,
>>If I may ask you another question. Since the ODBC driver you sent me still does not work, I presume the problem is not the driver but how I use it.
>>
>>When I create a table in VFP with command CREATE TABLE...., does the created table conform to Foxpro 2.6 standard/format. The Data Exchange Tool that comes with HanDBase product says that to transfer data from Palm database to ODBC data source should be done to Foxpro 2.6 table. I don't have FP 2.6 (or any other version, for that matter).
>>I was thinking, maybe this is my problem?
>>
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham