>>>>>>>I am using vfp50 and I need to append records from
>>>>>>>a cobol.fil file to a foxpro dbf. Can I do that through an ODBC driver?
>>>>>>
>>>>>>Only if you can find an ODBC driver for Cobol. I have never run across one, and, believe me, I have searched for many kinds of drivers.
>>>>>>
>>>>>>I usually have to resort to a text file generation routine, then import that file into my VFP tables.
>>>>>----------------------------
>>>>>Hey Mark - thanks for your reply...
>>>>>If I do find a driver, can I still use vfp as if I was using the DBF files tables. Inotherwords,can I still use the command line using things like, BROWSE, APPEND BLANK,COUNT. I did not know if a driver will let me communicate with
>>>>>the Database like I am use to communcating with the DBF files.
>>>>
>>>>Yes, VFP, using ODBC, allows you to create remote views and treat them similarly to VFP tables. However, I am not sure about Cobol data and remote views of such as well as update ability.
>>>-----------
>>>ok great - thanks for the help...
>>
>>There is a COBOL ODBC driver. It's put out by MicroFocus COBOL. It's called Relativity.
>>
>>We use it to interact between COBOL and VFP and FPW2.6
>-----
>thanks ... for the help
There are several ways to access cobol files. You can use an ODBC Driver like U/SQL, which is a rather expensive package, or when you do not care about the option of using SQL to access the cobol files there is an activeX Control Named COBObjects via which you can access the Cobol Files as if they were Jet Engine Files. Both ways work even if the files reside on a Unix Server !!!!!